Version 25.3.9396

• Add the SAP HANA XSA Connector
• Authenticate to SAP HANA XSA
  • Basic
  • OAuth
  • OAuth Password
  • None
• Complete Your Connection
• More Information

You can use the SAP HANA XSA connector from the CData Sync application to capture data from SAP HANA XSA and move it to any supported destination. To do so, you need to add the connector, authenticate to the connector, and complete your connection.

Add the SAP HANA XSA Connector

To enable Sync to use data from SAP HANA XSA, you first must add the connector, as follows:

1. Open the Connections page of the Sync dashboard.

2. Click Add Connection to open the Select Connectors page.

3. Click the Sources tab and locate the SAP HANA XSA row.

4. Click the Configure Connection icon at the end of that row to open the New Connection page. If the Configure Connection icon is not available, click the Download Connector icon to install the SAP HANA XSA connector. For more information about installing new connectors, see Connections.

Authenticate to SAP HANA XSA

After you add the connector, you need to set the required properties.

• Connection Name - Enter a connection name of your choice.

• URL - Enter the URL for your OData service endpoint.

CData Sync supports authenticating to SAP HANA XSA in several ways. Select your authentication method below to proceed to the relevant section that contains the authentication details.

• Basic (default)
• OAuth
• OAuth Password
• None

Basic

To connect with your user credentials, set the following properties:

• Auth Scheme: Select Basic.

• User: Enter the username that you use to authenticate to your SAP HANA XSA account.

• Password: Enter the password that you use to authenticate to your SAP HANA XSA account.

OAuth

To connect with OAuth custom credentials, specify the following properties:

• Auth Scheme: Select OAuth.

• OAuth Client Id: Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.

• OAuth Client Secret: Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.

• XSUAAURL - Enter the User Account and Authentication (UAA) service URL.

OAuth Password

To connect with your user credentials, specify the following properties:

• Auth Scheme: Select OAuthPassword.

• User: Enter the username that you use to authenticate to your SAP HANA XSA account.

• Password: Enter the password that you use to authenticate to your SAP HANA XSA account.

• OAuth Client Id - Enter the client Id that you were assigned when you registered your application with an OAuth authorization server.

• OAuth Client Secret - Enter the client secret that you were assigned when you registered your application with an OAuth authorization server.

• XSUAAURL - Enter the User Account and Authentication (UAA) service URL.

None

To connect without authentication, select None for Auth Scheme. No additional properties are required.

Complete Your Connection

To complete your connection:

1. Define advanced connection settings on the Advanced tab. (In most cases, though, you should not need these settings.)

2. If you authenticate with OAuth, click Connect to SAP HANA XSA to connect to your SAP HANA XSA account.

3. Click Create & Test to create your connection.

More Information

For more information about interactions between CData Sync and SAP HANA XSA, see SAP HANA XSA Connector for CData Sync.