HANA as a secondary database, what is possible what is not

HANA as a secondary database, what is possible what is not
Rate this post

It has become 4 years since I first met HANA in CodeJam İstanbul January 2014. From that time i have discovered many capabilities of HANA especially when it is located as seconday database. Unfortunately my company have neither upgraded to S4HANA nor position HANA as primary database. Therefore in order to take advantage of HANA , i researched all options that i can make use. Let me order some of the possible/impossible usage scenarios of HANA when it’s an accelerator(secodary database) from an ABAP’ers perspective. I will go into details of each in the following posts.

 

Top-Down Approach

  1. ADBC -> Possible
  2. Native SQL -> Possible
  3. Open SQL with HANA Connection string -> Possible
  4. CDS view with HANA Connection string -> Possible
  5. AMDP -> Not Possible

Buttom-Up Approach

  1. HANA Stored Procedure call with ABAP Procesure Proxy -> Not Possible
  2. HANA View call with ABAP external views -> Not Possible

You may also like

  • SAP HANA as a secondary database (0)
    After SAP has introduced HANA , i could finally had a chance to explore it. As a soft switch to HANA technology , companies can make use of HANA as a second database. Because it will not […]
  • CDS view approach to connect HANA as secondary database (0)
    CDS view approach is maybe the safest approach while connecting to a secondary HANA database. If there is a safer approach it would be using directly OpenSQL. However there are cases where […]
  • ADBC usage with HANA as a secondary database (0)
    "ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. The ADBC methods can be used to pass Native SQL statements to the database interface". It was a […]