Importing SAP Cloud for Customer Data to a New or Existing Model

You can create a connection that lets you import data from SAP Cloud for Customer.

Context

Note
SAP Cloud for Customer was formerly named SAP Hybris Cloud for Customer.

Procedure

  1. Select the appropriate option:

    • If you're creating a new model:

      1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  ModelEnd of the navigation path.
      2. Select Get data from a data source.
      3. Select SAP Cloud for Customer.
      Note
      From the acquire data panel, select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.

    • If you're importing into an existing model:

      1. Select Start of the navigation path (Main Menu) Next navigation step  Browse Next navigation step  FilesEnd of the navigation path.
      2. Open the model you want to update.
      3. Switch to the Data Management screen.

      4. Select Start of the navigation path Next navigation step Data sourceEnd of the navigation path.
      5. Select SAP Cloud for Customer.
      Note
      You can select the filter icon to narrow down the number of data sources in the list. You can filter by data source type or by category.
  2. Select an SAP Cloud for Customer connection type:
    • SAP Cloud for Customer: Use this data source type to connect to the SAP Cloud for Customer General OData API, which exposes lower level data objects used to create analytics in SAP Analytics Cloud.
    • SAP Cloud for Customer Analytics: Use this data source type to connect to the SAP Cloud for Customer Analytics OData API, which exposes analytical objects (reports) that users have already created in SAP Cloud for Customer products.

    For more information on the type of data you can access, see the SAP Hybris Cloud for Customer – OData Services - OData API Reference and the SAP Hybris Cloud for Customer Business Analytics Guide.

  3. Select an existing connection, or select Create New Connection to create a new connection.
    Note
    Advanced features of customized OData data sources, such as SAP Cloud for Customer and SAP Business ByDesign Analytics, are only available using customized data source types. These features are not available using generic OData services. It is highly recommended to use the relevant customized data source types, if available, for your data service to leverage full capability of the data connector. It is possible to request a customized OData data source solution.

    For more information, see:

  4. Copy a query from an existing model (which you can edit before saving), or create a new query.
  5. If you're using an existing query, select it from the list.
    1. If you want to make changes to the query, select Modify existing query.
    2. Make your changes, and then select OK.
  6. If you're creating a new query, enter a name for your query.
    1. Select a table or a template query, and then select Next.

      Build your query by moving data elements into the Selected Data and Filters areas. For more information, see Building a Query.

  7. Select OK.

    The data appears in the data integration view, where you can complete the mapping of your new data to the model's dimensions.

Next Steps

After the initial import of raw data, continue with the data preparation task before completing your model: Preparing Data.