Connection using third party SQL clients

Applies to: Denodo 8.0 , Denodo 7.0 , Denodo 6.0
Last modified on: 04 Jun 2020
Tags: Backwards compatibility External clients JDBC driver

Download document

You can translate the document:

Content

Client applications can connect to Denodo Virtual DataPort in order to make the most of its data integration facilities. Virtual DataPort offers several mechanisms that clients can use to connect to the server. One of these mechanisms is the access through JDBC (Java DataBase Connectivity).

 

To connect to Virtual DataPort using any JDBC client, the driver information and a valid URL must be provided. The latest version of the JDBC driver is located at:

<DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar 

and the class that implements the driver is

com.denodo.vdp.jdbc.Driver

 

The syntax of the connection string is:

jdbc:vdb://<hostName>:<port>/[<databaseName>][?<paramName>=<paramValue>[&<paramName>=<paramValue>]* ]

 

For example:

jdbc:vdb://localhost:9999/admin?queryTimeout=100000

Although the recommended Virtual DataPort server client is the Virtual DataPort Administration Tool, different external clients like SQuirreL SQL, DBVisualizer, or SQL Workbench can be used to connect to the Virtual DataPort server. These clients have been successfully tested but they are not officially supported by Denodo.

In older versions of the Denodo Platform, whenever a new update for the Denodo Platform was installed, if the JDBC driver was also updated as part of the global update it was necessary to update the driver in every JDBC client using it.

From Denodo Platform 6.0 and onward when a new Denodo Platform update is installed, even if the JDBC driver is also updated, backwards compatibility is guaranteed for the JDBC client driver; client applications using the JDBC driver do not need to update the driver to the new version in order to connect to the Virtual DataPort server. However, it is still recommended to update the driver to take advantage of new functionality, optimizations, or bug fixes that might be included in the update for the benefit of client applications.

Questions

Ask a question
You must sign in to ask a question. If you do not have an account, you can register here

Featured content

DENODO TRAINING

Ready for more? Great! We offer a comprehensive set of training courses, taught by our technical instructors in small, private groups for getting a full, in-depth guided training in the usage of the Denodo Platform. Check out our training courses.

Training