TDV Adapter for Tableau CRM Analytics

Build 22.0.8462

Connecting to Tableau CRM

OAuth requires the authenticating user to interact with Tableau CRM using the browser. The adapter facilitates this in various ways as described in the following sections.

Create a Connected App

You can follow the procedure below to obtain the OAuth client credentials, the consumer key and consumer secret:

  1. Log in to Salesforce.com and click your user name to access Setup.
  2. If your organization uses the Salesforce Lightning Experience UI, from Setup enter App in the Quick Find box, select App Manager (not Manage Connected Apps), and click New Connected App.

    If your organization uses the Salesforce Classic UI, from Setup enter Apps in the Quick Find box and then select Apps, under Build or Create. Under Connected Apps, click New.

  3. Enter a name to be displayed to users when they log in to grant permissions to your app, along with a contact email address.
  4. Click Enable OAuth Settings and enter a value in the Callback URL box.

    Set the Callback URL to http://localhost:33333 or a different port number of your choice.

  5. Select the following OAuth scopes:

    Access and manage your wave data (wave_api)

    Access and manage your data (api)

    Perform requests on your behalf at any time (refresh_token, offline_token)

  6. Once you have created the app, click your app name to open a page with information about your app. The OAuth client credentials, the consumer key and consumer secret, are displayed.

Authenticate to Tableau CRM

After setting the following connection properties, you are ready to connect:

  • OAuthClientId: Set this to the consumer key in your app settings.
  • OAuthClientSecret: Set this to the consumer secret in your app settings.
  • CallbackURL: Set this to the callback URL in your app settings.
  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken connection property.

When you connect the adapter opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The adapter then completes the OAuth process:

  1. Gets the callback URL and sets the access token to authenticate requests.
  2. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.
  3. Exchanges the returned refresh token for a new, valid access token.

Copyright (c) 2023 CData Software, Inc. - All rights reserved.
Build 22.0.8462