The Netezza JDBC Driver nzjdbc.jar file must be downloaded from the vendor and is not bundled within Aqua Data Studio. Copy the driver into the Aqua Data Studio/lib/drivers folder.
Netezza server releases are frequent, and may sometimes require updating the JDBC driver.
Contents
Driver Location
You may locate the latest Netezza JDBC drivers at the following location ...
Vendor: IBM
Driver URL: Contact your Netezza Representative
Database Product: Netezza
Updating Driver Contents for use Netezza
To update the Aqua Data Studio JDBC drivers for Netezza you need to overwrite the Aqua Data Studio nzjdbc.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...
WINDOWS
[ADS_INSTALL]\lib\drivers\nzjdbc.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
11/23/2012 08:58 AM <DIR> .
11/23/2012 08:58 AM <DIR> ..
12/21/2012 10:24 AM 35,701 cassandra-clientutil.jar
12/21/2012 10:24 AM 64,465 cassandra-jdbc.jar
12/21/2012 10:24 AM 948,351 cassandra-thrift.jar
12/21/2012 10:24 AM 1,146,367 db2java.jar
12/21/2012 10:24 AM 3,348,681 db2jcc.jar
12/21/2012 10:24 AM 1,015 db2jcc_license_cu.jar
12/21/2012 10:24 AM 2,703,892 derby.jar
12/21/2012 10:24 AM 535,985 derbyclient.jar
12/21/2012 10:24 AM 242,891 derbynet.jar
12/21/2012 10:24 AM 812,386 ifxjdbc.jar
12/21/2012 10:24 AM 1,660,765 jconnect70.jar
12/21/2012 10:24 AM 141,648 jsqlparser-src.zip
12/21/2012 10:24 AM 142,861 jsqlparser.jar
12/21/2012 10:24 AM 4,581,825 jt400.jar
12/21/2012 10:24 AM 349,542 jtds-src.jar
12/21/2012 10:24 AM 330,688 jtds.jar
12/21/2012 10:24 AM 388,540 mongo.jar
12/21/2012 10:24 AM 651,205 mysql-src.jar
12/21/2012 10:24 AM 745,416 mysql.jar
12/21/2012 10:24 AM 445,188 ncluster.jar
12/03/2012 02:56 PM 340,338 nzjdbc.jar
12/21/2012 10:24 AM 2,714,189 ojdbc6.jar
12/21/2012 10:24 AM 1,656,248 orai18n.jar
12/21/2012 10:24 AM 346,944 paraccel-jdbc.jar
12/21/2012 10:24 AM 561,969 postgresql.jar
12/21/2012 10:24 AM 3,516,830 sqlite-jdbc.jar
12/21/2012 10:24 AM 286,773 util400.jar
12/21/2012 10:24 AM 262,740 xdb6.jar
12/21/2012 10:24 AM 839,982 xmlparserv2.jar
29 File(s) 29,803,425 bytes
2 Dir(s) 86,583,730,176 bytes free
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers>
LINUX
[ADS_INSTALL]/lib/drivers/nzjdbc.jar
OSX
Aqua Data Studio.app/Contents/Java/drivers/nzjdbc.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.