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
I am that is trying to connect the TDM portal to an SAP HANA database that requires TLS for its connection.
I was looking through our latest documentation and trying to find an example TLS configuration details for any database connection profile in TDM and I 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.x 4.9\10.x
test data Manager
Resolution
Please refer to the documentation on creaint 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.
You 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
