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

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