JDBC Drivers¶
The following table shows the JDBC adapters included with Denodo Scheduler. For each driver the databases for which it has been tested, the name of the class that must be specified when creating a JDBC data source that uses the adapter and the URI format used are shown.
Database |
Class |
URI |
|---|---|---|
Amazon Aurora MySQL |
org.mariadb.jdbc.Driver |
jdbc:mariadb://<host>:<port>/<database> |
Amazon Aurora PostgreSQL |
org.postgresql.Driver |
jdbc:postgresql://<host>:<port>/<database> |
Azure SQL |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
jdbc:sqlserver://<host>:<port>;database=<database> |
Derby 10 |
org.apache.derby.jdbc.ClientDriver |
jdbc:derby://<host>:<port>/<database> |
Excel |
sun.jdbc.odbc.JdbcOdbcDriver |
jdbc:odbc:<database> |
Oracle 8i Oracle 9i Oracle 10g Oracle 11g Oracle 12c Oracle 18c Oracle 19c |
oracle.jdbc.OracleDriver |
jdbc:oracle:<protocol>:@<host>:<port>:<database> Protocols: thin (recommended), oci, oci8, kprb |
PostgreSQL 8 PostgreSQL 9 PostgreSQL 10 PostgreSQL 11 PostgreSQL 12 |
org.postgresql.Driver |
jdbc:postgresql://<host>:<port>/<database> |
SQL Server 8.00.194 SQL Server 2000 SQL Server 2005 SQL Server 2008 SQL Server 2008 R2 SQL Server 2012 SQL Server 2014 SQL Server 2016 SQL Server 2017 SQL Server 2019 |
net.sourceforge.jtds.jdbc.Driver |
jdbc:jtds:sqlserver://<host>:<port>/<database> |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
jdbc:sqlserver://<host>:<port>;databaseName=<database> |
|
jdbc:sqlserver://<host>:<port>;databaseName=<database>;encrypt=false |
||
Sybase Adaptive Server Enterprise12.5B Sybase Adaptive Server Enterprise15 |
net.sourceforge.jtds.jdbc.Driver |
jdbc:jtds:sybase://<host>:<port>/<database> |
JDBC-ODBC Bridge |
sun.jdbc.odbc.JdbcOdbcDriver |
jdbc:odbc:<database> |
Denodo Virtual DataPort 8.0 |
com.denodo.vdp.jdbc.Driver |
jdbc:denodo://<host>:<port>/<database> |
As for Microsoft SQL Server databases:
The official Microsoft JDBC driver is recommended to connect to versions 2014 or higher.
You can choose the jTDS or the official Microsoft JDBC driver to connect to versions 2012 and 2014.
The jTDS JDBC driver should be used to connect to versions below 2012. If you want to use official Microsoft JDBC drivers to connect to versions prior to 2012, you must download them from the official Microsoft website as they are not included in the Scheduler distribution.
Adapters for IBM DB2 and MySQL, as well as those created by their manufacturers for Sybase, are not included in the distribution of Scheduler, but can be downloaded from the Web sites of these companies. They have also been tested successfully, and their data are shown in the following table.
Database |
Class |
URI |
|---|---|---|
DB2 8.2 |
com.ibm.db2.jcc.DB2Driver |
jdbc:db2://<host>:<port>/<database> |
MySQL 4.0.15 MySQL 4.1.1 MySQL 5.x MySQL 8.x |
com.mysql.jdbc.Driver |
jdbc:mysql://<host>:<port>/<database> |
Sybase Adaptive Server Enterprise 12.5B |
com.sybase.jdbc3.jdbc.SybDriver |
jdbc:sybase:Tds:<host>:<port>/<database> |
The JDBC drivers in the above lists have been successfully tested, although any other JDBC driver should work alongside Denodo Scheduler.