How to create SAP HANA Flow Graph

SAP HANA flowgraph helps you to transform the data from remote sources into SAP HANA either in batch or real time.

We are going to use a Virtual Table created on top of Oracle Table and that will be inserted into SAP HANA table.

Steps to create a Flow Graph

• Go to SAP HANA Web Editor

• Select a desired Package in the navigation pane.

• Right Click on the Package and navigate to New >> Flowgraph

• Key a meaningful name to your Flowgraph.

• Once you click on the above create button, you will see the Flowgraph editor as below. On the left side navigation pane you have different object types. And the in the center we have the plot area where we are going to design a demo flowgraph.

• Here we are going to select the object type 'Data Source'. (In this we add a Virtual Table created on top of Oracle remote source)

• ZVT_DEMO is a Virtual Table created on top of Oracle remote source.

• Data source object is pointed to the Virtual Table which has huge amount of data. For demo purpose I would like to apply filter on the dataset.

• Select the 'Filter' object from the General Tab.

• Here you will be able to see all the columns present in the Virtual Table.

• Click and the Expression Editor to write your own expression. To start with we use an 'equal to' filter on Fiscal Period. (Fiscal Period = 2021001)

• Like wise we can apply multiple filter in the expression editor.

• Once we close the expression Filter we get have below screen.

• I have created a similar staging table as that of ZVT_DEMO in schema SAPHANADB as ZHT_DEMO.