Skip to Content
avatar image
Former Member

HANA DI (HDI) and its Impact

Hello All,

With HANA SPS 11 and 12 SAP Introduced XSA and with it the concept of container(HDI). I am trying wrap my head around this concept and what it means HANA Modeling in future.
I believe there are customers who are using HANA primarily as Data warehouse solution where in we define schemas, design tables using HDBDD, then use different data provisioning tools to populate these tables, build views,secure views using analytical privileges (attribute,analytical and calculation views) and finally consume these views in BI Reporting tools like BOBJ,Qlikview,Tableau.

I would like to understand will SAP continue to support this current(above) modeling approach or we need to follow the new modeling approach of using HDI containers even though we don't intend to us any of XS/XSA features.

I would really appreciate some clarity regarding this.

Thanks,

Shivkumar

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Oct 11, 2016 at 06:55 PM

    HDI is not restricted to XS/XSA. Its many benefits are also extended to database level development as well.

    As far as if you can continue to develop the old way - the answer is not for too much longer. The HANA repository will go away and artifacts like HDBDD must be switched over to HDI. So essentially the design time abstraction artifacts are tied to HDI.

    If you wish to continue to use schemas directly, you can still use SQL and DDL directly to define those objects. But you give up many of the lifecycle management advantages that HDI (like the repository before it) could provide. And of course if you plan to use Calculation Views, they are always design time based and must be moved to HDI at some point.

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hello Thomas,

      Thank you for taking time to clarify things.
      I have few follow up questions (that I am asking purely from HANA as data warehousing solution perspective)

      How soon will HANA Repository go away?

      Security :
      Today we use analytical privileges/roles to secure the data and views.How will this change in HDI world?

      Authentication :
      Today we have AD users tied to their individual HANA database users via SAML SSO. Will this change in HDI world ?

      What does this mean to reporting tools (BOBJ , Tableau , Qlikview) that connect to HANA via _SYS_BIC ?


  • avatar image
    Former Member
    Oct 13, 2016 at 01:48 PM

    Hello Thomas,

    Thanks for taking time and responding to my question. I have few follow up questions (I am asking purely from HANA as data warehousing platform perspective)

    1) How long will be the HANA Repository supported ?

    2) Today we use analytical privileges/roles to secure data and HANA views. Will this change in HDI world and how ?

    3) Today user authenticate against HANA via their HANA database users (we use SAML and kerberos SSO where in the AD accounts are tied to their respective database users ). Will this change in HDI world and how ?

    4) What does this mean to reporting tools like (BOBJ , Qlikview , Tableau)? Today most of the tools have native connectivity to HANA and look for HANA Views under _SYS_BIC schema. Will this change in HDI world and how ?

    I am really curious to understand how this architecture change (HDI) will impact HANA Modeling in future. Especially for customers who use HANA as data warehousing solution ?

    Add comment
    10|10000 characters needed characters exceeded