How to: |
After you have a target table available and verified connectivity, use iWay Designer to create and configure a process flow to consume an incoming XML document and map its data nodes to parameter values in a SQL statement.
To create a process flow:
The Designer Project Information dialog box opens, prompting you for a project name and optional description.
In the Description field, type a brief description (optional) to describe the project.
The Designer Project Bindings dialog box opens.
The choice of project association depends on where you intend to publish (deploy) your process flow. If you are developing a process flow for use as part of a channel, you must publish it to the iWay Registry for subsequent deployment.
The new project node (for example, xPathMap) appears under the repository in which it was created (for example, iWay).
The iWay Process Configuration dialog box opens.
In the Description field, type a brief description (optional) for the new process flow.
The new process flow node appears under the Processes folder, and the workspace displays a Start object.
You are ready to configure a process flow by configuring objects and specifying their relationships.
To configure a process flow:
The Start Object dialog box opens.
The New SQL Object dialog box opens.
In the Description field, type a brief description (optional) for the SQL object.
The Data Source URL pane of the SQL Object dialog box opens.
The SQL Statement pane of the SQL Object dialog box opens.
select * from Emp
Note: This sample SQL statement is only a placeholder for demonstration purposes and must be replaced with an actual SQL Insert statement that you prepared and tested.
The Properties pane of the SQL Object dialog box opens.
The new SQL object (x2t_SQL) is added to the workspace, as shown in the following image.
The New End Object dialog box opens.
In the Description field, type a brief description (optional) for the End object.
The End Name Schema pane of the End Object dialog box opens.
The Properties pane of the End Object dialog box opens.
The new End object (x2t_End) is added to the workspace, as shown in the following image.
The Line Configuration dialog box opens.
This option indicates that there are no conditions that affect the path, and that the path between the two objects will always be followed.
A line appears between the x2t_Start and x2t_SQL objects to indicate that a relationship has been established.
The Line Configuration dialog box opens.
This option indicates that there are no conditions that affect the path, and that the path between the two objects will always be followed.
A line appears between the x2t_SQL and x2t_End objects to indicate that a relationship has been established.
The SQL Object dialog box opens.
The XPATH Builder opens, as shown in the following image.
Note: When the XPATH Builder is opened for the first time, you are prompted to load an XML file. Once specified, this XML file will persist when the XPATH Builder is opened in subsequent instances.
To view a copy of the EmpData.xml sample XML document, see Employee XML Document (EmpData.xml).
The Build an XPath pane of the XPATH Builder opens.
Note: Before you click Next, ensure that the XPath field has a path value. XPATH Builder can traverse the document and display information. Select the node that is associated with the property that you want to define.
For example:
The Select Methods pane of the XPATH Builder opens.
The XPATH Validation pane of the XPATH Builder opens.
You are returned to the SQL Object dialog box.
Note:
Once you have added and configured all of the required process flow components, you are ready to publish your process flow to the iWay Registry. To publish a process flow:
The Publishing Process dialog box opens and you can select the server on which, you will be publishing your process flow.
The Process Runtime Options pane of the Publishing Process dialog box opens.
The Publish To pane of the Publishing Process dialog box opens.
The Select Publication Location(s) pane of the Publishing Process dialog box opens.
Ensure that the following message is displayed in the Results tab of iWay Designer, which indicates that your process flow has been successfully published to the iWay Registry.
iWay Software |