We are implementing a more secure layer for databases and bringing it to TLS 1.2. Also, I have received our new DB2 certificates file, and imported them into a truststore file.
How do we set up a secure connection to the DB2 database in TDM Portal and FDM?
All supported release of TDM Portal and FDM
To create a DB2 connection profile in TDM Portal that uses a secured SSL connection, you would need to do the following:
As for the embedded Java JRE, by default, the Java 1.8.0_412 version (TDM/FDM 4.10.x) and Java 17.0.11+9 version (TDM/FDM 4.11.x) only allows for TLS1.2 and TLS1.3 (for Java 17) connections. All other protocols are disabled. If you need to enable an older protocol, for instance, TLS1.1, then you will need to do the following:
This also applies to FDM. You can do similar steps to configure an FDM connection to use SSL when connecting to DB2. If you enable TLS1.1 for the Portal, then you will also want to do the same for the embedded JRE used by FDM. See the following KB: TLS error during FDM masking of SSL data source.
If your security team provided you with a TrustStore file, then all you need to know is the password for the file. You can place this file anywhere you wish on the Portal server, as long as the account running the CA Test Data Manager Portal service has read access to the file.
You would then specify the full path to the file, and the password required for accessing the file in the Additional parameters in the Connection Profile configuration.
If you were only given the certificate file, and need to create a truststore file, see Steps to convert and import a Certificate file to a Truststore file
.