Configuring a JDBC Connection to a TeraData database

, ,
1

Thought this might help someone looking for info on configuring a JDBC Connection to a TeraData database (since I didn’t see any posts related to this):

This is how I configured -

IS version 7.1.1
WmJDBCAdapter version 6.5
TeraJDBC version 03.02.00.03
TeraData version v2R5

Package Name <package_name>
Folder Name <folder_name>
Connection Name <connection_name>

Transaction Type NO_TRANSACTION
DataSource Class com.ncr.teradata.TeraDataSource
serverName
user
password
databaseName
portNumber
networkProtocol
Other Properties DSName=

Enable Connection Pooling false

Also, I placed the recommended jar files (tdgssconfig.jar, tdgssjava.jar, terajdbc4.jar) in the “packages/WmJDBCAdapter/code/jars” directory and reloaded the package.

2

Thanks a lot buddy!!
You are a saviour :D:D:D

Though in my case, the connection worked only when i placed the driver files for teradata in the /lib/jars folder instead of /packages/WmJDBCAdapter/code/jars folder.