Updating the query for import type Compass Query

  1. On the SPE home page, select Data Management > Data Mapping.
  2. On the list view of the Data Mapping tab, select the name of the data mapping to update.
  3. Click Edit query to display the confirmation dialog box.
  4. Click Yes.
  5. Update the query in the Query text box.
    Queries support input parameters. To indicate an input parameter, use a colon (:) before the variable for the parameter.
  6. Click Run Query. Perform one of these steps based on these results:
    • If the query is correct and 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 cause of the error. After the update, click Run Query. Repeat until the correct search results are displayed.
  7. Click Apply to save the query.
    Note: To save the query that is not yet updated, click Save. A red exclamation point indicates that the data mapping must be configured.
  8. Click Yes.
  9. 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.
  10. Click Save.