crss-datainterface-task-ingest.yml 3.5 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131
  1. spring:
  2. crss-emdb:
  3. datasource:
  4. jdbcUrl: ${crss.emdb}
  5. username: crss_tod
  6. password: crss_tod
  7. driverClassName: oracle.jdbc.OracleDriver
  8. connectionTimeout: 150000
  9. maximumPoolSize: 3
  10. crss-dataflow:
  11. datasource:
  12. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=dataflow
  13. username: crss_dataflow
  14. password: lgcCpwy0
  15. driverClassName: com.edb.Driver
  16. connectionTimeout: 150000
  17. maximumPoolSize: 3
  18. test-on-borrow: true
  19. validation-query: SELECT 1
  20. crss-nmms:
  21. datasource:
  22. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=nmms
  23. username: crss_nmms
  24. password: lbgg1i2Y
  25. driverClassName: com.edb.Driver
  26. connectionTimeout: 150000
  27. maximumPoolSize: 3
  28. test-on-borrow: true
  29. validation-query: SELECT 1
  30. crss-registration:
  31. datasource:
  32. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=registration
  33. username: crss_registration
  34. password: 51UF3JA9
  35. driverClassName: com.edb.Driver
  36. connectionTimeout: 150000
  37. maximumPoolSize: 3
  38. test-on-borrow: true
  39. validation-query: SELECT 1
  40. crss-stl:
  41. datasource:
  42. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=settlement&ApplicationName=stlApp
  43. username: crss_settlement
  44. password: i17SMOPm
  45. driverClassName: com.edb.Driver
  46. connectionTimeout: 150000
  47. maximumPoolSize: 3
  48. test-on-borrow: true
  49. validation-query: SELECT 1
  50. crss-scheduler:
  51. datasource:
  52. jdbcUrl: jdbc:edb://${crss.database.ip}:5432/crss?currentSchema=scheduler
  53. username: crss_scheduler
  54. password: 5Q4AY59T
  55. driverClassName: com.edb.Driver
  56. jpa:
  57. show-sql: false
  58. generate-ddl: false
  59. open-in-view: false
  60. properties:
  61. hibernate:
  62. dialect: org.hibernate.dialect.PostgreSQLDialect
  63. ddl-auto: none
  64. hbm2ddl:
  65. auto: none
  66. cloud:
  67. task:
  68. initialize:
  69. enable: false
  70. batch:
  71. initializer:
  72. enabled: false
  73. logging:
  74. level:
  75. com.pemc.crss: DEBUG
  76. batch:
  77. # resourceLocation: "file:target/libs/crss-datainterface-task-ingest-1.0.0.BUILD-SNAPSHOT.jar"
  78. partitionSize:
  79. mq: 1500
  80. ssla: 1500
  81. report: 1500
  82. importPrices: 100
  83. autoMinusDaysAgo: 2
  84. mqreport:
  85. directory: /tmp/
  86. sftp:
  87. credentials:
  88. #username: pemc
  89. #password: 123qwe
  90. username: crss_sftp_rbcq
  91. password: Pemc1234
  92. #host: sftp.marathon.l4lb.thisdcos.directory
  93. host: 192.168.94.82
  94. port: 22
  95. workingDirectory: /rbcq
  96. privateKey:
  97. database:
  98. emdb:
  99. rtu-db: "SNAPSHOT_MVIEW"
  100. energy-price-sched-db: "ENERGY_MVIEW"
  101. reserve-price-sched-db: "RESERVE_MVIEW"
  102. nmms:
  103. rtu-db: "TXN_RTU"
  104. energy-price-sched-db: "TXN_ENERGY_PRICE_SCHED"
  105. reserve-price-sched-db: "TXN_RESERVE_PRICE_SCHED"
  106. reserve-bcq-db: "TXN_RESERVE_BCQ"
  107. reserve-adj-db: "TXN_RESERVE_PAYMENT_ADDITIONAL"
  108. reserve-non-payment-db: "TXN_RESERVE_PAYMENT_DEDUCTION"
  109. registration:
  110. mtn-db: "TXN_MARKET_TRADING_NODE"
  111. asie-db: "txn_ancillary_service_incidental_energy"
  112. stl:
  113. mru-db: "cfg_mru_maintenance"
  114. cog-db: "TXN_CONSTRAINED_ON_GENERATOR"
  115. sgad-db: "TXN_SCHEDULED_GENERATION_DEVIATION"
  116. bcq:
  117. fileNamePrefix: "reserve_bcq_"
  118. todi_config:
  119. dispatch-interval: 5
  120. reserve-categories-white-list: "Regulation Down,Fast Contingency Raise,Fast Contingency Lower,Slow Contingency Raise,Slow Contingency Lower,Delayed Contingency Raise,Delayed Contingency Lower,Regulation Up"