Supported JDBC Data Sources

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

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
Greenplum 4.2   Yes
Hadoop / Hive 0.7.1   Yes
0.10
Hive 0.11.0 (Hive Server 2)   Yes
0.12.0 (Hive Server 2)
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.

Yes: Denodo provides the JTDS driver.

The Microsoft driver has to be downloaded from its website.

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 TimesTem, 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
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

When the JDBC driver of a database is not provided by Denodo, it has to be downloaded from the vendor’s website. After this, you can either copy the jar file(s) of the driver to the directory <DENODO_HOME>/extensions/thirdparty/lib and restart the Virtual DataPort server, or when you create a new JDBC data source to this database, specify the jar file(s) containing of the driver.

Note that even if a database is not listed here, you can use the generic adapter to connect to it.