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.

JDBC Drivers
Database Class URI
Derby 10 org.apache.derby.jdbc. ClientDriver jdbc:derby://<host> :<port>/<database>
Excel sun.jdbc.odbc.JdbcOdbcD river jdbc:odbc:<database>

Oracle 8i

Oracle 9i

Oracle 10g

Oracle 11g

Oracle 12c

oracle.jdbc.OracleDrive r

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.jd bc.Driver jdbc:jtds:sqlserver:// <host>:<port>/<database>

Sybase Adaptive Server Enterprise12.5B

Sybase Adaptive Server Enterprise15

net.sourceforge.jtds.jd bc.Driver jdbc:jtds:sybase:// <host>:<port>/<database>
JDBC-ODBC Bridge sun.jdbc.odbc.JdbcOdbcD river jdbc:odbc:<database>
Denodo Virtual DataPort 6.0 com.denodo.vdp.jdbc.Dri ver 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.

IBM, MySQL, Microsoft, and Sybase Drivers
Database Class URI
DB2 8.2 com.ibm.db2.jcc.DB2Driv er 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.jdbc.sqls erver.SQLServerDriver jdbc:microsoft: sqlserver://<host> ;DatabaseName=<database>
Sybase Adaptive Server Enterprise 12.5B com.sybase.jdbc3.jdbc.S ybDriver 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.