Connecting to Multiple Databases

While building the integration flows that involve using components from various product packs, there might be a need to access databases of individual products as part of verification process. Users can connect to different databases by specifying the database connection properties prefixed with the application prefix. This is similar to the application prefix that is used for connecting to different application URLs.

Following is a sample configuration.properties file. It shows the entries for two environments.

Note: Users are expected to write custom functions for connecting/accessing databases.

# ***********************************************

# Test Environment Details - UAT1

# ***********************************************

# Application URL pointing to test run

gStrUAT1_gStrApplicationURL = http://myuat1environment:8001/ouaf

gStrUAT1_gStrApplicationXAIServerPath=/webservices/

gStrUAT1_gStrEnvironmentName=UAT1

# Application Database Details

gStrUAT1_gStrApplicationDBConnectionString =jdbc\:oracle\:thin\:@myuatserver1\:1521\:UATSID1

gStrUAT1_gStrApplicationDBUsername=mydbuser1

gStrUAT1_gStrApplicationDBPassword==<Entrypted Password>

# ***********************************************

# Test Environment Details - UAT2

# ***********************************************

# Application URL pointing to test run

gStrUAT2_gStrApplicationURL = http:// myuat1environment2:8001/ouaf

gStrUAT2_gStrApplicationXAIServerPath=/webservices/

gStrUAT2_gStrEnvironmentName=UAT2

# Application Database Details

gStrUAT2_gStrApplicationDBConnectionString =jdbc\:oracle\:thin\:@ myuatserver2\:1521\: UATSID2

gStrUAT2_gStrApplicationDBUsername= mydbuser2

gStrUAT2_gStrApplicationDBPassword= <Entrypted Password>

##Handling Https WSDL - Java key Store

gStrJavaKeyStorePath=

gStrJavaKeyStorePwd=<Entrypted Password>

#Email Details

gStrSMTP_HOST_NAME==<SMTP server address>

gStrSMTP_PORT=25

gStrTO_EMAIL_RECIPIENTS=

# Application user name

gStrApplicationUserName=<Your OUAF Application Username>

# Application user password

gStrApplicationUserPassword=<Encrypted Password>

# Output file details

gStrOutputFilePath=/<UTA-CLIENT-WORK-DIR>//Logs/

gStrXSDFiles=/<UTA-CLIENT-WORK-DIR>//XSD/