...

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

• 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

...

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 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 workbookvia TechConnect. Tickets should be assigned to Andrew Levine.

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

...