Versions Compared

Version Old Version 12 New Version Current
Changes made by

Matthew Girard

Matthew Girard

Saved on

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 (URLs can be found here), Database, Port (9999 for JDBC, 9996 for ODBC), check Require SSL, and enter your Username and Password. This can be your personal UTLN and password or a service account.

For development work, you should use the development VDP server. For local or deployed production workbooks you should use the production VDP server.

...

References

...

In order for workbooks using a Denodo JDBC data source to be published to a Tableau Server, the server needs to be updated to include the Denodo JDBC connector and driver. The steps below outline how to accomplish this.

  1. Add the Denodo JDBC Connector (https://tufts.box.com/s/6fxx0xx3lv4gk6v7k3ymdr1rzgznye6h ) under C:\Program Files\Tableau\Connectors

  2. Add the Denodo JDBC Driver (https://tufts.box.com/s/vhrkabwsquy4bssil8hh7cmi2mqus8k0 ) under C:\Program Files\Tableau\Drivers

  3. Restart Tableau Server using tsm pending-changes apply in the command line, entering y when prompted to restart.

...

https://help.tableau.com/current/pro/desktop/en-us/examples_connector_sdk.htm

Service

...

Accounts for Connecting to Denodo
Anchor
service-accounts
service-accounts

A service account has been created for connections to Denodo within Tableau for deployed workbooks. The credentials are belowis 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 via TechConnect. Tickets should be assigned to Andrew Levine.

Username

zdenodo_tableau_prd

Password

AWS Secrets Manager Link

Known Issues

Denodo Connection Times Out

Issue

Occurs when adding new fields. Can be bypassed by cancelling, refreshing the data source and trying again.

...

Cause

Tableau ODBC connector for Denodo doesn’t keep connection alive and doesn’t reconnect after the connection closes.

Solution

  1. If Live connection is a must, click Refresh in the Data Source tab.

  2. If Extract is accpetable, set connection to Extract. If encountering error while creating/refreshing an extract, refresh the Data Source.

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

...