Annotated XSD Mapping editor

The Annotated XSD Mapping editor is a three-paned editor: the source pane on the left side, the mappings pane in the middle, and the target pane on the right side. You can map relationships manually or 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 source pane (located on the left side of the mapping editor) contains a hierarchical tree view that represents the annotated XML schema. You can add source root elements using the Add Schema menu option.

The target pane (located on the right side of mapping editor) contains a hierarchical tree view that represents the database connection that the XSD file is associated with.

You can filter the target or source panes to show all, to hide unmapped objects, or to hide mapped objects. From the drop-down menu, select Show All to show all of the tree objects. 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 children that are all mapped.

Mappings pane

The mappings pane (located in the middle of the mapping editor) contains the mapping lines connecting input and output elements.

The mappings pane provides three views of the mappings:
Mappings view
The mappings view shows individual mappings between the 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.
You can select the view you want in the mapping pane by using the drop down menu in the mapping pane header.

From the mapping pane, you can filter both the source and target panes.

Outline view

The outline view shows summary information for the mapping document that is opened in the editor. The information is presented in a hierarchical tree, and cannot be modified. The outline view and mapping view are synchronized. The outline view is updated when you create or remove mappings in the editor.

Use the Find function to search for text strings in the outline view. When you select a mapping, a mapping's source, or a target node in the outline view, the corresponding mapping is also selected in the editor. The name of the mapping model is the parent node of the hierarchy. The child nodes are the sources, targets, and mapping groups. You can expand and collapse the outline view by mapping node.

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 editor.


Feedback