Modeling Guide for SAP Data Hub

Execute an SAP HANA Flowgraph Operator

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

  1. Start the SAP Data Hub Modeler.
  2. In the navigation pane, select the Graphs tab.
  3. 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.
  4. 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.
  5. 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 the 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 the status update.
      The default value is ten attempts.
  6. (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.
    1. If you want to edit the default variable value, in the Variables section, choose , and provide the required variable value.
  7. (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.
    1. In the Table Variables section, 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).
  8. 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.