Tableau Desktop

JDBC (Recommended)

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

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 Account for Connecting to Denodo

A service account has been created for connections to Denodo within Tableau for deployed workbooks. The credentials are below.

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