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 |
---|---|---|
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.jdbc.OracleDriver |
jdbc:oracle:<protocol>:@<host>:<port>:<database> Protocols: thin (recommended), oci, oci8, kprb |
PostgreSQL 8 PostgreSQL 9 |
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 |
net.sourceforge.jtds.jdbc.Driver |
jdbc:jtds:sqlserver://<host>:<port>/<database> |
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 7.0 |
com.denodo.vdp.jdbc.Driver |
jdbc:vdb://<host>:<port>/<database> |
Adapters for IBM DB2 and MySQL, as well as those created by their manufacturers for Microsoft SQL Server and 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 |
com.mysql.jdbc.Driver |
jdbc:mysql://<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 |
com.microsoft.sqlserver.jdbc.SQLServerDriver |
jdbc:sqlserver://<host>;DatabaseName=<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.