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
-
Create a new dataset and choose a data source:
- Select .
- Select Data from a data
source.
- 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.
-
Select an existing connection, or select Create New
Connection to create a new connection.
-
Type a name for your query.
-
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.
-
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.