Supported JDBC Data Sources¶
The following table lists the databases for which Virtual DataPort provides a JDBC adapter.
Consider this:
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.
Some database vendors forbid other software companies to include their drivers (in the table below, see the databases with the column Driver Included in Denodo = No):
To connect to one of these databases, download the official driver of the database, not the driver of another third-party company. Consider this:
We conduct the tests of each adapter using the official driver.
Only the official driver is really supported. If you use the driver of another company and something does not work, the Denodo Support Team will try to provide assistance but may not be able to provide a solution.
To import a driver, use the wizard of the menu File > Extension management to import the driver. The page Importing a JDBC Driver explains how to do this.
The Denodo Platform includes the drivers of the databases to make it easier for developers to create connections to data sources. Periodically, we upgrade these drivers so our customers benefit from bugfixes and enhancements. However, we cannot fix bugs in the drivers of other companies (only in the drivers developed by Denodo). If any issue arises due to bugs in these drivers, we will try to provide a workaround to the best of our ability but ultimately, it is up to the database vendors to fix the bugs in their own drivers.
Database |
Version |
Notes |
Driver Included in Denodo |
---|---|---|---|
AlloyDB for PostgreSQL |
12 |
Yes |
|
Amazon Aurora PostgreSQL |
12 |
Yes |
|
Amazon Aurora MySQL |
5 |
No |
|
Amazon Redshift |
N/A |
Yes |
|
Amazon Athena |
1.0 |
Yes |
|
Apache Derby |
10 and higher |
Yes |
|
Apache Spark SQL |
1.5 |
No |
|
1.6 |
|||
2.x |
|||
3.x and higher |
|||
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 |
|||
Exasol |
7.1 |
Yes |
|
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 and higher (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 and higher |
|||
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 2019, 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 |
|||
2019 and higher |
|||
MySQL |
4 |
No |
|
5 |
|||
8 and higher |
|||
GCP (Google Cloud) |
|||
Netezza |
4.6 |
No |
|
5.0 |
|||
6.0 |
|||
7.0 and higher |
|||
Oracle |
8i |
Yes |
|
9i |
|||
10g |
|||
11g |
|||
12c |
|||
12c In-Memory |
|||
E-Business Suite 12 |
|||
18c |
|||
19c and higher |
|||
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 and higher |
|||
GCP (Google Cloud) |
|||
PrestoDB |
N/A |
Yes |
|
PrestoSQL |
N/A |
Yes |
|
SAP HANA |
1.0 |
No |
|
2.0 |
|||
SAS |
9.4 |
No |
|
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”.
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.