Use the HANA flowgraph operator in the SAP Data Hub
Modeler application 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 a 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 represent a complete data flow. You must select the
required SAP HANA flowgraph, and all the operations that the flowgraph must perform are
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 application 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.
In the navigation pane, choose the Operators
tab.
In the search bar, search for the HANA Flowgraph operator.
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.
In the graph editor, double-click the HANA Flowgraph
operator.
In the Connection text field, enter the required connection
ID.
You can also browse and select the required connection.
In the SAP HANA Flowgraph field, browse and select the required
SAP HANA flowgraph.
(Optional) In the Retry Interval text field, enter the time
interval in seconds for the engine to wait until the next status
update.
The default value is 20 seconds.
(Optional) In the Retry Attempts text field, enter the maximum
number of attempts to query for the status update.
The default value is ten attempts.
(Optional) Edit variables.
After you select an SAP HANA flowgraph, in the Variable section,
the application displays the variables associated with the SAP HANA flowgraph,
its data type, and default value. You can edit the default value of a
variable.
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 application 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.
In the Table Variables section, under the
Name column, enter (or select) the name of
the table variable.
In the Value text field, choose and provide the required variable value.
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.
You can control the start and stop of the graph execution using the Workflow Trigger and
Workflow Terminator operators respectively.