Business Processes and Rules: Siebel eBusiness Application Integration Volume IV > 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. From the application-level menu, choose View > Site Map > Business Process Administration > Workflow Processes.
  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.

    4. 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, Process Instance 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
    Process Instance 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.

    5. Click for full size image

    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.

    6. 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.

    7. 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.

    8. 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.


 Business Processes and Rules: Siebel eBusiness Application Integration Volume IV 
 Published: 18 April 2003