Mapper

A Mapper defines how data is mapped between the Repository and the XML document.

mapper

When you double-click on the Mapper icon on the Data Pipe, the Workbench displays the Mapper dialog.

Mapper Dialogue

The scroll pane on the left of the dialog lists all tables in the Data Tank, plus User Defined Functions. The columns available in the selected table are listed in the pane below the scroll pane. If User Defined Functions is selected, the list includes available User Defined Functions. Any object listed in this pane can be dragged into a cell in the Backend column of the Mapper.

The pane on the right lists the the elements and attributes of the DTD. You can drag these objects into cells in the XML column of the Mapper.

You can also map by selecting an object in each pane and clicking the [Add] button.

The [Clear] and [Remove] buttons delete a selected mapping.

If the listing of the table and the DTD match closely, click the [Guess] button to generate mappings automatically.

The Return empty XML checkbox specifies whether to return an empty XML document if no data can be found in the Repository matching the selection criteria defined in the Selector. If the box is checked, an empty XML document will be returned. If the box is unchecked, no document will be returned.