Connection using third party SQL clients

Applies to: Denodo 7.0 , Denodo 6.0 , Denodo 5.5 , Denodo 5.0
Last modified on: 02 Apr 2018
Tags: External clients Backwards compatibility 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 client to connect to the VDP server is the VDP Administration Tool, different external clients like SQuirreL SQL, DBVisualizer or SQL Workbench can be used to work with Virtual DataPort. 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 newer versions when a new Denodo Platform update is installed, even if the JDBC driver is also updated, the backwards compatibility is guaranteed. Thus the client applications using the JDBC driver do not need to update the driver to the new version. However, it is still recommended to update the driver to take advantage of any new functionality or optimization that might be included or if the client applications are benefited from any bugfix included in the update.

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