XML Transfer Mapping Tool |
|
The XML transfer mapping (XTM) tool allows you to pass XML data to a database using XSL transformations. The XML Transfer mapping tool consists of three parts: an XML schema part, which displays the schema of the XML file(s) that you are using as source data; an SQL database part, which displays the database tables; and an XTM part, which displays the mapping from the XML schema to the database tables.
Using the tool can be summarized in five basic steps: opening a source XML or XSD file to create a source XML schema, connecting to a database, creating an XTM structure from the database table, mapping elements and attributes from the source XML schema, and finally storing the XTM structure as an XSL file.
Once the XSL file is created, it can be used to transform any XML file that conforms to the source schema to database data.