What is ADBC (ABAP Database Connectivity) in HANA?

ADBC is an API for the Native SQL interface of the AS ABAP that is based on ABAP Objects. With ADBC, we can do the following:   
•Access to entire SQL functionality of underlying DB system
•Dynamic creation and execution of native SQL statements via respective API methods
•Clean concept for multiple DB connections (connections are associated to connection objects)
•Exception handling – API methods have well-defined exceptions that can be handled
•Native SQL can be used via EXEC SQL (and related) statements or the ABAP Objects based ADBC (ABAP Database Connectivity) API.
Class CL_SQL_CONNECTION offers methods like Create, update, insert etc to work with the underlying database.  It is suggested to use ADBC as it works faster than the open SQL.

tags: HANA Connectivity via Secondary database connection, ADBC (ABAP Database Connectivity), Code Pushdown, Accelerating SAP ECC Application
Share this article :

Post a Comment

Copyright © 2011. SAP HANA TUTORIALS FREE - S/4 HANA - All Rights Reserved