Exporting Data Connection to OData Services
You can create a connection that allows you to export data to OData services.
Procedure
-
Go to (Main
Menu)
Connection Connections (Add
Connection)
The Select a data source dialog will appear.
- Expand Acquire Data and select OData Services.
-
In the New OData Services Connection dialog, do the following:
- In the Connection Information section, add a connection name and a description.
-
If you're connecting to an SAP BW on-premise system, select Connect to an
On-Premise OData service, and then select the location
of your cloud connector from the list.
Note
Make sure to complete the prerequisites found in Exporting Data to OData Services before connecting to an on-premise source. When you select this option, specific SAP metadata is respected. This metadata specifies default behaviors based on SAP OData services guidelines; for example, filterable and sortable are by default true, if not claimed to be false, and support basic filter operators. For more information see SAP Annotations for OData Version 2.0.
If this option is not selected, the connection won't work.
-
Enter the Data Service URL that was created
during your configuration.
Note
The server address and port are required for both SAP BW on-premise products. For example: https://<BW SERVER:PORT> for SAP BW On-Premise. And the URL should look like: https://<BW SERVER:PORT>/sap/opu/odata/sap/RSBPC_ODATA_EXPORT_SRV
- Select the authentication type. You can choose between Basic Authentication, OAuth 2.0 Client Credentials, OAuthorization Code or No Authentication:
- Provide the authentication details based on the authentication type you selected:
- For Basic Authentication, enter the User Name and
Password of the user you want to import data
from. Note
If you want to share the credential details, select Share these credentials when sharing this connection. Otherwise, users will need to enter their own credentials in order to use the connection. If you don't share your credentials, users will be able to edit their credentials at any time without having to start a data acquisition process.
- For OAuth 2.0 Client Credentials, enter the OAuth Client ID, Secret, Token URL and Scope (if required) of the application you want to access.
- For OAuth 2.0 Authorization Code, enter the OAuth Client ID, Secret, Token URL, Authorization URL and Scope (if required) of the application you want to access. Before the connection is created, you will be redirected to the Authorization URL of your application where you can authorize SAP Analytics Cloud to access your data.
-
Choose Create.
The new connection is added to the list of connections on the Connections screen.