Execute an SAP HANA Flowgraph Operator

Use the HANA flowgraph operator in the SAP Data Hub Modeler tool to execute an SAP HANA flowgraph in an SAP HANA system.

Prerequisites

You have created a connection to an SAP HANA system using the SAP Data Hub Connection Management application.

Context

Executing an HANA flowgraph operator within a graph helps you to transform data from a remote source into SAP HANA either in batch or real-time mode. The flowgraphs are predefined in the server and represents a complete data flow. User must select the required SAP HANA flowgraph, and all the operations that the flowgraph must perform is defined in the server.

Procedure

Start the SAP Data Hub Modeler.
In the navigation pane, select the Graphs tab.
In the navigation pane toolbar, choose + (Create Graph).
The tool opens an empty graph editor in the same window, where you can define your graph.
Select the operator.
A graph can contain a single operator or a network of operators based on the business requirement.
1. In the navigation pane, choose the Operators tab.
2. In the search bar, search for the HANA Flowgraph operator.
3. In the search results, double-click the HANA Flowgraph operator (or drag and drop it to the graph editor) to add it as a process in the graph execution.
Configure the operator.
1. In the graph editor, double-click the HANA Flowgraph operator.
2. In the Connection text field, enter the required connection ID.
  You can also browse and select the required connection.
3. In the SAP HANA Flowgraph field, browse and select the required SAP HANA flowgraph.
4. (Optional) In the Retry Interval text field, enter the time interval in seconds for the engine to wait until next status update.
  The default value is 20 seconds.
5. (Optional) In the Retry Attempts text field, enter the maximum number of attempts to query for status update.
  The default value is 10 attempts.
Note The operator execution fails and a message is sent to the error output port after <Retry_Interval> * <Retry_Attempts> seconds. This means that, a status update has been requested for the number of times set in Retry Attempts and the SAP HANA flowgraph has not been executed (or executed with error).
(Optional) Edit variables.
After you select an SAP HANA flowgraph, in the Variable section, the tool displays the variables associated with the SAP HANA flowgraph, its data type, and default value. You can edit the default value of a variable.
1. If you want to edit the default variable value, in the Variables section, choose , and provide the required variable value.
(Optional) Edit table variables.
In the Table Variables section, the tool displays the tables variables associated with the SAP HANA flowgraph, its data type, and default value. You can edit the default value of a table variable or define new table variables.
1. In the Table Variablessection, under the Name column, enter (or select) the name of the table variable.
2. In the Value text field, choose and provide the required variable value.
3. If you want to define a new table variable for the selected SAP HANA flowgraph, in the Table Variables section, choose + (Add New).
Save and execute the graph.
Use the Workflow Trigger and Workflow Terminator operators in the graph to control the start and stop of the graph execution respectively.
Tip You can also schedule the graph execution. For more information, see Schedule Graph Executions.