Creating a Dataset from Open Connectors Query-Based Data Sources

You can create a dataset from an Open Connectors query-based data source.

Prerequisites

Note
If your SAP Analytics Cloud system is hosted on a data center located within China, this feature is not available.

Procedure

  1. Create a new dataset and choose a data source:
    1. Select Start of the navigation path (Main Menu) Next navigation step  Create Next navigation step  DatasetEnd of the navigation path.
    2. Select Data from a data source.
    3. Choose an Open Connectors query-based data source, such as Microsoft Dynamics CRM or Netsuite CRM 2018 Release 1.
    Note
    From the acquire data panel, you can select the filter icon, and then choose Open Connectors to show only the Open Connectors data sources in the list.
  2. Select an existing connection, or select Create New Connection to create a new connection.
  3. Type a name for your query.
  4. Select a table, 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.

  5. Select Create.

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

Next Steps

After importing the raw data, continue with data preparation before completing your dataset: About Adding Data to a Story.