How To connect DBeaver To Denodo Using JDBC

How To Connect DBeaver To Denodo Using JDBC

Here is a quick outline of how to configure DBeaver to connect to denodo using JDBC and a few references with other helpful information.

Copy jdbc driver from denodo to dbeaver

  • Copy from denodo engine server location: <DENODO_HOME>/tools/client-drivers/jdbc/denodo-vdp-jdbcdriver.jar to Dbeaver location: C:\Program Files\DBeaver\plugins

Configure DBeaver Driver

  • In DBeaver, navigate to Database > Driver Manager. 
Database > Driver Manager
  • Choose the ‘New’ button
  • Populate the Setting properties
    • Name: Denodo 7.0
    • Driver Type: Generic
    • URL Format: jdbc:vdb://<hostname>:<port>/<database>
    • Class Name: com.denodo.vdp.jdbc.Driver
  • In ‘Libraries’, Choose ‘Add File’ and navigate to ‘C:\Program Files\DBeaver\plugins’, Choose the denodo jar file and Click ‘Open’
  • Click ‘OK’ to Create and save the driver configuration.
  • Then, the Driver will be available in the Driver Manager for use

Related References:

DBeaver Documentation > Database drivers

Download URL for DBeaver software

DBeaver > Database Drivers

Connecting from your application – JDBC Clients

3 Comments

  1. Hi,

    Thank you for taking the time to document this.
    I have tried v7 and v8 of the Denodo JDBC driver but keep getting:
    No suitable driver found for jdbc:vdb://:/

    (actual values of servername etc. replaced)

    Any idea what’s wrong here?

    Thanks a lot

    1. Hello;

      Sorry, I don’t. The process has always worked for me, as long as
      I have placed the driver in the correct path and added the file to the library.

      Sincerely;
      Bert

Leave a Reply

%d bloggers like this: