With the EXEC SQL command, developers can execute database-specific SQL statements that are not covered by the Open SQL functionality and access database tables that are not managed by the ABAP Dictionary. However, it does have some limitations, because it supports only static SQL statements, provides limited error handling capabilities, and has difficulty dealing with multiple database connections. Developed as an amendment to EXEC SQL, ABAP Database Connectivity (ADBC) is an object-based call-level API that addresses these limitations and provides Native SQL access to all of the SQL functionality of the underlying database. This article introduces you to ADBC and the scenarios to which it is best suited.
Thomas Raupp
Thomas Raupp studied computer sciences at the University of Karslruhe, Germany. After receiving his degree in 1985, he worked for the Research Centre of Computer Sciences (FZI) in Karlsruhe focusing on object-oriented databases. He joined the R/3 technology department at SAP in 1990, where he became Development Manager of the Database Interface Group in 1996 and was responsible for the SAP R/3 database interface and the Oracle port of SAP R/3. Recently, Thomas moved from SAP NetWeaver development to the Global Service and Support organization and is now the Development Manager for the IMS (Installed Base Maintenance & Support) ABAP Group.
You may contact the author at thomas.raupp@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.

Tobias Wenner
Tobias Wenner has a degree in Computer Science from the University of Karlsruhe, Germany. He joined SAP in 1994, lending his skills to data dictionary and database interface development, both in the ABAP and Java stack of SAP NetWeaver. Tobias is responsible for the design and implementation of Open SQL as well as Native SQL in the ABAP compiler and interpreter.
You may contact the author at tobias.wenner@sap.com.
If you have comments about this article or publication, or would like to submit an article idea, please contact the editor.