TLS Enabled Environment
UIM 9.0.2 GA
UMP 9.0.2 HF2
cabi_external v3.40 and Jasper Report Server v6.4.3
Oracle and MS SQL Server Databases
Under the "Resource username" section we will need to add the trust store / wallet password, example:
<Resource username="CA_UIM" url="jdbc:tibcosoftware:oracle://<DATABASE_IP>:2484;serviceName=test.dev.com;CryptoProtocolVersion=TLSv1.2;encryptionMethod=ssl;TrustStore=C:/Program Files (x86)/Nimsoft/security/ewallet.p12;TrustStorePassword=;" type="javax.sql.DataSource" password="ENC-e892deda7dd96de81c1b4c75f2b64d2882f7bc5be209def8a95807f2336ab1f4-" name="jdbc/uim" maxWait="10000" maxIdle="30" maxActive="100" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" driverClassName="tibcosoftware.jdbc.oracle.OracleDriver" auth="Container" initConnectionSqls="ALTER SESSION SET NLS_COMP='LINGUISTIC';ALTER SESSION SET NLS_SORT='BINARY_CI'" defaultTransactionIsolation="TRANSACTION_READ_UNCOMMITTED"/>
</Context>
On the highlighted section add your trust store password, example:
<Resource username="CA_UIM" url="jdbc:tibcosoftware:oracle://<DATABASE_IP>:2484;serviceName=test.dev.com;CryptoProtocolVersion=TLSv1.2;encryptionMethod=ssl;TrustStore=C:/Program Files (x86)/Nimsoft/security/ewallet.p12;[email protected];" type="javax.sql.DataSource" password="ENC-e892deda7dd96de81c1b4c75f2b64d2882f7bc5be209def8a95807f2336ab1f4-" name="jdbc/uim" maxWait="10000" maxIdle="30" maxActive="100" factory="com.jaspersoft.jasperserver.tomcat.jndi.JSCommonsBasicDataSourceFactory" driverClassName="tibcosoftware.jdbc.oracle.OracleDriver" auth="Container" initConnectionSqls="ALTER SESSION SET NLS_COMP='LINGUISTIC';ALTER SESSION SET NLS_SORT='BINARY_CI'" defaultTransactionIsolation="TRANSACTION_READ_UNCOMMITTED"/>
</Context>
6. Save the changes to the file, go to services and restarted the "CA Business Intelligence Tomcat" service.
Note: You will need to clear the browser cache when retesting the UIM / CABI Dashboards in the UMP or Operator Console.