Skip to Content

ETL in HANA using FlowGraphs or Calculation views

Hi, We are doing data acquisition from several non SAP systems into SAP HANA Database using BO Data Services, then we are modeling data using Calculation views for calculating new fields, transforming the data values, Joins etc, after that, final calculation view is read using SQL and then inserts into other table, you can see it from the below picture,

I am thinking that, what if I replace Creating calculation views for doing the ETL with HANA flowGraph object, so that I can have all the joins, Unions and aggregation logics derived with in Flow Graph object. Is that a feasible approach or should I consider any specific point before going with it, Please let me know.

project-flow.png (9.9 kB)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    May 31, 2017 at 06:44 PM

    Hello Sreekanth,

    in theory your scenario should be achievable through Hana Flowgraphs which can also be scheduled for recurring execution.
    It all depends on the kind of operations that you are currently doing in the Calcviews, that might make the flowgraph a little more complex. But Joins, Aggregations and Unions are available Transformations in the Flowgraph. In addition to that if you connect your datasources through SDI (as virtual table) it could also get the changes from the source system and push it through a Realtime flowgraph, so that your final tables in Hana are always up to date.

    Kind Regards,

    Timo Wagner

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 09, 2017 at 02:10 AM

    That makes sense, so that, I can conclude that, flowGraphs can be used all the ETL activities in HANA. Thank you.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 09, 2017 at 07:16 AM

    Yes, It can be done with the help of flowgraphs instead of creting several calculation views.

    Add comment
    10|10000 characters needed characters exceeded

  • Jun 09, 2017 at 05:26 PM

    Hi Timo and Priyanka, Thank you. I am wondering what is an ideal use case for using ( Calculation views + SQL to read views and insert data into table) approach in a HANA environment. Because I have come across a project recently using it to perform data transformations using this approach, I can call it as ETL and it is suggested by SAP, I am trying to figure out what can be an appropriate reason for it. Because, in this Project, BODS is in place, which can do complex transformations and loading activities. Even HANA flowgraphs can be in use for ETL to optimize HANA database performance. So what other best use case can be there, to go with approach provided the above ETL applications in place? Please let me know, Thanks again for your inputs.

    Add comment
    10|10000 characters needed characters exceeded

    • One use case might be that the calc views can be used/consumed from other tools while not all BI tools are connecting to tables. Calc views with builtin aggregations allow easy slicing and dicing from those tools. For tables you might have to add another layer of calcviews to get them consumed in some reporting tools.