See information about the latest product version
Graphical Data Mapping editor
You use the Graphical Data Mapping editor to create and edit graphical data maps.
You can use the Graphical Data Mapping editor to take input (source) objects and transform them in some way before saving the resulting output (target) objects.
Here is an example of the Graphical
Data Mapping editor. The input
objects are shown on the left side of the canvas, and the output on the right side. You
can create connections between the input and output elements by clicking on the grab
handle , which appears when you point to an element, and dragging the mouse to the
element that you want to connect to. You can do this either from left to right or from
right to left. The properties of the elements are shown in the Properties pane.

Wizards and dialog boxes are provided for tasks such as adding mappable elements, working with ESQL, and working with submaps. Mappings that are created with the Graphical Data Mapping editor are automatically validated and compiled, ready for adding to a broker archive (BAR) file, and subsequent deployment to WebSphere® Message Broker.
Icon | Label | Action |
---|---|---|
![]() |
Add an input object | Adds an input object to the map by selecting a map input. |
![]() |
Add an output object | Adds an output object to the map by selecting a map output. |
![]() |
Sort mapping by source | Sorts the mapping objects so that the appearance of transforms are prioritized by the source. |
![]() |
Sort mapping by target | Sorts the mapping object so that the appearance of transforms are prioritized by the target. |
![]() |
Delete selected elements | Deletes the element or elements that are currently highlighted. |
![]() |
Create a new transform | Creates a new transform for the map. |
![]() |
Auto map input to output | Automatically maps elements using the Automap Wizard. |
![]() |
Select rows from a database | Opens the New Database Select window. You can add a new database, or select from an existing database. You can select multiple columns, and enable a where clause to select rows conditionally. |
![]() |
Insert a row into a database table | Opens the New Database Table Insert Into window. You can add a new database, or select from an existing database. |
![]() |
Update a row in a database table | Opens the New Database Table Update window. You can add a new database, or select from an existing database. You can select multiple columns, and enable a where clause to update rows conditionally. |
![]() |
Delete a row from a database table | Opens the New Database Table Delete window. You can add a new database, or select from an existing database. You can select multiple columns, and enable a where clause to delete rows conditionally. |
![]() |
Show object preferences | Opens the Preferences window for the currently selected object. |