Creating and executing an SAP HANA flowgraph task helps execute an SAP HANA
flowgraph in an SAP HANA System.
Prerequisites
You have created a project.
You have created and activated at least one destination in the same project in
which you are creating the SAP HANA flowgraph task.
The destination has a connection (connection type: SAP HANA SDI) to an SAP HANA
system (system type: SAP HANA).
Context
SAP HANA flowgraph in SAP Data Hub 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 cockpit in a Web browser.
In the System Status section, choose the
Modeling tile.
The cockpit opens the SAP Data Hub Modeling tool in a new tab in the same browser
window.
Create task.
In the navigation pane, right-click the project within which you want
to create the task and choose NewTask.
In the Create Task dialog box, provide a name
for the task.
In the Type dropdown list, select SAP HANA
Flowgraph.
Choose Create.
The tool opens a new editor where you can define your task.
Define the task.
In the Destination value help list, select the required
destination.
The tool populates the value help list with destinations that have connections to an SAP
HANA system. The connection type is, SAP HANA SDI.
In the Description text field, provide a
description for the task.
In the Hana Flowgraph value help list, select the required SAP
HANA flowgraph.
(Optional) Open the SAP HANA flowgraph in the SAP HANA system.
You can open the selected SAP HANA flowgraph in the SAP HANA system to view
or modify the HANA flowgraph. If you want to open the SAP HANA flowgraph in
the system in which it was created, then
In the editor after selecting the HANA flowgraph, choose (Navigate to).
The tool opens the log on screen of SAP HANA system in a new
tab.
Enter the User Name and
Password.
Choose Log On.
You can now view or modify the SAP HANA flowgraph in the system in
which it was created.
(Optional) Edit variable values and table variables.
After you select an SAP HANA flowgraph, the tool displays the variables and
table variables associated with the SAP HANA flowgraph.
If you want to edit the default variable value, in the Variables
section, choose , and provide the
required variable value.
If you want to edit the values for the table variables associated with the SAP HANA
flowgraph, in the Type dropdown list, select a
value type.
Type
Description
Data Set
If you want to use a data set to provide the values for the table variables
associated with the SAP HANA flowgraph. In the
Name dropdown list, select
the required table varaiable and use the
Value field to select the
required data set (connection type SAP HANA SQL).
Database Object
If you want to edit the Schema Name or Table or
View Name of table variables that are
binding to the database object (tables or views)
associated with the SAP HANA flowgraph. In the
Name dropdown list, select
the required table variable and choose to
edit the Schema Name or
Table or View Name.
Save changes.
In the global toolbar, choose Save to save the task.
Activate the task.
After creating a task object, activate the task. Activation is necessary to convert the
design-time object to its equivalent runtime object in the database.
In the global toolbar, choose (Activate) to activate the task.
(Optional) Execute the task.
After creating and activating a task, you can directly execute the task for an
immediate execution.
In the global toolbar, choose (Execute) to execute
the task.
The tool opens a new editor, where you can monitor the status of the
task execution. You can also monitor the status of these task executions
in the SAP Data Hub cockpit (monitoring dashboard).
(Optional) Abort task.
If you want to abort the execution of any task in the task workflow,
On the task node, choose .
Select the Cancel Task menu option.
In the editor toolbar, choose (Finished) to
refresh and view change in the task status.