Supported JDBC Data Sources

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

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

To connect to a database that is listed here but the version you are connecting to is newer than the versions listed here, use the most recent adapter for this database.

JDBC adapters included in the Denodo Platform

Database

Version

Notes

Driver Included in Denodo

Amazon Aurora PostgreSQL

12

Yes

Amazon Aurora MySQL

5

No

Amazon Redshift

N/A

Yes

Amazon Athena

1.0

Yes

Apache Derby

10

Yes

Apache Spark SQL

1.5

Yes

1.6

2.x

2.x Databricks

Azure SQL

N/A

Yes

Azure Synapse SQL (previously known as Azure SQL Data Warehouse)

N/A

Yes

Cassandra

3.x

Using DbSchema/DataStax JDBC Driver for Apache Cassandra

Yes

Databricks

N/A

Yes

Elasticsearch

6.4

Yes

6.7

Google BigQuery

No

Greenplum

4.2

Yes

Hive

0.13.0 (Hive Server 2)

No (*)

1.1.0 (Hive Server 2)

2.0.0 (Hive Server 2)

3.1.2 (Hive Server 3)

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

11

11 for z/OS

Impala

1.2.4

No (**)

2.3

3.x Kudu

Informix

7

No

12

Microsoft SQL Server

2000

Denodo uses the official Microsoft JDBC driver to connect to the versions 2017, 2016 and 2014.

You can choose the jTDS or the official Microsoft JDBC driver to connect to the versions 2008, 2008R2 and 2012.

Denodo uses the jTDS JDBC driver to connect to the versions 2000 and 2005.

Both drivers are included.

2005

2008

2008R2

2012

2014

2016

2017

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

18c

19c

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

10

11

12

PrestoDB

N/A

Yes

PrestoSQL

N/A

Yes

SAP HANA

1.0

No

2.0

Snowflake

N/A

Yes

Sybase ASE / SAP ASE

12

Either you can use the Sybase driver or the jTDS open source driver.

Yes: Denodo provides the jTDS driver.

15

SAP IQ (formerly known as Sybase IQ)

16

To connect to this data source you need to use the jConnect driver included in the SAP IQ installation.

No

Teradata

12

No

13

14

15

16

Vertica

7

Yes

9

Yes

Denodo Virtual DataPort

7

Yes

8

Yellowbrick

N/A

Yes

(*): 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.

(**): To connect to Impala, use a JDBC driver version 2.5.24 or higher. You can download the latest JDBC driver from the Cloudera website . You have to select the latest driver that IS NOT “C6 compatible”.

For legal reasons, the Denodo Platform cannot include the JDBC driver of all the databases it supports. When that is the case, use the wizard of the menu File > Extension management of the Administration Tool to import the driver. The section Importing a JDBC Driver explains how to do this.

The adapters for Virtual DataPort version 7 and 8 can be used to connect to other Virtual DataPort servers and the adapter of 8, to connect to the Virtual DataPort server itself.