Exporting Data Connection to OData Services

You can create a connection that allows you to export data to OData services.

Procedure

  1. Go to Start of the navigation path (Main Menu) Next navigation step  Connection Next navigation step Connections Next navigation step  (Add Connection)End of the navigation path

    The Select a data source dialog will appear.

  2. Expand Acquire Data and select OData Services.
  3. In the New OData Services Connection dialog, do the following:
    1. In the Connection Information section, add a connection name and a description.
    2. 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.0Information published on SAP site.

      If this option is not selected, the connection won't work.

    3. 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

    4. Select the authentication type. You can choose between Basic Authentication, OAuth 2.0 Client Credentials, OAuthorization Code or No Authentication:
    5. 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.
  4. Choose Create.

    The new connection is added to the list of connections on the Connections screen.