TDM Portal: Connection profile for Teradata - fails to connect

book

Article ID: 140227

calendar_today

Updated On:

Products

CA Test Data Manager (Data Finder / Grid Tools)

Issue/Introduction

We are trying to create a new connection profile through our portal and it returns with the following error.

Failed to Connect: 

The server replied: Could not load JDBC driver class[com.teradata.jdbc.TeraDriver] nested exception is java.sql.SQLException.

 

Cause

This issue is due to missing of Teradata driver jar in portal.

Environment

Release : 4.8

Component : CA Test Data Manager

Resolution

 This error indicates missing of Teradata driver jars. 

   From teradata installation directory, get the required driver files (below given driver files  are for verrsion 4.5) and place these jars to C:\Program Files\CA\CA Test Data Manager Portal\tomcat\jdbc-drivers and restart the portal service.

terajdbc4.jar and 

tdgssconfig.jar