Creating data mapping for import type Compass Query

Before you can perform data mapping with Compass Query, you must subscribe to the Data Lake the tables that are inserted in the query. If you are not subscribed, you cannot perform data mapping. You must refer to the documentation guide of your ERP to perform the subscription.

Note: Import type Compass Query is not available for Datapoints.

On the SPE home page, select Data Management > Data Mapping.
On the list view section of the Data Mapping tab, select the object for which to create the mapping.

You can create a data mapping for an organization and a period.
Click + to create a new mapping.
Specify a mapping name in the Name field. The name must be different from other mapping names.
Select Compass Query from the Import type drop-down list.
Click Create compass query to display the New Compass Query dialog box.
Specify the query to use in the Query field.
Queries support input parameters. To indicate an input parameter, use a colon (:) before the variable for the parameter.
Click Run Query. Perform one of these steps based on these results:
- If the query is correct and until the correct search results are displayed, review the results and validate them when necessary.
- If the query is correct but requires input parameters, specify values for the parameters in the Input Parameters field. Click Run Query. Review the results and validate them when necessary.
- If the query is incorrect and an error message is displayed, check your query and update to remove the cause of the error. After the update, click Run Query. Repeat until correct search results are displayed.
Click Apply to save the query and to display the Mapping section.

Note: To save the query that is not yet updated, click Save. A red exclamation point indicates that you must configure the data mapping.
Select a target in the Target field in the Mapping section. You must map all required target columns to a source to save the mapping.
Click Save.