Importing Data into a New or Existing Model from Open Connectors Query-Based Data Sources

You can import data from an Open Connectors query-based data source to new or existing models.

Prerequisites

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

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

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

    For more information, see Import Data Connection to SAP Cloud Platform Open Connectors Query-Based Data Sources.

  3. Copy a query from an existing model (which you can edit before saving), or create a new query.
  4. 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.
  5. To create a new query, follow these steps:
    1. Select Next.
    2. Type a name for your query and select Create.
    3. 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.

    4. Select Create.

      You can continue to work on other tasks while the data is being uploaded in the background.

  6. When the draft data is finished uploading, open it from the Draft Data list (for a new model or dataset), or the Draft Sources list (for an existing model or dataset).

    The data appears in the data integration view.

Next Steps

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