Workflows to move data into records

You use the workflow capabilities from IBM® TRIRIGA® to move data from the staging tables to the actual business object records. The exact workflow logic depends on your company business rules and the business object that is being filled. Workflows for controlling DataConnect must be created in the triDataConnectJob module.

Use the DataConnect workflow task to retrieve staging records and iterate through the staged entries, creating or updating a smart record for each one. DataConnect workflow tasks can be nested to support parent-child relationships and business logic.

The DataConnect task acts in two parts:
  • Retrieves the set of records to work on from the appropriate staging table as defined by the DataConnect task property settings.
  • Acts as an iterator for the following tasks:
    • Creates or updates a record for each row of data from the staging table.
    • Runs the body of the DataConnect task for each row. Other task steps can be positioned within the body of the DataConnect task.

While inside a DataConnect workflow task, the Review Status of the task is INSERT, UPDATE, or FAILED, based on the current action of the task iteration. Upon exiting a DataConnect workflow task, the Status is Completed or Failed (if any of the staging table rows failed).

Example of a workflow with a DataConnect task

The following example uses a purchase order (PO) and its PO line items for purposes of illustration. First, is the complete workflow.
Figure 1. Workflow that includes DataConnect task
The image is explained in the text.