Mapping editor

You perform your integration modeling from the mapping editor. The mapping editor is a three-paned editor that opens when you select or create a mapping model from the current data design project in the Data Project Explorer view by using the mapping editor wizard. You can map relationships manually and you can use the discover function to find relationships. Mapped relationships are represented in the mapping editor by lines drawn between source and target elements.

Source and target panes

The left pane contains the source data models in a hierarchical tree view. A root node represents a .dbm file in your data design project. You can add source schemas incrementally with the drag and drop function, or the Add Schema menu option.

The right pane contains the target data models or schemas. Targets are limited to one database or one XML schema.

The following example shows a simple mapping model. The source and target contain physical data models from the Derby database that is provided with the workbench. The graphic illustrates the source and target panes of the mapping editor The Source pane is on the left side of the editor. The Target pane is on the right side of the editor.
Figure 1. MappingsThe graphic displays a simple mapping model with one mapping included.

Mapping pane

The center pane contains the mapping lines and mapping hubs.

The mapping pane in the center of the mapping editor provides three views of the mappings. You can select the view you want in the mapping pane by using the drop down menu in the mapping pane header.
Mappings view
The mappings view shows individual mappings between source and target elements.
Mapping Groups view
The mapping groups view shows the mapping groups. A mapping group contains all of the mappings by target tables (in a relational database) or elements (in an XML schema document). There is one query that is generated for each mapping group. You can define filter, join, and sort conditions for mapping groups.
Mapping Group Details view
The mapping group details view shows the individual mappings between the source and target elements in a specified mapping group.
To add a bookmark, right-click on the mapping, mapping group, or discovery line and select Add Bookmark.
Figures Mappings, Mapping Group, and Mapping Group Details show examples of the mapping views.
Figure 2. Mapping GroupsThe graphic displays a mapping group view of the simple mapping model.
Figure 3. Mapping Group DetailsThe graphic displays the mapping group details view of the simple mapping model.

Viewing the mapped elements in a mapping editor that contains a large source or target tree can sometimes be difficult. The mapping editor provides filter options that you can select to hide the mapped or unmapped tree objects. The filter options are available from the drop down menus in the source and target views, and in the Mappings view. When you select the filter options from the Mappings view, the filter options apply to both the source and target trees. Select Hide Unmapped Objects to hide the tables and XSD complex elements that contain no mapped children. Select Hide Mapped Objects to hide the tables and XSD complex elements with children that are all mapped. Select Show All to show all of the tree objects. Select Hide Selected or Hide Unselected from the context menu options on the source and target panes to hide individual tree objects.

Outline view

The outline view captures the summary information of the mapping model that is currently active. The outline view shows the files as a hierarchical tree. You cannot modify this view. The outline view and the mapping editor are connected. As you update your mappings, the outline is also updated. The mapping editor and the outline view are always synchronized.

You can use the Find function to search for text strings in the outline view. This function is particularly useful when you have many mapped relationships, and the graphical representation contains numerous lines.

The name of the mapping model is the parent node of the hierarchy. The child nodes are the sources, targets, and mapping groups. Column transformations are shown in the mapping entry in the outline. Filters, joins and sorts are shown in the mapping group. You can expand and collapse the outline view by mapping nodes.

The outline view of a simple mapping model with one mapping line looks like the following example:
Figure 4. Outline view of a simple mapping modelThe graphic displays the outline view of a simple mapping model with one mapping included.

Properties view

The properties view is separate from the mapping editor, but provides details of the columns and table metadata. The properties view shows details about the selected object in the active editor. The following example displays the properties view when the mapping view that is shown in Figure 1 is selected.

Figure 5. Properties view of a simple mapping modelThe graphic displays the properties view of the simple mapping model.

Feedback