Configure Access to Denodo Resources in DBVisualizer


Workday replaced KFS

As of 11/15/2024, Workday replaced KFS as UMD's official accounting system. KFS will temporarily remain available in read-only mode before full decommission.

  1. Configure DbVisualizer on your local desktop or Azure Virtual Desktop (AVD) to connect to Denodo resources 
  2. 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. 
      Denodo Toolkit with driver buttons
  3. 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. 
  4. Configure the specifications for the new Denodo Driver.
    • Provide the following settings as specifications for the new Denodo driver.
    • Once complete, close the Driver Manager window.

      Name      : Denodo
      URL Format (Prod): jdbc:vdb://denodo-vdp.it-prod-bi.aws.umd.edu:9999/connectdb
      URL format (QA): jdbc:vdb://denodo-vdp.it-qa-bi.aws.umd.edu:9999/connectdb
      Driver       Class: com.denodo.vdp.jdbcdriver.VDBJDBCDriver

  5. Create a new DbVisualizer database connection to Denodo.
    • Select DbVisualizer menu option Database > Create a Database Connection.
    • Choose to create the connection manually.
  6. 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)
  7. 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
      Denodo new connection ssl properties screen
  8. Test your connection to Denodo database.
    1. Select the Connection tab, confirm you have correctly specified all the required options listed in step 6.
    2. Click the Connect button.
    3. After successfully testing your connection to the newly created denodo_prod database please execute your SQL queries as needed.
    4. 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
      Denodo testing the database connection screen