Integrating Business Systems by Using the JDBC Adapter  

The following documentation describes an integration scenario in which the business system, which is connected to the Integration Server by means of the JDBC adapter, takes on the role of either a sender system or a receiver system, or both.

Use

Many external or legacy systems cannot exchange data by means of messages and http. Using the JDBC adapter you can access data from such systems at database level. For information about configuring the JDBC adapter, see: JDBC Adapter

Description

An external or legacy system (a database) is connected to the Integration Engine by means of the JDBC adapter. The JDBC adapter uses JDBC to access the database. It reads the database content, converts it into a message, and then sends this message to the Integration Engine where it is processed further.

To forward a message to an external receiver system, the JDBC adapter receives the message from the Integration Engine, converts it into database content and then writes this content to the database of the external receiver system.

Example

Data from a legacy system needs to be read and made available to other systems in the form of messages on a regular basis. The JDBC adapter reads the data from the database of the legacy system, creates a message, and then sends this message to the Integration Server.