Tool Window Mapping

Prerequisite

The tool window only appears if you have a license for Innovator for Database Architects.

Purpose

• You can select individual entities, whole packages or the entire model for mapping. To do this, drag the appropriate elements from e.g. the model structure and drop them in the list of selection elements.

• You can check which elements will actually be mapped. If e.g. the list only contains one package, all elements in the package which correspond to the mapping are mapped. The list of selection elements may also contain elements which do not affect the mapping. Use the button "Calculate Source Elements..." to show the elements which will actually be mapped.

• You can see what the mapping would actually change. The right-hand tree of the target model shows all elements which would be changed in blue and all elements which would be created in green.

• You can carry out the mapping.

Tool Window Structure

A toolbar is at the top. This comprises of:

• Mapping: The drop-down list contains all configured mappings. The mapping you want first needs to be selected so you can see the area for the selection elements and target model.

• Calculate Source Elements...: The selection elements are used to calculate the elements which will actually be mapped. These are shown in a dialog.

• Preview: The elements which would be changed or created in the target model are calculated. The respective elements are highlighted in the target model's tree. If you hover the mouse over the picture of the blue elements, a tool tip appears which tells you what exactly would be changed. If you want to cancel the preview, click on "Preview" again. The button is shown as "normal" again and no elements are highlighted in the target model.

• Execute: The mapping is executed. As with the preview, the modified and newly-created elements are highlighted.

• Show All: The button is only shown if a preview is shown or if the mapping was executed. You can set whether the elements which aren't affected by the mapping should also be shown in the target element's tree or not.

The list of selection elements can be see on the left. This is not shown until a mapping is selected. If the list is empty, a text is shown that tells you that you should drag the select elements there. This text disappears once you have dragged the first element there and the respective element is shown instead. You can then drag further elements in the list. Use the context menu to remove selected elements from the list. You can drag all possible elements in the list. The element is not checked to see whether it is a good idea to use for the selected mapping to save time. Use the button "Calculate Source Elements..." to carry out a similar check yourself.

Note: It is irrelevant which selection elements are selected in the list for the "Calculate Source Elements...", "Preview" and "Execute" buttons. All elements are always used.

The target model can be see on the right. This is not shown until a mapping is selected. The target model needs to be set first. The drop-down list contains all submodels. The corresponding part of the model structure is shown once you select the submodel you want.

Navigating

The context menu for the list of selection elements and target model's tree contains extra menu items as well as the usual suspects. These menu items only appear if the selected element has already been affected by the mapping. A menu item exists for each element linked via a mapping.

Example:

An entity is selected in the list of selection elements. The entity has already been mapped once. The context menu has an extra menu item at the bottom of the list. This has the name of the table the entity was mapped to. The table's stereotype icon is also shown. If you click on this menu item, the target model's tree is expanded so that the respective table is visible. The table is selected and moved to the forefront.

You can now jump between the list of selection elements and target model's tree.

A message appears if the corresponding element does not exist in the target tree. This would be an indication that you have selected the wrong target element or that the element has already been mapped to the wrong target model.

The relevant element is added if it is not in the list of selected elements.