How To connect DBeaver To Denodo Using JDBC

Bert SwopePosted oninAll categories, Databases And Data Virtualization, Technology And Information Management, VQL (Denodo)3 Comments
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

    Reply

    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

      Reply
  2. Pingback: Introducing DBeaver – Bert's Blog

Leave a Reply

%d bloggers like this: