How to connect the TDM portal to an SAP HANA database that requires TLS for its connection
search cancel

How to connect the TDM portal to an SAP HANA database that requires TLS for its connection

book

Article ID: 245681

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

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

https://help.sap.com/docs/SAP_HANA_CLIENT/f1b440ded6144a54ada97ff95dac7adf/109397c2206a4ab2a5386d494f4cf75e.html