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 Teradata and DB2 z/OS (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:

• 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
• SQL Server JDBC Drivers
• MySQL JDBC Drivers
• Netezza JDBC Drivers
• Oracle JDBC Drivers
• ParAccel Analytic Platform Drivers
• PostgreSQL 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