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
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.