Denodo: Connect Tableau Desktop to Denodo

This article is meant to help Tableau developers using Tableau Desktop who wish to use Denodo as a data source. 

Connect Using ODBC (Recommended)

ODBC is the recommended connector for most users, as it comes pre-packaged with Tableau Desktop and requires no additional driver installation. 

NOTE: In older versions of Tableau Desktop the Denodo ODBC Connector is marked "Deprecated" - this is being corrected in future versions. Both Salesforce (Tableau) and Denodo have committed to persisting this connector. 

1. In Tableau, go to Data > New Data Source
2. Select To a Server > More… > Denodo (deprecated)
      
3. In the Denodo dialog fill in the following fields:
   1. Server: connect.data.wisc.edu
   2. Port: 9996
   3. Database: semantic (or virtual database you want to connect to)
   4. Authentication: Username and Password
   5. Username: your NetID email (e.g., netid@wisc.edu)
   6. Password: your NetID password 
   7. Select Require SSL 
   8. Click Sign In  

Connect Using JDBC 

Denodo Driver Files

The Denodo driver files for Tableau need to be downloaded and installed on your local computer in the My Tableau Repository folder in the Documents directory.

Instructions on installing the driver files for Tableau are found here.

Set Up Data Source

Once the two configuration steps are complete, Tableau Desktop will be able to connect to the UW Denodo resources.
Here is a step-by-step guide for connecting to the resources.

1. Open Tableau Desktop software.
2. On the left column, there is a section for connecting to a server. Select Denodo JDBC by Denodo Technologies.
   1. If you don’t see correct Denodo option, click on the More... option and search for Denodo.
       
3. After you click on Denodo, the following information should appear in the tab named General. 
   If it is not present, fill in the following information:
   1. Server: connect.data.wisc.edu
   2. Database: semantic
   3. Port: 9999
   4. Select Require SSL
   5. Authentication: Username and password
   6. User name: your NetID email address
   7. Password: your NetID password
   8. Click Sign In - A browser window will be displayed requesting your netid credentials to authenticate.
   9. Once that is complete, close the browser window. Tableau desktop is now connected and can be used.
      
      

NOTE: The database can be any of the UW Denodo databases. 

Related Articles

Denodo: Connect DBeaver to Denodo

Denodo: Connect to Data Marketplace

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.