How To
Summary
Pre-requisites: SSL must be configured on Database server, get the certificate file and know the secure port number.
1. Install ITIC7.6.0.1 HF5 or later
2. Obtain the certificate file (<FILENAME>.crt) from Database Server.
3. Place the <FILENAME>.crt certificate in a suitable directory <LOCALFOLDER> on your local ITIC environment.
4. Execute the following command from the <JAVA_HOME>/bin directory (note that JAVA_HOME must be the same used by ITIC as specified in <ITIC>\bin\init.sh(bat) file):
keytool -importcert -file "<LOCALFOLDER><FILENAME>.crt" -keystore ..\jre\lib\security\cacerts
Enter password when prompted
5. Edit the <ITIC>\data\properties\fusion.properties file:
a) Update the mxe.db.url property to reflect the secure port.
b) Add mxe.db.useSSL=true
6. Edit the <ITIC>\data\properties\jdbcinfo.properties file. Update the <DATABASE TYPE>.fieldList property, adding USE_SSL(B). For example:
db2.fieldList=HOST_NAME,HOST_PORT(N),USE_SSL(B),DATABASE_NAME,USER,PASSWORD,TABLE_OWNER
7. Within the ITIC UI, if there are data sources already defined, ensure that they are updated to point to the secure port and check the “Use SSL” checkbox.
Document Location
Worldwide
Log InLog in to view more of this document
Was this topic helpful?
Document Information
Modified date:
06 September 2022
UID
ibm16618405