To add a driver with DbVisualizer:

  1. Open DbVisualizer.
  2. From the menu, select Tools>Driver Manager. The Driver Manager window opens.
  3. From the Driver Manager menu, select Driver>Create Driver.
  4. Click the button to navigate to the location of the driver jar file; then, click OK. The following are the default locations for the driver:

    Windows

    C:\Program Files\Progress\DataDirect\JDBC\lib\60\denodo.jar

    Linux

    /opt/Progress/DataDirect/JDBC/lib/60/denodo.jar
  5. Provide values for the following fields; then, close the Driver Manager window.
    • Name: Type an alias for your driver. For example:
      Denodo
    • URL Format: Optionally, specify the format of the connection string for your driver. For example: 
      jdbc:datadirect:denodo://myserver:9996;DatabaseName=mydb
    • Driver Class: From the drop down menu, select the driver class for your driver. For example:
      com.ddtek.jdbc.denodo.DenodoDriver
You can now use your driver with DbVisualizer. Proceed to "Connecting and executing SQL statements" for information on connecting and executing SQL statements.