Show TOC

 Configuring the JDBC AdapterLocate this document in the navigation structure

Use

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.

Note

For FAQs about the JDBC adapter, see SAP Note 831162.

Prerequisites
  • To be able to use the JDBC adapter, you must have installed the JDBC driver for the database to which you want to connect.

    The required Java libraries are product-specific and must be obtained from the database vendor.

  • Deploy the Java libraries in AS Java following installation so that the JDBC adapter can find the required Java classes at runtime.

    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).

Procedure
  1. Create a Communication Channel in the Integration Directory.
  2. To configure the adapter, select the Parameters tab page.
  3. Select JDBC as the Adapter Type.
  4. Specify the Direction (Sender/Receiver) of the adapter.

    Configuring the Sender JDBC Adapter

    Configuring the Receiver JDBC Adapter