Denodo - Connect to a U-M API Directory API

Before connecting to a U-M API Directory API, you need to have:

  • access to the U-M API Directory APIs using an application client ID and Client Secret. 
  • developer access to a Virtual Database (VDB) in Denodo.

Steps to Connect

  1. Log in to Denodo VDP using your credentials.
  2. Right-click on your VDB. 
  3. Navigate to New > Data Source > JSON.

  1. Enter a Name
  2. Select HTTP Client from the Data route drop-down list.

  1. Click Configure.

  1. Enter the API URL
    • The input parameters need to be specified within "@{}". 

  1. Click the Authentication tab. 
  2. Select/enter the following:
    • Select OAuth2.0 from the Authentication drop-down list.
    • Select Client Credentials Grant from the Authentication Grant drop-down list.
    • Enter the Client Identifier and Client Secret of the application that has access to the API.
    • Select the Send Client Credentials using the HTTP Basic authentication scheme radio button.

  1. Click launch the OAuth 2.0 credentials wizard to help you obtain these credentials
  2. Enter the Token Endpoint URL and Scopes for the API.

  • The token URL and scope values are available in the API Directory API. For example, the image below shows where to find these values for the CanvasReadOnly 2.0 API.

  1. Click Obtain the OAuth 2.0 credentials.
  2. Click OK
  3. Select the "Authorization" request header radio button in the Request signing method field. 

  1. Click OK
  2. Click the Configuration tab. 
  3. Click HTTP headers

  1. Click New
  2. Enter x-ibm-client-id in the NAME column, and the client ID value in the VALUE column. 

  1. Click OK
  2. Click the Test Connection button in the bottom-right of the Edit HTTP Connection window.
  3. Enter the value for the parameter(s) of the API URL. The screenshot below shows how this is configured using the example from step 11.

  1. Click OK
  2. If the connection tested successfully, click OK on the message window.
  3. Click Save

  1. Click Create base view

  1. Check the JSON root box to create the base view using the attributes in the document root.
    • If you only require values from a specific object, do not check the JSON root box. Enter the specific object path. 
    • Regardless of the root selected for the base view, depending on the JSON structure you may need to flatten arrays to access the attribute values. See the Creating Flatten Views for more information.

  1. Click OK
  2. Click Save once the field names display.
    • Fields can be deleted or added to transform the data. Consult the Denodo documentation for additional information regarding HTTP Paths and JSON data sources.


Last Updated: 
Wednesday, April 28, 2021