Implementation of SOAP to JDBC Synchronous scenario

By Leela Ratnam Morampudi, Satyam Computers

Introduction 

 This document will explain you the SOAP to JDBC communication using SAP XI. At sender side SOAP adapter is used and JDBC adapter is used to update the record in the data base table. If the record is updated we can know the response as the record is successfully updated or not.

Here we are going to update the record in the data base table. The company name should be updated based on the Id, which the Soap client provides.

Pre-requisites 

• SQL Server 2000 is the DB Server used in this scenario.

• Data base table Employee with the Id, Name, and Company

• Using the data base name as AccPayDBV2

Integration Repository

 Import the software component.

 Create the namespace. 

Data Types 

 Create 4 data types.

1. SOAP Request ---DT_Sender

2. SOAP Response – DT_Receiver

3. JDBC_Request – DT_Employee

4. JDBC_Response – DT_Employee_response 

Create data type for the SOAP Request 

Create the data type for the soap response

Create data type for the JDBC Request

Create the data type for the JDBC Response

Message Types 

Create the message types for the above data types 

Message type for the SOAP Request

Message type for the SOAP response

Message type for the JDBC Request

Message type for the JDBC Response

Message Interfaces

Create outbound synchronous message interface for the SOAP

Create inbound synchronous message interface for the JDBC

Click here to continue...