Tableau Connector for SAP HANA XSA

Build 24.0.9060

Custom Credentials

You can use a custom OAuth app to authenticate with a service account or a user account. See Using OAuth Authentication for more information.

User Accounts

Desktop Authentication with a Custom OAuth App

Follow the steps below to authenticate with the credentials for a custom OAuth app. See Creating a Custom OAuth App.

Get and Refresh the OAuth Access Token

After setting the following, you are ready to connect:

  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
  • OAuthClientId: Set this to the Client Id specified in the UAA service JSON file.
  • OAuthClientSecret: Set this to the Client Secret specified in the UAA service JSON file.
  • Url: Set this to the OData service endpoint.
  • XSUAAURL: Set this to the UAA service host.
  • CallbackURL: Set this to http://localhost:33333.
When you connect the connector opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The connector then completes the OAuth process:
  1. Extracts the access token from the callback URL and authenticates requests.
  2. Refreshes the access token when it expires.
  3. Saves OAuth values in OAuthSettingsLocation to be persisted across connections.

Using Password Grant Type

To connect to SAP Hana XSA using the PASSWORD Grant type set the following:

  • InitiateOAuth: Set this to GETANDREFRESH. You can use InitiateOAuth to avoid repeating the OAuth exchange and manually setting the OAuthAccessToken.
  • OAuthClientId: Set this to the Client Id specified in the UAA service JSON file.
  • OAuthClientSecret: Set this to the Client Secret specified in the UAA service JSON file.
  • Url: Set this to the OData service endpoint.
  • OAuthGrantType: Set this to PASSWORD.
  • XSUAAURL: Set this to the UAA service url.
  • User: Set your accounts username.
  • Password: Set your accounts password

Copyright (c) 2024 CData Software, Inc. - All rights reserved.
Build 24.0.9060