Mapping through drag drop on canvas

  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 with your credentials.
  3. Click Modeling.
  4. Select the logical model you want to map and click the Map Model icon in the tool bar or the mapping icon in the Actions column.
    The Create Mapping page is displayed, showing the selected logical model in 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. In the Physical Model panel, select the physical model tables to which you want to map the entities of your logical model. Use one of these mapping methods, as applicable:
    • To map using drag-and-drop:
      1. From the list of models, click the required physical model. A list of all the tables contained in the model is displayed.
      2. Drag the table you want to the canvas. The table displays the columns and the data type of each column.
      3. Map a column to an attribute of a logical entity by dragging the mouse from the column to the attribute.
    • To map using the search box (useful when you know only the table name and not the model to which it belongs):
      1. Enter the search term in the search field and from the adjacent drop-down list, select Columns, Tables, or All, based on whether the term needs to be only in columns or tables, or in columns, tables as well as the models.

        The results are displayed below the search fields, showing the name of the column, data type, name of the table or view, and name of the physical model to which the table belongs.

      2. If you searched for a table, click it, and click the Add to Canvas button. The selected table gets added to the canvas and you can map it using the drag-and-drop method described above.
      3. If you searched for a column, click the column name. The Entity and Attribute fields appear. The Entity field lists all the entities in the currently mapped logical model, while the Attribute field lists all the attributes of the selected entity.
        Select the entity and attribute you want to map, then click the Mapping icon .
        Note: One attribute can be mapped to only one column at a time.
    • To convert a value in the physical model column before mapping it to a logical entity, use transformation. For more information, see Applying a Transformation.
    • To filter data from a logical model, click the Criteria Builder icon . For more information, see Criteria.
    • To combine data from columns of two physical model tables before populating the logical model columns, see Joins.
  7. To create a new physical model, click the Create Physical Model icon in the Physical Model panel, and specify details in the Create Physical Model pop-up window that is displayed. This model gets displayed in the Physical Model panel of the Create Mapping page. You can map it to the selected logical model.
  8. To delete any of the mappings or tables on the canvas, select it and click the Delete mapping icon in the tool bar.
  9. Click Save.
    The mapping is saved and you are navigated back to the Logical Model tab of the Modeling page.
  10. To view the mapping, click corresponding to the logical model.
    Mapping details are displayed under these headers:
    • Mapping Name: Name of the defined mapping
    • Mapped to: Name of the mapped physical model
    • Last modified: Date (mm:dd:yyyy) and time (hh:mm:ss) of last modification made to the mappings
    • Actions: Profile Model and Delete icons to profile and delete the mapping respectively.