Supported JDBC Data Sources¶
The following table lists the databases for which Virtual DataPort provides a specific JDBC adapter.
To connect to a Database Management System (DBMS) that is not listed here, use the adapter “Generic”.
To connect to a DBMS 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 DBMS.
Database |
Version |
Notes |
Driver Included in Denodo |
|---|---|---|---|
Amazon Redshift |
N/A |
Yes |
|
Amazon Athena |
1.0 |
Yes |
|
Apache Derby |
10 |
Yes |
|
Apache Spark SQL |
1.5 |
No |
|
1.6 |
|||
2.x |
|||
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 |
2.0 |
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) |
|||
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 |
|||
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 |
|||
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 |
|||
PrestoDB and 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 |
|||
Teradata |
12 |
No |
|
13 |
|||
14 |
|||
15 |
|||
16 |
|||
Vertica |
7 |
No |
|
9 |
No |
||
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 does not include the JDBC driver of all the databases it supports. When that is the case, copy the file(s) of the driver 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.