Configuring the JDBC Adapter in the Integration Directory/PCK 

Use

The JDBC (Java Database Connectivity) adapter enables you to connect database systems to the Integration Server or the PCK. 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 or the PCK. 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.

Prerequisites

●      To be able to use the JDBC adapter you must have installed the JDBC driver for the database that you want to connect to.

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.

See: Providing External Drivers for the JDBC and JMS Adapters

Procedure

...

       1.      Create a Communication Channel in the Integration directory or in the PCK.

See: Communication Channel in Integration Directory and in PCK

       2.      To configure the adapter, select the Parameters tab page.

       3.      Select JDBC as the Adapter Type.

Defining the Direction of the Adapter

       4.      Specify the Direction (Sender/Receiver) of the adapter.

Configuring the Sender JDBC Adapter

Configuring the Receiver JDBC Adapter