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