ADBC usage with HANA as a secondary database

“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 definition from SAP Help. It is obvious that ADBC can be used ABAP on HANA systems. I think there are very few advantages of ADBC method but on the other hand many disadvantages that demotivates to use.
For instance in my case where HANA is the secondary database, it is even possible to use ADBC API. That seems a big advantage for ADBC, as there are not many alternatives, for example to call a secondary HANA’s prosedure from an ABAP program in a top-down approach. When it comes to disadvantages , the dynamic hardcoded Native SQL statements which are created by ABAP program can cause serious security problems, moreover the worse scenario is SQL injection.
I think safer and more structured option in ADBC method can be using HANA artifacts like HANA stored procedure. Below i will given a sample ABAP program of this option.

 

 

You may also like

  • HANA as a secondary database, what is possible what is not (0)
    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 […]
  • 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 […]
  • uppercase lowercase problem in enterprise services (0)
    Updating enterprise services could be problematical sometimes. I have encountered a different type problem lately. We were entegrating our SAP system with a 3rd party application written […]