Business Processes and Rules: Siebel Enterprise Application Integration > Defining Workflows for Siebel EAI > Sample Integration Workflows >

Import Employee (MQSeries)

This is a sample workflow process that receives an XML string from an IBM MQSeries queue and updates the Employee instance in the Siebel Database.

To review the import Employee (MQSeries) workflow process

1. Navigate to the Administration - Business Process > Workflow Processes view.
2. Query for Import Employee (MQSeries) workflow process.
3. With the Import Employee (MQSeries) process selected, click the Process Properties tab to review its process properties.

   Workflow process properties are global to the entire workflow. For example, as shown in the following table, the Import Employee (MQSeries) workflow has several properties. The Employee Message contains the object as an integration object hierarchy, when converted. The object must be in that format before it can be inserted or updated in the Siebel environment. The Employee XML property defines the MQSeries message as XML recognizable by Siebel applications. The Error Code, Error Message, Object Id, and Siebel Operation Object Id properties are included in each workflow by default.

   Name	Data Type
   Employee Message	Hierarchy	In/Out
   Employee XML	Binary	In/Out
   Error Code	String	In/Out
   Error Message	String	In/Out
   Object Id	String	In/Out
   Siebel Operation Object Id	String	In/Out

4. Click the Process Designer tab in the bottom applet to review the process design for this workflow process.

   NOTE:  When using the MQSeries Receiver, remember the MQ Receiver task will read the message from the queue and pass it into your workflow process in the <Value> field. This means your workflow process does not need to read the message from the MQSeries Queue. To get the XML string that has been read, you need to create a process property and set its default value as follows: Name=MyXMLStringProperty and Default=<Value>. You should use this process property as the input to the EAI XML Converter business service.

5. Double-click the first step after Start to review its method and arguments.

   This step uses the Receive method of the EAI MQSeries Server Transport to get the inbound message from the Employee physical queue named in the Physical Queue Name argument. This step uses the following input arguments.

   Input Arguments	Type	Value
   Physical Queue Name	Literal	Employee
   Queue Manager Name	Literal	Siebel

   As shown in the following table, the output from this step is put into the Employee XML process property with the assumption that the inbound message is already in XML format.

   Property Name	Type	Output Argument
   Employee XML	Output Argument	Message Text

6. Double-click the second step and review its method and arguments.

   This step uses the XML to Property Set method of the EAI XML Converter to convert the inbound message to the Siebel business object format. The step uses the following input argument.

   Input Arguments	Type	Property Name	Property Data Type
   XML Document	Process Property	Employee XML	Binary

   The output from this step is passed in the Employee Message output argument as described in the following table.

   Property Name	Type	Output Argument
   Employee Message	Output Argument	Siebel Message

7. Double-click the third step and review its method and arguments.

   This step uses the EAI Siebel Adapter business service with the Insert or Update method and the following input argument to update the database.

   Input Arguments	Type	Property Name	Property Data Type
   Siebel Message	Process Property	Employee Message	Hierarchy

   The EAI Siebel Adapter checks the Siebel Database for an Employee record that matches the current instance of Employee in the Employee Message property. If an Employee record matching the current instance does not exist in the database, the EAI Siebel Adapter inserts the record into the database; otherwise, it updates the existing record with the instance.