Import Data Connection to SAP Cloud for Customer

You can create a connection that allows you to import data from SAP Cloud for Customer, and SAP Cloud for Customer Analytics.

Context

Note
While OData exposes one-to-many navigation, SAP Analytics Cloud cannot follow these relationships because doing so would distort the measures at the parent level. OData v4.0 supports Lambda operators “any” and “all”, which can reduce the collection of children to a single Boolean value. For this to work, both the server and SAP Analytics Cloud must support OData v4.0.

Procedure

  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 either SAP Cloud for Customer or SAP Cloud for Customer Analytics.
  3. In the New Connection dialog, do the following:
  4. Enter a name for the connection.
  5. Enter the Data Service URL in the following format: https://<system URL>/sap/byd/odata/cc_home_analytics.svc.

    For example: https://my123456.vlab.sapbydesign.com/ sap/byd/odata/cc_home_analytics.svc.

    Note
    All the parameters entered in the Data Service URL field are ignored in both authentication and data queries.
  6. Select the authentication type.
  7. 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 the option 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.
    Note

    Select the Enable users to schedule for story publishing option if you want to let your users schedule the publishing of stories.

  8. Choose Create.
    The new connection is added to the list of connections on the Connections screen.
  9. If you want to create a model based on this connection, see Import Data to Your Model.