Skip to Content
Technical Articles
Author's profile photo Jayaraj Sathnur Rachachar

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

  1. Right click on src -> New -> Flowgraph .Give name as Vtableflow
  2. 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

Assigned tags

      11 Comments
      You must be Logged on to comment or reply to a post.
      Author's profile photo Ashish Jain
      Ashish Jain

      Thanks Jairaj,step wise Information with Snapshot helped!

      Cheers!

      Author's profile photo Jayaraj Sathnur Rachachar
      Jayaraj Sathnur Rachachar
      Blog Post Author

      Nice to hear that Ashish!

      Author's profile photo Nishanth Kapadia
      Nishanth Kapadia

      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

      Author's profile photo Sunil Sharma
      Sunil Sharma

      You need to use WEB ID dev Workbench `version to access and create temp table.

      Author's profile photo Jayaraj Sathnur Rachachar
      Jayaraj Sathnur Rachachar
      Blog Post Author

      Hi Nishanth,

      Are you asking can we write data to a File using Flowgraph ?

       

      Author's profile photo Nishanth Kapadia
      Nishanth Kapadia

      Yes Jayraj

      Author's profile photo Jayaraj Sathnur Rachachar
      Jayaraj Sathnur Rachachar
      Blog Post Author

      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

      Author's profile photo Ashish Singh
      Ashish Singh

      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

      Author's profile photo Nishanth Kapadia
      Nishanth Kapadia

      Looks like issue with User provided service. Try to create Synonym and see if you can see tables.

       

      Thanks,

      Nishith

      Author's profile photo Vineetha Golli
      Vineetha Golli

      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

      Author's profile photo Jayaraj Sathnur Rachachar
      Jayaraj Sathnur Rachachar
      Blog Post Author

      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.