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) sample workflow process
Navigate to Administration - Business Process, then Workflow Processes.
Query for Import Employee (MQSeries).
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 the 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
Click the Process Designer tab in the lower applet to review the process design for this workflow process.
Note: When using the MQSeries Receiver, remember that 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.Double-click the Receive step 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
Double-click the Convert to Internal step to 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
Double-click the Update Employee step to 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.