Supported JDBC Data Sources

The following table lists the databases for which Virtual DataPort provides a specific JDBC adapter.

When a database is not listed here, use the adapter “Generic” to connect to it.

JDBC Drivers supported by Virtual DataPort
Database Version Notes Driver included in Denodo
Amazon Redshift N/A   Yes
Apache Derby 10   Yes
Apache Spark SQL 1.5   Yes
1.6
2.x
Greenplum 4.2   Yes
Hive 0.13.0 (Hive Server 2)   No (*)
1.1.0 (Hive Server 2)
2.0.0 (Hive Server 2)
Hive for Cloudera 1.1.0   No
Hive for Hortonworks 1.2.1   No
IBM DB2 8.2   No
9
9 for z/OS
10
10 for z/OS
Impala 2.3   No
Informix 7   No
12
Microsoft SQL Server 2000 You can use either the jTDS driver or the Microsoft driver. Both drivers are included.
2005
2008
2008R2
2012
2014
2016
MySQL 4   No
5
Netezza 4.6   No
5.0
6.0
7.0
Oracle 8i   Yes
9i
10g
11g
12c
12c In-Memory
E-Business Suite 12
Oracle TimesTen 11g

The connection URI is different, depending on if there is a DSN in the same host as Virtual DataPort that points to Oracle TimesTen, or not.

With DSN: jdbc:timesten: client:<client DSN>

Without DSN: jdbc:timesten: client:ttc_server= <host>;tcp_port= <port>; ttc_server_dsn= <server_dsn>

Yes
PostgreSQL 8   Yes
9
Presto 0.1x   Yes
SAP HANA 1.0   No
Snowflake n/a   Yes
Sybase 12 Either you can use the Sybase driver or the jTDS open source driver. Yes: Denodo provides the jTDS driver.
15
Teradata 12   No
13
14
15
Vertica 7   No
9   No

(*): To connect to Hortonworks Hive, selects its specific adapter; do not select one of the generic Apache Hive adapters. Also, when obtaining the driver, obtain the specific driver for Hortonworks. The same applies to Cloudera Hive.

When the JDBC driver of a database is not provided by Denodo, copy it to the folder <DENODO_HOME>/lib-external/jdbc-drivers/database name - version, in the host where the Denodo server runs. For example, for Teradata 15, copy the driver to <DENODO_HOME>/lib-external/jdbc-drivers/teradata-15. You do not need to restart after copying the driver there. Sometimes a JDBC driver is a set of jars and in that case, you need to copy all of them to this folder.