Data can be transformed from any Jitterbit supported format to XML and vice versa. Before attempting to use an XML as a source or target you need to have a DTD or XSD definition file that represents the XML structure you wish to use uploaded to the Jitterbit server.
If you are working in an operation, you can click the control button to the right of the Transformation field and select Create New, or the transformation wizard appears in its own New Transformation tab in the right pane of the window.
You have three options for loading your XML document. Click on the scenario that describes where your XML document's DTD/XSD file is located:
Once you have completed defining your database target, a tree data structure should appear in the target transformation tree to depict what you have defined.
In mapping to your database target, if you have a multi-table target with parent child relationships and you are inserting data, you should become familiar with using the transformation functions <SQLIDENTITY>
and <SEQUENCE>
.
<SQLIDENTITY>
is used for all target databases that support identity or automatic number generating keys. Once the parent is inserted then the child can inherit the generated number from the parent by mapping this function to the foreign key in the child table.
<SEQUENCE>
performs a similar action and should be used for Oracle.
Now that you have defined the nature of the source and your desired target, you are ready to map the relationship between your source and target at the field, or element, level.