SAP Hana requires a JDBC driver that is not included with Aqua Data Studio. It must be downloaded from vendor. Copy the driver into the Aqua Data Studio/lib/drivers folder. |
You may locate the latest SAP Hana JDBC drivers at the following location ...
Vendor: SAP
Driver URL: SAP Software Download Center
Database Product: SAP Hana
To update the Aqua Data Studio JDBC drivers for SAP Hana you need to overwrite the Aqua Data Studio ngdbc.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...
[ADS_INSTALL]\lib\drivers\ngdbc.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> ..
11/22/2012 11:13 AM 35,701 cassandra-clientutil.jar
11/22/2012 11:13 AM 64,465 cassandra-jdbc.jar
11/22/2012 11:13 AM 948,351 cassandra-thrift.jar
11/22/2012 11:13 AM 1,146,367 db2java.jar
11/22/2012 11:13 AM 3,348,681 db2jcc.jar
11/22/2012 11:13 AM 1,015 db2jcc_license_cu.jar
11/22/2012 11:13 AM 2,703,892 derby.jar
11/22/2012 11:13 AM 535,985 derbyclient.jar
11/22/2012 11:13 AM 242,891 derbynet.jar
11/22/2012 11:13 AM 812,386 ifxjdbc.jar
11/22/2012 11:13 AM 1,660,765 jconnect70.jar
11/22/2012 11:13 AM 141,648 jsqlparser-src.zip
11/22/2012 11:13 AM 142,861 jsqlparser.jar
11/22/2012 11:13 AM 4,581,825 jt400.jar
11/22/2012 11:13 AM 350,273 jtds-src.jar
11/22/2012 11:13 AM 329,228 jtds.jar
11/22/2012 11:13 AM 291,946 mongo.jar
11/22/2012 11:13 AM 651,205 mysql-src.jar
11/22/2012 11:13 AM 745,416 mysql.jar
11/22/2012 11:13 AM 877,236 ngdbc.jar
11/22/2012 11:13 AM 445,188 ncluster.jar
11/22/2012 11:13 AM 2,714,189 ojdbc6.jar
11/22/2012 11:13 AM 1,656,248 orai18n.jar
11/22/2012 11:13 AM 346,944 paraccel-jdbc.jar
11/22/2012 11:13 AM 561,969 postgresql.jar
11/22/2012 11:13 AM 3,516,830 sqlite-jdbc.jar
11/22/2012 11:13 AM 286,773 util400.jar
11/22/2012 11:13 AM 262,740 xdb6.jar
11/22/2012 11:13 AM 839,982 xmlparserv2.jar
28 File(s) 29,365,764 bytes
2 Dir(s) 88,341,790,720 bytes free
C:\Program Files\Aqua Data Studio 13.0 - 64bit\lib\drivers> |
[ADS_INSTALL]/lib/drivers/ngdbc.jar
Aqua Data Studio.app/Contents/Java/drivers/ngdbc.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.