Amazon Redshift JDBC Drivers

The Amazon Redshift driver (v1.2) is included with Aqua Data Studio. 

Contents

• Driver Location
• Updating Driver Contents for use with Redshift 

Driver Location

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

Vendor: Amazon
Driver URL: http://docs.aws.amazon.com/redshift/latest/mgmt/configure-jdbc-connection.html#download-jdbc-driver
Database Product: Amazon Redshift

Updating Driver Contents for use Redshift

To update the Aqua Data Studio JDBC drivers for Redshift you need to overwrite the Aqua Data Studio redshift.jar file. Below is a listing of the Aqua Data Studio library directory [ADS_INSTALL]\lib\drivers\ ...

WINDOWS

[ADS_INSTALL]\lib\drivers\redshift.jar

C:\Program Files\Aqua Data Studio 20.0 - 64bit\lib\drivers>dir
 Volume in drive C has no label.
 Volume Serial Number is 70B3-F581

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

04/04/2019  11:21 AM    <DIR>          .
04/04/2019  11:21 AM    <DIR>          ..
04/02/2019  08:23 AM            15,364 cassandra-clientutil-extras.jar
04/02/2019  08:23 AM            36,549 cassandra-clientutil.jar
04/02/2019  08:23 AM           228,286 cassandra-jackson-core-asl.jar
04/02/2019  08:23 AM           765,648 cassandra-jackson-mapper-asl.jar
04/02/2019  08:23 AM         1,073,177 cassandra-thrift.jar
04/02/2019  08:23 AM         4,234,170 db2jcc4.jar
04/02/2019  08:23 AM             1,015 db2jcc_license_cu.jar
04/02/2019  08:23 AM         3,232,770 derby.jar
04/02/2019  08:23 AM           588,394 derbyclient.jar
04/02/2019  08:23 AM           272,626 derbynet.jar
04/02/2019  08:23 AM           199,010 google-api-client.jar
04/02/2019  08:23 AM           107,293 google-api-services-bigquery-v2.jar
04/02/2019  08:23 AM             6,672 google-http-client-jackson2.jar
04/02/2019  08:23 AM           356,261 google-http-client.jar
04/02/2019  08:23 AM            10,776 google-oauth-client-java6.jar
04/02/2019  08:23 AM             5,799 google-oauth-client-jetty.jar
04/02/2019  08:23 AM            61,116 google-oauth-client.jar
04/02/2019  08:23 AM        18,438,062 hive-exec.jar
04/02/2019  08:23 AM            93,137 hive-jdbc.jar
04/02/2019  08:23 AM         5,273,347 hive-metastore.jar
04/02/2019  08:23 AM         1,860,639 hive-service.jar
04/02/2019  08:23 AM           963,515 ifxjdbc.jar
04/02/2019  08:23 AM           259,809 interclient.jar
04/02/2019  08:23 AM         1,873,815 jconnect16.jar
04/02/2019  08:23 AM           539,912 jetty-6.jar
04/02/2019  08:23 AM           177,131 jetty-util.jar
04/02/2019  08:23 AM         4,739,226 jt400.jar
04/02/2019  08:23 AM           549,861 jtds-src.jar
04/02/2019  08:23 AM           373,875 jtds.jar
04/02/2019  08:23 AM           585,828 mariadb.jar
04/02/2019  08:23 AM         2,223,387 mongo.jar
04/02/2019  08:23 AM         2,718,518 mysql-src.jar
04/02/2019  08:23 AM         1,004,838 mysql.jar
04/02/2019  08:23 AM         4,036,257 ojdbc8.jar
04/02/2019  08:23 AM         1,661,088 orai18n.jar
04/02/2019  08:23 AM           415,357 paraccel-jdbc.jar
04/02/2019  08:23 AM        38,354,188 phoenix.jar
04/02/2019  08:23 AM           790,405 postgresql.jar
04/02/2019  08:23 AM         6,573,928 redshift.jar
04/02/2019  08:23 AM        15,818,611 snowflake.jar
04/02/2019  08:23 AM         6,672,489 sqlite-jdbc.jar
04/02/2019  08:23 AM         1,111,548 sqljdbc42.jar
04/02/2019  08:23 AM           287,555 util400.jar
04/02/2019  08:23 AM         9,038,592 voltdb.jar
04/02/2019  08:23 AM           259,806 xdb6.jar
04/02/2019  08:23 AM         1,420,339 xmlparserv2.jar
04/02/2019  08:23 AM           779,974 zookeeper.jar
              47 File(s)    140,089,963 bytes
               2 Dir(s)  25,725,767,680 bytes free

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

LINUX

[ADS_INSTALL]/lib/drivers/redshift.jar

Macos

Aqua Data Studio.app/Contents/Java/drivers/redshift.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.