Updated: Jul 26, 2022
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.
Map the filter flow item to ZHT_DEMO. (This also can be created with the object type Template Table from the General tab)
Click on the small green Play button to activate the flow graph and transfer the data from Oracle Virtual Table to SAPHANADB table.
If any errors are present, we get error list on the bottom of the screen, where we can debug.
Now that the data is migrated, we can make a quick check by running below DDL statements to check the record count.
Both the SQL statement return same number of record count.
Now, we have successfully migrated data from Oracle to HANA thru a Flow Graph.