Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
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.

  1. Download and install the JDBC Connector (.taco file) through the app, or online here: https://exchange.tableau.com/products/303

    1. For Mac, place it under ~/Users/[user]/Documents/My Tableau Repository/Connectors

    2. For Windows, place it under C:\Users[Windows User]\Documents\My Tableau Repository\Connectors

  2. For the driver, download it here: https://tufts.box.com/s/vhrkabwsquy4bssil8hh7cmi2mqus8k0

    1. For Mac, place it under ~/Library/Tableau/Drivers

    2. 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

AWS Secrets Manager Link

Known Issues

Taco package signature verification failure
Anchor
taco-bug
taco-bug

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

...