Table of Contents |
---|
Tableau Desktop
...
ODBC (Recommended)
...
Install the Denodo ODBC connector pictured above. The ODBC connector is listed simply as Denodo.
JDBC
Note |
---|
There is currently a bug in Tableau’s Taco-based connectors that causes intermittent failures. See below. While JDBC is the connector recommended by both Tableau and Denodo, the workaround for this bug isn’t acceptable at Tufts due to security concerns. As such, we currently recommend using the ODBC connector. |
Download and install the JDBC Connector (.taco file) through the app, or online here: https://exchange.tableau.com/products/303
For Mac, place it under ~/Users/[user]/Documents/My Tableau Repository/Connectors
For Windows, place it under C:\Users[Windows User]\Documents\My Tableau Repository\Connectors
For the driver, download it here: https://tufts.box.com/s/vhrkabwsquy4bssil8hh7cmi2mqus8k0
For Mac, place it under ~/Library/Tableau/Drivers
For Windows, place it under C:\Program Files\Tableau\Drivers
...
Connecting
Once you have either the ODBC or JDBC connector installed, click on the connector and fill in Server, Database, Port (9999), check Require SSL, and enter your Username and Password. This can be your personal UTLN and password or a service account
...
References
...
https://help.tableau.com/current/pro/desktop/en-us/examples_connector_sdk.htm
Service
...
Accounts for Connecting to Denodo
A service account has been created for connections to Denodo within Tableau for deployed workbooks. The credentials are below. For support around service account creation, contact Jon Riceis recommended for workbooks that are to be deployed.
The account below is for internal Data Strategy use only. Additional service accounts can be created upon request if you wish to deploy a workbook.
Username | zdenodo_tableau_prd |
---|---|
Password |
Known Issues
Taco package signature verification failure
Anchor | ||||
---|---|---|---|---|
|
It’s a known issue that verification of Taco-based package signatures can fail in Tableau. This affects both Tableau Desktop and Tableau Server. To get around the issue, you can disable package signature verification. How to do this is outlined below. Reference: https://community.denodo.com/kb/en/view/document/How%20to%20update%20the%20Tableau%20Denodo%20JDBC%20connector%20to%20support%20OAuth%20Authentication?tag=Consumers
...