Mapping xpath statements to XTM object nodes |
After creating a new XTM, the next step is to create a map between the nodes in the XML schema and the database tables. First you will need to add database tables to the XTM object tree, then you will need to add XML schema paths to properly map from the address in the XML schema where the data is located.
To create the structure of the XTM object tree, drag-and-drop tables from the database into the desired location in the XTM object tree. The first node must be dropped onto the root node; subsequent nodes can be dropped into the root node or any other node that represents a table. Tables cannot be dropped into a node representing a column. When you drop a table, it will appear in the XTM column with all of the columns visible.
After the XTM object tree structure is complete, drag-and-drop nodes from the XML schema panel onto the desired node in the XTM object tree. A statement will appear in the xpath column that corresponds to the xpath representation of the element or attribute address in the XML schema. Furthermore, xpath statements will be preceded by a data property if the are numerical or binary data types. A data property statement will not precede character data types. The xpath data property and corresponding data types are summarized in Table
|
Xpath Data Property |
SQL Data Type |
|
Character data |
Char |
|
Varchar |
|
|
Longvarchar |
|
|
Longvarbinary |
|
|
File |
|
|
Nchar |
|
|
Nvarchar |
|
|
Nclob |
|
|
Numerical data |
Serial |
|
Smallint |
|
|
Int |
|
|
Float |
|
|
Double |
|
|
Decimal |
|
|
Normalize-space (binary) data |
Binary |
|
Date |
|
|
Time |
|
|
Timestamp |
Table: xpath data properties and corresponding SQL data types