Exporting Data Connection to OData Services

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


  1. From the side navigation, choose Start of the navigation path 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.

      Make sure to complete the prerequisites found in the OData Services procedure in Export Models and Data before connecting to an on-premise source.

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

    3. Enter the Data Service URL that was created during your configuration.

      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.
    5. Enter the user name and password of the user you want to import data from.

      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.

  4. Choose Create.

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