Create a Wrapper Process Flow

Introduction:

This post describes how a Wrapper Process Flow is created in OWB.

A Wrapper Process Flow wraps a single Mapping and fulfills the following requirements:

• Allow the Mapping to be executed in stand-alone mode.
• Report any Error and Warning return statuses.
• Is itself wrapped by higher Process Flows in more complex dependency relationships.

Aim:

Create a Wrapper Process Flow.

Requirements:

The Mapping to be wrapped exists.

Procedure:

• Log on to OWB.
• Open a project.
• Expand 'Process Flows'.
• Create a Process Flow.
• Create the following flow:

• Component Configuration:
• START:
• One parameter for each MAPPING input parameter.
• P_SMTP_SERVER (STRING).
• P_PORT (INTEGER)
• P_FROM_ADDRESS (STRING)
• P_TO_ADDRESS (STRING)
• MAPPING:
• Bind the input parameters to the START parameters.
• EMAIL activities:
• Bind the following parameters to the START parameters:
• SMTP_SERVER
• PORT
• FROM_ADDRESS
• TO_ADDRESS
• Subject: [mapping name] has issued a(n) warning / error.
• Message Body: Same as Subject.