Modeling Guide

Working with the Data Workflow Operators

SAP Data Hub Modeler categorizes certain operators as Data Workflow operators, which when executed runs for a limited period of time and finishes with the status either as completed or dead.

The graphs modeled with the data workflow operators are referred to as Data Workflows. The operators in a data workflow communicate with messages transferred at its input and output ports. All data workflow operators have an input, an output, and an error port. Thus, the operator begins execution only when it receives such a message at its input port. The execution of other connected operators in the data workflow begins only after the previous operator has finished its execution.

For example, the following graph includes the data workflow operators, Workflow Trigger, SAP BW Process Chain, SAP HANA Flowgraph, and Workflow Terminator.

In this example, the Workflow Trigger operator sends a start execution message to the SAP BW Process Chain operator. Only after the SAP BW Process Chain operator is executed, the modeler will execute the SAP HANA Flowgraph operator.

Data Workflow Operators

In the SAP Data Hub Modeler, you can access the data workflow operators in the Operators pane under the Data Workflows category. The modeler supports the following data workflow operators.

NoteThe following image contains links to more information.
Transfers data from an SAP BW system into an SAP Vora table. Executes an SAP BW process chain in a remote SAP BW system. Provides wide variety of options for data transformation. Executes an SAP HANA flowgraph in a remote SAP HANA system. Combines the output from two data workflow operators in a "logical AND". Combines the output from two data workflow operators in a "logical OR". Duplicates the incoming signal from a data workflow operator. Terminates the current data workflow. Sends a start message to trigger the execution of a data workflow. Executes an SAP Data Hub Modeler graph on either a remote or the local system. Executes an SAP Data Services Job in a remote SAP Data Services system. Use the Notification operator in the SAP Data Hub Modeler to send e-mail notifications to users at certain points during the data workflow execution
Supported Data Workflow Operators

Operator

Description

SAP BW Process Chain

Executes an SAP BW process chain in a remote SAP BW system.

SAP HANA Flowgraph

Executes an SAP HANA flowgraph in a remote SAP HANA system.

Workflow Merge (AND)

Combines the output from two data workflow operators in a "logical AND".

Workflow Merge (OR)

Combines the output from two data workflow operators in a "logical OR".

Data Transform

Provides variety of options for data transformation.

Notification

Sends email notifications.

Workflow Split

Duplicates the incoming signal from a data workflow operator.

Workflow Trigger

Sends a start message to trigger the execution of a data workflow.

Workflow Terminator

Terminates the current data workflow.

Pipeline

Executes an SAP Data Hub Modeler graph on either a remote or the local system.

Data Transfer

Transfers data from an SAP BW system into an SAP Vora table or other major cloud storages.

SAP Data Services Job

Executes an SAP Data Services Job in a remote SAP Data Services system.

Modeling Data Workflows

Model data workflows with a Workflow Trigger operator to send the start execution message to the connected operator. You can use the Workflow Terminator operator to shut down the data workflow. This means that, for a given data workflow operator, connect it to the Workflow Trigger or Workflow Terminator operator in case it is the first or last operator that you want to be executed in a data workflow.

If you are using operators to perform actions in remote systems, then it is necessary to first create a connection to the remote system using the SAP Data Management application. For more information on how to create a connection, see Create a Connection in the Related Information section.

Execution Logic and Data Workflow Status

The operators within a data workflow start their execution once it receives such a message at its input port. After executing, each data workflow operator sends a message to the connected operator via its output port if it successfully finished its execution (or via the error port if the execution results in an error).

If the port to which the message is being sent is connected to another operator, the operator that receives the message begins the execution. If the port to which the message is being sent is not connected to another operator, the overall execution of the data workflow stops with the status of the execution as dead.

Importing Certificates for Remote Systems

For operators that leverage HTTPS as the underlying transport protocol (using TLS transport encryption), the certificate of the upstream system needs to be trusted. To import a certificate into the trust chain, obtain the certificates from the target endpoint and import it into the folder, ca in the repository. You can import using the SAP Data Hub Connection Management appication. The next execution of the graph involving the HTTPS connection will automatically pick up any certificate that is present in the folder. For more information on how to create a connection, see Manage Certificates in the Related Information section.