Teradata JDBC Drivers

JDBC Drivers (terajdbc4.jar and tdgssconfig.jar) must be downloaded from the vendor and are not bundled within ADS. Copy these drivers into the Aqua Data Studio/lib/drivers folder.

Contents

• Driver Location
• Updating Driver Contents for use with Teradata

Driver Location

You may locate the latest Teradata JDBC drivers at the following location ...

Vendor: Teradata
Website: http://www.teradata.com
Database Product: Teradata
Description: High-performance analytic database for data warehousing – parallel processing system running a shared nothing architecture.

Updating Driver Contents for use Teradata

To update the Aqua Data Studio JDBC drivers you need to overwrite the tdgssconfig.jar and terrajdbc4.jar files. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

Windows

[ADS_INSTALL]\lib\drivers\tdgssconfig.jar
[ADS_INSTALL]\lib\drivers\terajdbc4.jar

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 40F4-2392

 Directory of C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers

12/26/2012  04:35 PM    <DIR>          .
12/26/2012  04:35 PM    <DIR>          ..
01/02/2013  12:08 PM            35,701 cassandra-clientutil.jar
01/02/2013  12:08 PM            64,465 cassandra-jdbc.jar
01/02/2013  12:08 PM           948,351 cassandra-thrift.jar
01/02/2013  12:08 PM         1,146,367 db2java.jar
01/02/2013  12:08 PM         2,703,892 derby.jar
01/02/2013  12:08 PM           535,985 derbyclient.jar
01/02/2013  12:08 PM           242,891 derbynet.jar
01/02/2013  12:08 PM           812,386 ifxjdbc.jar
01/02/2013  12:08 PM         1,660,765 jconnect70.jar
01/02/2013  12:08 PM           141,648 jsqlparser-src.zip
01/02/2013  12:08 PM           142,861 jsqlparser.jar
01/02/2013  12:08 PM         4,581,825 jt400.jar
01/02/2013  12:08 PM           349,542 jtds-src.jar
01/02/2013  12:08 PM           330,688 jtds.jar
01/02/2013  12:08 PM           388,540 mongo.jar
01/02/2013  12:08 PM           651,205 mysql-src.jar
01/02/2013  12:08 PM           745,416 mysql.jar
01/02/2013  12:08 PM           445,188 ncluster.jar
01/02/2013  12:08 PM         2,714,189 ojdbc6.jar
01/02/2013  12:08 PM         1,656,248 orai18n.jar
01/02/2013  12:08 PM           346,944 paraccel-jdbc.jar
01/02/2013  12:08 PM           561,969 postgresql.jar
01/02/2013  12:08 PM         3,516,830 sqlite-jdbc.jar
02/22/2011  11:01 AM             1,757 tdgssconfig.jar
10/26/2011  05:51 AM           826,161 terajdbc4.jar
01/02/2013  12:08 PM           286,773 util400.jar
11/26/2012  01:47 PM           527,714 vertica.jar
01/02/2013  12:08 PM           262,740 xdb6.jar
01/02/2013  12:08 PM           839,982 xmlparserv2.jar
              29 File(s)     27,469,023 bytes
               2 Dir(s)  85,487,915,008 bytes free

C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>

Linux

[ADS_INSTALL]/lib/drivers/tdgssconfig.jar
[ADS_INSTALL]/lib/drivers/terajdbc4.jar

OSX

Aqua Data Studio.app/Contents/Java/drivers/tdgssconfig.jar
Aqua Data Studio.app/Contents/Java/drivers/terajdbc4.jar

The Java class path for the drivers are already configured for ADS in the datastudio.ini for launching ADS with datastudio.exe and in datastudio.bat/.sh and datastudio-bundled.bat/.sh for launching Aqua Data Studio from the command line.