Change the content of <Siebel Tomcat home>\webapps\workspacedelivery\resources\properties\workspace.properties to match the workspace database connection. Choose from the following properties based on your database type:
Oracle DB
jdbc.driverClassName=oracle.jdbc.driver.OracleDriver
jdbc.url=jdbc:oracle:thin:@<server name>:<portnumber>/<instance name>
jdbc.username=<TBLO>
jdbc.password=<encrypted password>
jdbc.tblo=<TBLO>
DB2 UDB
jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
jdbc.url=jdbc:db2://<server name>:<portnumber>/<DB Alias>
jdbc.username=<TBLO>
jdbc.password=<encrypted password>
jdbc.tblo=<TBLO>
DB2 390
jdbc.driverClassName=com.ibm.db2.jcc.DB2Driver
jdbc.url=jdbc:db2://<server name>:<portnumber>/<DB Alias>
jdbc.username=<database user>
jdbc.password=<encrypted password>
jdbc.tblo=<TBLO>
MS SQL DB
jdbc.driverClassName=com.microsoft.sqlserver.jdbc.SQLServerDriver
jdbc.url=jdbc:sqlserver://<server name>\\<instance name>:<portnumber>;databaseName=<TBLO>
jdbc.username=<TBLO>
jdbc.password=<encrypted password>
jdbc.tblo=<TBLO>
jdbc.intBranchName=<workspace branch where you want to deliver your changes>
jdbc.siebelUsername=<Siebel user name>
jdbc.siebelPassword=<Encrypted Siebel password>
jdbc.logPath=<Create a local folder for API to write log files to, like C:/workspace>
jdbc.toolsPath=<Siebel Tools path, eg: C:/Siebel/18.0.0.0.0/18_03_Tools>
jdbc.siebelDSN=<Siebel DSN>
NOTE: Place a copy of your DB2 license jar file (db2jcc_license_cisuz.jar) to your Siebel Tomcat lib folder and bounce Tomcat server in case your Siebel DB is DB2 UDB or DB2 390 (z/OS).
This step is optional. Use this for workspacedelivery REST API to call back SAM to record success and failure actions.
jdbc.samURL=http://<Server name>:<portnumber>/sam
jdbc.samUsername=<A user who has a role which has ownership to do success and failure actions for example delivery@<emaildomain.com>
jdbc.samPassword=<Encrypted SAM password>
jdbc.samSuccessActionID=<Action Id for post successful delivery>
jdbc.samFailureActionID=<Action Id for post failed delivery>
NOTE: To encrypt password, use the link http://<server name>:<port number>/emailapprover/encrypt/<password to encrypt>