SSIS Components for SAP HANA XSA

Build 24.0.9062

カスタムクレデンシャル

You can use a custom OAuth app to authenticate with a service account or a user account. See OAuth 認証の使用 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 カスタムOAuth アプリの作成.

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 本製品 opens the OAuth endpoint in your default browser. Log in and grant permissions to the application. The 本製品 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.9062