USER MANUALS

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.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.

IBM, MySQL, Microsoft, and Sybase Drivers

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.

Add feedback