The following instructions describe how to specify a message and
a database as the data source.
- Right-click a node that supports mapping, such as the Mapping node,
and click Open Map.
- Follow the on-screen instructions to complete the New
Map wizard:
- On the Select the map type pane, ensure that input
message and database records are both selected.
- On the Source and Target Mappables pane, select the
message as the data source; do not select the database at this stage.
- When the wizard completes, in the Spreadsheet pane, right-click $target and
click Select Data Source.
- In the Select Database as Mapping Source wizard,
select the database that you want to use and click Finish. A $db:select entry appears in the Spreadsheet
pane and the contents of the database table are displayed in the Source pane.
- In order to map the Properties (messageSet, messageType, and messageFormat),
expand the $db:select and for entries in
the Spreadsheet pane.
- Right-click the $target entry that appears below
the for entry and click Populate. This populates the Spreadsheet pane with the top-level elements
from the Target pane.
- Right-click each of these elements and click Populate. Repeat this as many times as necessary for each level of element until
all of the information from the Target pane appears in the Spreadsheet pane.
- Perform mapping as usual.