Technical Articles
Part 3 : Creating Flowgraph to load Virtual table data to HANA Table in WEB IDE
In Continuation to Part 1, and Part 2 ,we have now arrived at the last part of this blog where in,
this Part 3 : we will be creating Flowgraph to load Virtual table data to HANA Table in WEB IDE
Creating Flow graph for the Part 2 Virtual table
- Right click on src -> New -> Flowgraph .Give name as Vtableflow
- Drag and drop the node “Data Source”
In the Data source settings , select the Object Name as vtable (Virtual table created above ) and click on Apply
3. Drag and drop the node “Data Target”
In the Data Target settings , select Template Table and give Object Name as testtemptarget and choose key as given below and click on Apply
4. Final Flow graph will look as below
5. Select the src and build it
6. Now , data is in vtable but it is not loaded to testtemptarget table.
For this to happen , we can either follow any one of the following.
- Open the flowgraph file and click on Execute
OR
- Go to Database Explorer and find the container in which we created the flowgraph and call the procedure which gets automatically created when we create the Flowgraph
So , now we have successfully loaded the data from Flat File Remote Source into HANA Tables via Virtual Table in HANA 2.0 using WEB IDE .
I hope these posts were useful and enjoyable to you.
— Jairaj
Thanks Jairaj,step wise Information with Snapshot helped!
Cheers!
Nice to hear that Ashish!
Hi Jayraj,
Nice blog, I don't see option to create File as a Target in flowgraph, do you know if there is an option?
Thanks,
Nish
You need to use WEB ID dev Workbench `version to access and create temp table.
Hi Nishanth,
Are you asking can we write data to a File using Flowgraph ?
Yes Jayraj
Hi Nishanth,
Currenty the target for Flowgraph is a HANA table (which you have already created) or it can be a Temporary Table (which the system will create on the fly.).
We cant write the output to File using a Flowgraph.
Thanks
Jayaraj
Hi Jayraj,
Thanks for the great post. We are creating the flowgraph for importing data from a FileAdapter.
We could create the Virtual table following the previous blog post 2. However, when creating the Flowgraph, the Virtual table object doesn’t show up for a Data Source. I have described it in detail as a question here.
Any insights?
Thanks
Looks like issue with User provided service. Try to create Synonym and see if you can see tables.
Thanks,
Nishith
Hi Jayaraj,
I tried to create Flowgraph but the data is not updating automatically from source table to target table.
Please suggest on this.
Regards,
Vineetha
Hi Vineetha,
You have to run Flowgraph manually or you have to automate the execution of Flowgraph whenever new data comes into your source table.