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|
|Apache Spark SQL||1.5||Yes|
|Hadoop / Hive||0.7.1||Yes|
|Hive||0.11.0 (Hive Server 2)||Yes|
|0.12.0 (Hive Server 2)|
|9 for z/OS|
|10 for z/OS|
|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.
|E-Business Suite 12|
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.
|Sybase||12||Either you can use the Sybase driver or the jTDS open source driver.||Yes: Denodo provides the jTDS driver.|
For legal reasons, the Denodo Platform cannot include the JDBC driver of all the databases it support. 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.
Note that even if a database is not listed here, you can use the generic adapter to connect to it.