Creating a data mapping template

Create data mapping templates for mapping XML elements to relational table columns.
Before you begin
You cannot create a data mapping template directly. To create a data mapping template, you must use a data table associated with a resource.
About this task
To create a data mapping template:
  1. Click File > New > Data Mapping Template.
  2. Select the template folder under which you want to create the new data mapping template and click Next.
  3. Select the data mapping table with which you want to associate the new data mapping template and click Next.
  4. To create a new data mapping template or to base a new template on another data mapping mapping template, do one of these steps:
    • To create a new data mapping template, select Create a new template.
    • To base a template on another data mapping template and initialize the new data mapping template with the column definitions of the selected template, click Create a new template based on existing template and select a data mapping template. You can change the new template according to your requirements.
  5. Type a name and description and click Next. The name cannot contain any special characters and must be unique within an XML data configuration file. The description is optional.
  6. Define the table columns:
    • If the resource is associated with an XML schema, in the resource tree at the left, double-click the XML nodes to define as a table column. The nodes, with the XPaths and attributes, are added to the data mapping template displayed at the right. The table column properties are generated automatically. You can modify the generated properties.
    • o If the resource is not associated with an XML schema, to add a column click Add, specify an XPath location path or expression in the XPath column cell, and specify the properties of the mapped relational table column.
      Note: You can create a valid table column without associating it 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.
  7. Click Finish.

Feedback