Before connecting to a U-M API Directory API, you need to have:
Denodo
From Tableau Desktop
Tableau currently offers both ODBC and JDBC Denodo connectors; however, as of Tableau 2023.1 the ODBC connector is deprecated and will likely be removed from a future version of Tableau. As a result, Tableau connections to Denodo should use the JDBC connector.
JDBC Connector Prerequisites
To register for an on-demand training course:
Log into or create an account on the Denodo Community site using your umich.edu email address. Note: When you log into a new account for the first time, please confirm that it is associated with U-M's enterprise license by performing the following steps:
In the account profile drop-down in the top right corner of the page, select Manage your Denodo Account.
Several Denodo data source types, including, but not limited to, Delimited, Excel, JSON, and XML, can be configured to connect to files on FTP/SFTP/FTPS hosts. For information on accessing an SFTP Server for files to be retrieved by Denodo, see the Denodo FTP/SFTP/FTPS Path page.
If you have access to or are able to create a server running SFTP, note the following:
Unit-Hosted Databases or ServersTo enable Denodo connections to databases or servers hosted by schools, colleges, or units, the server or database owner should submit a request to the appropriate support group to allow connections from the following Denodo server IP addresses: