Supported JDBC Data Sources¶
The following table lists the databases for which Virtual DataPort provides a specific JDBC adapter.
When a database is not listed here, use the adapter “Generic” to connect to it.
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:
Without 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 |
Note that even if a database is not listed here, you can use the generic adapter to connect to it.