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 uses a built-in connector to connect to Denodo views. After launching Tableau Desktop, complete the steps below to configure your connection depending on your use case. See the From Tableau Server section below if you plan to publish workbooks to Tableau Server.
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 a training course or certification exam:
Click Register next to the course or Buy This Exam next to the exam. This opens the EventBrite website.
Click Reserve a spot, which will pop up a registration window.
Enter Promo code: DENEDUD-2020-UO and click Apply. This makes the course or exam free
Click Checkout and complete the registration.