Take Full Advantage of the SQL Functionality of Your Database with ABAP Database Connectivity (ADBC)

  • by Thomas Raupp, Development Manager, SAP AG
  • Tobias Wenner, Senior Developer, SAP AG
  • September 15, 2007
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.

See more by this author

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.

See more by this author


Comments

No comments have been submitted on this article. 


Please log in to post a comment.

To learn more about subscription access to premium content, click here.