There are three different types of workflows: batch, real-time and tasks. Each have a slightly different execution behavior, but their modeling and configuration structure is the same.

Batch Workflow

Batch workflows are used to collect process and distribute file-based data, also referred to as an offline model. These workflows can be configured for multi-threaded execution, enforcing a first-in-first-out processing order, and a strict transaction boundary based on each batch processed. Batch workflows are transaction safe as data processing can be rolled back and reprocessed if required.

Batch workflow example

Real-Time Workflow

Real-time workflows enable online processing of requests/answers with other systems. These workflows enable execution of large numbers of independent execution paths simultaneously using a multi-threading execution model.  

Real-time workflow example

Task Workflow

Task workflows are used to execute common activities such as cleanup or maintenance tasks. A number of System Tasks are pre-configured in MediationZone and can be complemented with any user-defined activity. Shell scripts and SQL scripts can be scheduled and executed through Task Workflows, using one of the following agents:

• SQL Agent – Takes a database profile and an SQL statement to be executed as parameters

• Script – Takes the name of the shell script and optional parameters to be passed as input to the script

Executing an SQL script using an SQL agent or Script agent in a Task workflow