Setup BIRT Viewer’s SSL Connection with MAS DB2

With a MAS instance provisioned by IBM, the DB is hosted on the cloud in DB2. To access the DB, we can use DBeaver. IBM provides the following details:

• Public IP/Port (reportdb.[customer-instance].suite.maximo.com:443)
• DB Name
• User Name / Password
• A certificate file (something looks like below)

First, we should import the certificate to a trust store.

For example, in my environment, I have Eclipse, Java, and a Key folder which contains the cert file.

Under the C:\BIRT480\Key folder, I ran this command:

C:\BIRT480\java\8.0\bin\keytool.exe -import -alias max-dev -file maximo-dev.cer -keystore maximo-dev.jks -storepass [password]

It will create a new maximo-dev.jks file in the same folder

Next, we need to update the BIRT Viewer’s database connection string (set in the mxreportdatasources.properties file) to add two additional properties below:

• sslConnection=true
• sslTrustStoreLocation=[Path-To-Trust-Store-File]

Below is how I set it up in my environment:

This will allow the BIRT Viewer to establish an SSL connection to the DB2 database and view the report.

Notes:

• Between the DB Name and the sslConnection=true, the two are separated by a colon (:)
• Between sslConnection=True and sslTrustStoreLocation, they are separated by a semi-colon
• Path to the trust store uses forward slash (/)
• There is no need to provide the trust store’s password
• Instead of the sslTrustStoreLocation properties, you can set it using an environment variable or passing it in the Eclipse shortcut as a parameter

-Djavax.net.ssl.trustStore=C:\BIRT480\key\maximo-dev.jks

Hope this helps.