Tableau Desktop

ODBC (Recommended)

Install the Denodo ODBC connector pictured above. The ODBC connector is listed simply as Denodo.

JDBC

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://community.denodo.com/answers/question/details?questionId=9064u0000004Ff1AAE&title=How+to+connect+Denodo+with+SSL+certificate+in+Tableau%3F

• https://community.denodo.com/docs/html/browse/latest/en/platform/installation/postinstallation_tasks/enable_ssl_connections_in_the_denodo_platform_servers/enabling_ssl_for_external_clients#enabling-ssl-tls-for-external-clients

• https://community.denodo.com/kb/en/view/document/How%20to%20connect%20to%20Denodo%20from%20Tableau%20Desktop

• https://community.tableau.com/s/question/0D54T00000F339uSAB/customize-jdbc-connections-using-a-properties-file

• https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_jdbc_connection_url

Tableau Server

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

References

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

Service Accounts for Connecting to Denodo

A service account is 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.

Known Issues

Taco package signature verification failure

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

Tableau Desktop

Tableau.exe -DDisableVerifyConnectorPluginSignature=true

Tableau Server

tsm configuration set -k native_api.disable_verify_connector_plugin_signature -v true --forcekeys
tsm pending-changes apply