How to: |
This section describes how to prepare test data and sample files.
To prepare a database target table to populate with sample data:
To use a predefined sample XML document, employee table definition, and other sample data for this tutorial, see Sample Documents.
To view a sample employee table definition, see Employee Table Data Definition.
Later in this tutorial, you will replace the hard-coded values with parameter names. Be aware of database engine SQL syntax variations for string delimiters, dates, numbers, function calls, and columns that can accept a NULL value.
Note: The sample SQL Insert statement that is provided in Sample Documents may not be syntactically correct for your database.
One method is to define and test a Data Provider from the iSM Administration Console. Driver and URL information defined here can be referenced when creating an SQL Object in later steps.
Since you will be creating several text documents for reference and processing, create a set of folders on the iSM host system to store them.
C:\xml2tbl\in C:\xml2tbl\out C:\xml2tbl\processed
Ensure that the subfolders remain empty.
To view a copy of the EmpData.xml sample XML document, see Employee XML Document (EmpData.xml).
The property names that you define here will be used as parameters with the SQL Insert statement that you previously prepared. A recommended property naming convention is to prefix a lower case 'x' to the node name. This convention associates the property with the node name while distinguishing it. You can use your own naming convention. However, you must ensure that it is consistent.
iWay Software |