Before connecting to a U-M API Directory API, you need to have:
Denodo
Tableau uses a built-in connector to connect to Denodo views. After launching Tableau, complete the steps below to configure your connection.
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
DBeaver Community Edition is the U-M recommended SQL client for use with Denodo. Follow the instructions below to configure DBeaver using Kerberos authentication with supplied username/password (not Single Sign-On).
This document describes the process to create a Denodo data source against a Dropbox file via the Dropbox API. Note that Dropbox shareable links do not work with Denodo due to a failure to follow Dropbox redirects. Authenticated calls via the API are required to connect Denodo to any Dropbox files. Dropbox API utilities are used to generate an OAuth token that can be stored in Denodo.
This document describes the process to create a Denodo data source against Google BigQuery using the OAuth client ID pre-generated token scheme.
This document assumes use of the JDBC Simba BigQuery driver.
Data Owner Configures the GCP Project
Within the GCP project:
This document describes the process to create a Denodo data source against Google BigQuery using the OAuth client ID pre-generated token scheme. In general, the data source is configured using a Google service account, but there are instances where an OAuth client ID approach is necessary.
Note: The Desktop App Configuration is recommended by U-M. Use that model, if possible.
This document contains information related to creating a Denodo data source against a Google Sheet using the Denodo Google Sheets Custom Wrapper.
Instructions
Follow the vendor-provided instructions with the following exceptions when using the Denodo OAuth 2.0 Credentials Wizard:
This document describes how to create a Denodo data source against a One Drive file using either an Authenticated or Unauthenticated method.
Authenticated Method
If the file is not shared, shared privately with specific users, or shared via a link with users in the U-M organization, authenticated calls via the Microsoft Graph API are required. Azure API utilities is used to generate an OAuth token that can be stored in Denodo.
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: