XML Transfer Template Tool |
The purpose of the XML Transfer Template (XTT) tool is to provide a customizable bridge between database data and XML documents. The bridge takes the form of a template file, the XML Transfer Template (XTT). The XTT file determines which database tables and columns to map to which XML elements and attributes. You determine the mapping using drag-and-drop operations in the XTT tool. The XTT tool ensures that XTT syntax is correct, and also aids in performing tasks such as generating schema documents (XSD) or document type definitions (DTD).
Using The XTT tool to transform data is a four-phase process – creating or importing the XTT structure, linking XTT objects to the database with SQL queries, generating DTD or XSD files if necessary, and finally generating the XML document.
Usually, linking XTT objects will only be necessary if you are importing an existing XML structure from either an XML file, XSD, or DTD. Likewise, linking will not be necessary if you are creating an XTT based on the database. Hybrid situations may exist, however; for example, where you have an existing XML structure but need to add new elements for new data.
XTT files define a map from database tables and columns to the elements and attributes of an XML file. An XTT file is a document with syntax similar to a valid XML document. Elements define tables and columns, and attributes define SQL queries, attribute names and values, and element values for XML documents generated using the XTT.