Denodo: ODBC Setup (Windows)

This document provides the basic information for setting up a tool agnostic ODBC connection to Denodo.

Summary and Requirements

This document provides the basic information for setting up a tool agnostic ODBC connection to Denodo.

  • Must be connected to VPN or Campus Network
  • Must have administrative rights to computer (or have helpdesk do the setup)

 

Note: These instructions are for 64 bit Windows installations - if you are using any other operating systems, you may consider the JDBC Driver (link to other KB here)

Install Driver

  1. Download the most recent Windows driver from https://community.denodo.com/drivers/odbc/
    1. First time users will need to create a free Denodo Community account
      1. Use your “@wisc.edu” email address when signing up (not “@doit.wisc.edu, etc.) to qualify for free Community content
      2. In addition to allowing you to download the ODBC drivers, your Community account will get you access to a great deal of additional training materials and free self-paced learning tracks on community.denodo.com
  2. Extract the contents of the zip to a convenient location
  3. Run the DenodoODBC_x64.msi file
    1. The installer can be found under the “msi” folder
      1. Folder > denodo-vdp-odbcdriver-windows > msi
    2. Note: If your computer flags the installer file as a risk, you can override that by clicking More Info (note: only ever override files you trust)
      Windows Installer warning from Microsoft Defender, click "More Info"
    3. And then click Run anyway
      Windows Defender, choose button "Run anyway"

 

  1. Accept the License Agreement and click Next
  2. Do not change settings on the following page, click Next
  3. Click Install (will trigger admin rights needed, enter appropriate credentials)

Setup DSN

  1. Once your ODBC driver is installed, open ODBC Data Source Administrator (64-bit)
    1. When searched from start menu, also appears as “ODBC Data Sources (64-bt)”
    2. Note: may need to choose “Run as Administrator" if you encounter errors
  2. In System DSN or User DSN tab, depending on the scale you’d like to define, click Add
    1. Note: User is only for current user, System is global but requires admin privileges
  3. Select the DenodoODBC ANSI(x64) driver
    Create New Data Source dialog - choosing DenodoODBC ANSI(x64)
  4. Set up DSN using the following variables
    1. Data Source: Name the connection (Recommended: DenodoODBC)
    2. Description: Optional description
    3. User: YourNetID@wisc.edu
    4. Server: connect.data.wisc.edu
    5. Port: 9996
    6. User: YourNetID@wisc.edu
    7. Password: Your NetID password
    8. Database: semantic (default db, can connect to all once logged in)
    9. SSL Mode: Required (can leave ‘Start Encrypted’ unchecked)

Denodo ANSI ODBC Driver dialog, showing required fields completed using conventions listed above

  1. Click Save

Detailed Vendor Information

Additional variables and settings for the Denodo ODBC driver can be found on their support website

 

Related Articles

Denodo - Using Data Catalog Tools

Denodo - Connect DBeaver to Denodo

Denodo - Connect Tableau Desktop to Denodo

Need More Information?

If you have questions about this document, please contact Data, Academic Planning and Institutional Research (DAPIR, https://data.wisc.edu/) at badgerdata@wisc.edu.

See Also


Keywords:
Denodo ODBC DSN 
Doc ID:
155244
Owned by:
James F. in Data KB
Created:
2025-10-01
Updated:
2025-11-25
Sites:
Data, Academic Planning & Institutional Research