Mapping Suggestions

Mapping suggestions helps you by suggesting the possible tables and columns that match your entity attributes. The suggestions are based on various logic and scoring methods run on the assets you have already discovered.
  1. In a web browser, go to:

    http://server:port/discovery

    Where server is the server name or IP address of your Spectrum Technology Platform server and port is the HTTP port. By default, the HTTP port is 8080.

  2. Log in using your credentials.
  3. Click Model.
  4. Select the logical model you want to map, and do one of these:
    • Click the Map Model icon in the tool bar.
    • Click the Map Model icon in the Actions column.
    The Create Mapping page is displayed, showing the selected logical model in a graphical form. The page also allows you to give a name to the mapping you are about to define.
  5. Enter a name for the mapping in the Mapping Name text box.
  6. Click the Entity Transformation icon corresponding to the entity you want to map. Alternatively, select the entity to be mapped, and click the Entity Transformation icon in the toolbar.
    The Entity Transformation wizard is displayed, showing Suggestions tab by default.
    • Attribute List: This column displays the list of attributes in the entity, their data type, and semantic type, if defined by you during model creation.
    • Mapping Suggestions: Shows the various tables and columns that map with the attributes in the selected entity. Each of the suggestions shows name of the table, name of the connection, and the connection type. For the assets, semantic type and data type are displayed.
  7. To filter the attributes based on whether those are Mapped or Not Mapped, use the Attribute List filter.
    Note: By default, all the attributes are displayed.
  8. To move through the various mapping suggestions, use the right and left arrows on the first and the third Mapping Suggestions respectively.
    Note: The pop up displays three mapping suggestions at a time, in a decreasing order of matching score. For example, if columns in the Lead table in a Salesforce connection called as FrameallSalesforce matches 95 percent with the attributes of the logical entity you have selected and another table ContactInformation in the same connection matches 90 percent, the Lead table will precede ContactInformation table in mapping suggestions.
  9. To refresh mapping suggestions, click the Reload unmapped suggestions icon .
    The suggestions get updated for the unmapped entities. No suggestions are displayed for mapped entities.
  10. To map all the suggested columns in any given Mapping Suggestions, click the Map all the suggested columns button on the top right.
  11. To map a specific column from Mapping Suggestions, click the mapping icon corresponding to the column.
    The mappings are displayed below the attributes with the mapping icon . The details displayed are: <Connection name>/<Table name>/<Column name>.
    Note: To delete the mapping, click corresponding to it. To cancel the updates made to this pop-up, click the Cancel button.
  12. Click OK.
    The mappings are displayed on the Create Mapping page.
  13. To save details, click Save on the Create Mapping page.