Configure Access to Denodo Resources in DBVisualizer
- Configure DbVisualizer on your local desktop or Azure Virtual Desktop (AVD) to connect to Denodo resources
- Create a new driver for Denodo.
- Open the DbVisualizer application and select the menu option Tools > Driver Manager.
- Select the plus icon to create a new driver.
- Load the Denodo JDBC Driver file.
- Reference the location of the denodo-vdp-jdbcdriver-8.0-ga.jar file by clicking the folder icon on the right side of the Driver Manager window.
- Location on AVD is C:\Program Files\DbVisualizer\denodo-vdp-jdbcdriver-8.0-ga.jar.
- Configure the specifications for the new Denodo Driver.
- Create a new DbVisualizer database connection to Denodo.
- Select DbVisualizer menu option Database > Create a Database Connection.
- Choose to create the connection manually.
- Specify connection information for the new Denodo Database connection.
- Select the Driver(JDBC) drop down options, choose Denodo then provide the following settings as specifications for the Database connection and save:
Name: denodo_prod (environment e.g. _dev, _qa, _prod)
Settings Format: Database URL
Database Type: Generic
Driver: Denodo
Database URL (Prod): jdbc:vdb://denodo-vdp.it-prod-bi.aws.umd.edu:9999/connectdb
Database URL (QA): jdbc:vdb://denodo-vdp.it-qa-bi.aws.umd.edu:9999/connectdb
Database Userid: Your Username (UMD directory ID)
Database Password: Your User password (UMD directory ID passphrase)
- Configure the SSL properties to enable ssl connection to the new Denodo database.
- Click the Properties tab of the newly created database connection (denodo_prod) then select the Driver Properties property in the left window pane.
- Check the options and specify True.
- Click the Apply button in the lower right side of the window.
Parameter: ssl
Value: True
Parameter: sslTrustedServerCertificate
Value: True
- Test your connection to Denodo database.
- Select the Connection tab, confirm you have correctly specified all the required options listed in step 6.
- Click the Connect button.
- After successfully testing your connection to the newly created denodo_prod database please execute your SQL queries as needed.
- In your queries you must preface the table name with the Denodo database name, e.g a query selecting count of rows in a KFS database table; select count(*) from kfs.ca_account_t