Modifying a data mapping template

You can add or remove columns from a data mapping template and change the XPath of the columns. You can also correct errors in mapping between the data source elements and the data mapping template columns.

About this task

To modify the properties of the data mapping template columns, you can do so directly in the data mapping template. If you want to add columns to or delete columns from the data mapping template, you need to select an associated data table and refresh the schema.
Note: To find out which data table is associated with the data mapping template you want to modify, locate and double-click the data mapping template in the XML Data Configuration tree. In the Data Mapping Template editor, look at the Data Mapping Tables section.
You might need to update a data mapping template if the schema of the XML resource has changed. When the schema changes, some elements might have been deleted or added and such elements might not have been mapped to the data mapping template. Such unmapped elements get highlighted in red the Data Table editor. You can choose to delete or add the elements, or update their XPath definitions as needed.
Note: You can edit a column definition to remove its association with an XPath. When a column does not have an associated XPath, it is not tied to a specific data source. A data mapping template with such columns can be reused for any generic XML data source.

To modify a data mapping template:

Procedure

  1. In the XML Data Configuration tree, select the data mapping template.
  2. Double-click the data mapping template. The Data Mapping Template editor opens.
  3. Select a data table in the Data Mapping Tables section. Click the Refresh link.
  4. Make the changes, depending on your requirements:
    • To change the properties of any of the columns, select the row that contains the column definition and make the changes.
    • To add a column to the data mapping template, click the related node displayed in the XML tree at the left, click Add and, optionally, change the properties for the column definition.
    • To remove a column from the data mapping template, double-click the row in the display at the left.
    • To update the XPath of a column when a schema tree exists, select the node in the schema tree, select a target column, and click Update XPath. If no schema is associated with the template, right-click either the node or column, and click Update XPath.
  5. To save the changes, click File > Save or click the Save button on the toolbar.

Feedback