1.6.41 DB adapter mapping settings dialog

In the [DB adapter mapping settings] dialog, by specifying the column definition file defined in the mapping contents, the data acquired by DB adapter can be automatically mapped to a format that will change the acquired column names to element names.

The [DB adapter mapping settings] dialog is displayed when in the DB adapter search results, you right click the parent element (complex content element) of the element to be mapped for the transformation destination, and select, [Special mapping] and [DB adapter].

The following figure shows the [DB adapter mapping settings] dialog:

Figure 1-137 Figure [DB adapter mapping settings] dialog

[Figure]

Organization of this subsection
(1) Displayed items
(2) Operations that can be performed in this dialog

(1) Displayed items

[Mapping destination]
The nodes of transformation source schema are listed in the full path from the root of transformation source schema. Select the node to be mapped from among the list.
[Column definition file]
Specify the column definition file that defines the transformation source column numbers and the transformation destination element names that will be mapped. When you click the [Reference] button, a dialog to specify the column definition file is displayed.
[Finish] button
Completes mapping and closes the dialog.
[Cancel] button
Cancels the specified contents and closes the dialog.

(2) Operations that can be performed in this dialog

By specifying the column definition file, the data acquired by DB adapter is automatically mapped to a format that will change the column names to element names. For details about how to create a column definition file and how to map DB adapter, see "Appendix K Auto mapping of data acquired by DB adapter" in "Service Platform Basic Development Guide".