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.

JDBC Drivers supported by Virtual DataPort

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

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.