The JDBC (Java Database Connectivity) adapter enables you to connect database systems to the Integration Server. The adapter converts database content to XML messages and the other way around.
You can read database content with any SQL statement, even stored procedures.
You define a special XML format for content from the Integration Server. This format enables SQL INSERT, UPDATE, SELECT, DELETE, or stored procedure statements to be processed. A message is always processed in exactly one database transaction.
For FAQs about the JDBC adapter, see SAP Note 831162.
The required Java libraries are product-specific and must be obtained from the database vendor.
For more information, see the chapter Providing External Drivers for the JDBC and JMS Adapters (in the SAP NetWeaver Library Function-Oriented View under Process Integration → Configuring Process Integration (PI) After Installation → Integration of Business Systems without Integration Engine → Integration Using the Advanced Adapter Engine).