Mapping Logical Entities to Physical Data

  1. In a web browser, go to:

    http://server:port/metadata-insights

    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 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 Mapped column.

    The color of the icon in the Mapped column indicates if it is mapped. Green indicates partial or complete mapping, while red indicates that the model is not yet mapped.

  5. In the Physical Model panel, select the physical model you want to map or its table or column to which you want to map the entities of your logical model. There are a few ways to create the mapping:
    Note: To create a new physical model, click in the panel and specify details in the Create Physical Model pop-up window. This model is now available for mapping.
    • 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.
  6. To delete any of the mappings or tables on the canvas, select it and click the Delete mapping icon in the tool bar.
  7. Click Save.

The mapping is saved and the mapping icon changes from read to green for this logical model in the Models tab of the Modeling page.