Mapping xpath statements to XTM object nodes

How To

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