crssconfig/crss-data/crss-data.yml

spring:
  profiles:
    include: client-sec
  datasource:
    url: jdbc:edb://10.176.11.131:5432/crss?currentSchema=dataextraction
    username: crss_dataextraction
    password: xgZx2FqM
kettle:
  rootDir: /kettle/download
  jndiDir: /kettle/jndi
  mainJob: /kettle/download/main/main.kjb

crss:
  # TODO: renaming of datasource name must also update the binding in data-extraction service and kettle files
  metadata:
    datasource:
      url: jdbc:edb://10.176.11.131:5432/crss?currentSchema=dataextraction
      username: crss_dataextraction
      password: xgZx2FqM
      hikari:
        connectionTimeout: 10000
        maximumPoolSize: 5
        minimumIdle: 2
        idleTimeout: 180000 # 3 min
        maxLifetime: 600000 # 10 min
   # TODO: update to oracle datasource once credentials are available
  datawarehouse:
    datasource:
      platform: oracle
      url: jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(LOAD_BALANCE=OFF)(FAILOVER=ON)
           (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.165)(PORT=1521))
           (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.166)(PORT=1521))
           (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.94.167)(PORT=1521)))
           (CONNECT_DATA=(SERVICE_NAME=emdb)(SERVER=DEDICATED)))
      username: crss_dw
      password: crss_dw
      driverClassName: oracle.jdbc.OracleDriver
      hikari:
        connectionTimeout: 10000
        maximumPoolSize: 5
        minimumIdle: 2
  registration:
     datasource:
       url: jdbc:edb://10.176.11.131:5432/crss?currentSchema=registration
       username: crss_registration
       password: 51UF3JA9
       hikari:
         connectionTimeout: 10000
         maximumPoolSize: 5
         minimumIdle: 2
         idleTimeout: 180000 # 3 min
         maxLifetime: 600000 # 10 min