Teradata Driver Error When Connecting to Subset

Products

• CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

I am receiving the following error message when trying to connect to GT Subset with a Teradata database profile connection:

Connection Error
com.teradata.jdbc.TeraDriver

<Please see attached file for image>

 

We are able to connect through Datamaker and access the Teradata database on its own.

Cause

The reason you are seeing this error message is because the Teradata jar files are not in the correct location. 

 

Here are some other notes using a Teradata database with TDM:

• If you are connecting to a Teradata database, enter the Host Name and Default Schema (Database Name). 
  - https://docops.ca.com/ca-test-data-manager/4-1/en/provisioning-test-data/subset-production-data/subset-stored-data/establish-database-connection 
  
  
• If you create a Teradata connection profile in CA TDM Portal, and you publish from Datamaker using this connection profile (the Enterprise or Remote Enterprise
  publish option), then only the Teradata ODBC driver 15.00.00.00 is supported. 
  - https://docops.ca.com/ca-test-data-manager/4-1/en/installing/supported-data-sources 

Environment

CA Test Data Manager (TDM)- GT Subset & Teradata Database

Resolution

To use Subset with a Teradata database connection, you will need to copy your terajdbc4.jar and tdgssconfig.jar files into the C:\Program Files (x86)\Grid-Tools\GTDatamaker\lib folder. 

You can read more about this and other database requirements here: https://docops.ca.com/ca-test-data-manager/4-1/en/installing/install-ca-test-data-manager/system-requirements

Additional Information

If you experience any further issues, please open a support case on https://support.ca.com/irj/portal/newhome or call support at one of these numbers https://www.ca.com/us/services-support/ca-support/contact-support.html.