How to connect the TDM portal to an SAP HANA database that requires TLS for its connection
Article ID: 245681
Updated On:
Products
Issue/Introduction
Trying to connect the TDM portal to an SAP HANA database that requires TLS for its connection.
Looking through the latest documentation and trying to find an example TLS configuration details for any database connection profile in TDM and had trouble finding any documentation on this type of connection profile.
Do we have documentation for using a TLS JDBC connection?
Environment
TDM Portal 4.9 and later.
Cause
Guidance.
Resolution
Please refer to the documentation on creating and editing connection profiles below:
https://techdocs.broadcom.com/us/en/ca-enterprise-software/devops/test-data-management/4-10/provisioning-test-data/defining-test-data/defining-test-data-using-the-ca-tdm-portal/create-and-edit-connection-profiles.html
(For DB2/OS, DB2/AS400, SQL Server, and Teradata) Lets you specify additional connection properties.
Can add key/value pairs that are separated by semi colons (;). An equals sign (=) separates each key from its value or values (separate values with commas).
For example, libraries=Schema1,Schema2,Schema3 causes the Connection Profile only to include the schemas Schema1, Schema2 and Schema3.
This would apply to SAP HANA as well.
To support a TLS connection you would set the option properties of:
ENRYPT=TRUE
Additional Information
Feedback
