JDBC Driver Configuration

Aqua Data Studio uses JDBC drivers to make database connections to the appropriate database. By default, Aqua Data Studio comes packaged with an appropriate JDBC driver for all supported databases except Netezza, SAP Hana, Teradata, Teradata Aster and Vertica. These may be downloaded directly from the vendor. The included drivers work for most database versions and setups. In specific configurations, you may be required to update the JDBC driver in your Aqua Data Studio installation with the latest driver from the database vendor.

Below is a list of databases, the corresponding issues that may arise and the appropriate action to take to resolve the issue. Each database vendor and version JDBC Driver is discussed on its own page:

• Amazon Athena JDBC Drivers
• Amazon Redshift JDBC Drivers
• Apache Cassandra JDBC Drivers
• Apache Derby JDBC Drivers
• Apache Hive JDBC Drivers
• DB2 LUW 7.2 JDBC Drivers
• DB2 LUW 8.1 and DB2 UDB 8.2
• DB2 LUW 10.x, 9.0 and DB2 UDB 9.5
• DB2 iSeries JDBC Drivers
• DB2 z/OS JDBC Drivers
• Greenplum JDBC Drivers
• Informix JDBC Drivers
• InterBase JDBC Drivers
• SQL Server JDBC Drivers
• MariaDB JDBC Drivers
• MySQL JDBC Drivers
• Netezza JDBC Drivers
• Oracle JDBC Drivers
• ParAccel Analytic Platform Drivers
• PostgreSQL JDBC Drivers
• SAP Hana JDBC Drivers
• Snowflake JDBC Drivers
• SQLite JDBC Drivers
• Sybase ASE JDBC Drivers
• Sybase Anywhere JDBC Drivers
• Sybase IQ JDBC Drivers
• Teradata Aster JDBC Drivers
• Teradata JDBC Drivers
• Vertica JDBC Drivers
• VoltDB JDBC Drivers
• Firebird JDBC Drivers