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