Configure a Connection Profile

From the CData ribbon, click Get Data and select From SAP Cloud for Customer connection/s to launch the CData Query window. To setup a new connection, you will have to click the New SAP Cloud for Customer Connection button. Here you can set the connection settings, test the connection, and save the connection profile.

Connecting to SAP Cloud for Customer

To identify your SAP Cloud for Customer instance, set the following:

• Tenant: The full domain name of your SAP Cloud for Customer tenant.
• Url: The URL corresponding to your SAP Cloud for Customer instance. You must specify this if it differs from the default service of "c4codata". Otherwise, omit this connection property.

Authenticating to SAP Cloud for Customer

User Credentials

Set the AuthScheme to Basic and specify the following:

• User: Your SAP Cloud for Customer username.
• Password: Your SAP Cloud for Customer password.

Azure AD

Set the AuthScheme to AzureAD.

Configuring a Custom Extension

This configuration requires a custom extension to SAP Hybris. This extension can be created using the yempty tool.

Connection Configuration

After configuring your custom extension, set the following to authenticate:

• OAuthClientId: The application Id of the connector application, found in the Overview section of the app registration.
• OAuthClientSecret: The client secret value of the connector application. Azure AD displays this when you create a new client secret.
• CallbackURL: The redirect URI of the connector application. For example: https://localhost:33333
• SSOProperties: Set the following additional properties, each separated by a commma, in the format A=B;C=D; etc.
  • Resource: The URL of your environment.
  • AzureTentant: The Id of the Azure AD tenant where the applications are registered.

Connection Properties

The Connection properties describe the various options that can be used to establish a connection.

Managing Connections

After successfully authenticating to SAP Cloud for Customer you will be able to customize the data you are importing. To learn more about this, see Managing Connections.

See Also

• Querying Data: Use the data selection wizard to pull data into a spreadsheet. You can also configure scheduled data refresh here.
• Using the Excel Add-In: Find other ways to interact with SAP Cloud for Customer data, such as using the available CData Excel Functions.