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

 

Please send us your feedback/suggestions at webmaster@SAPTechnical.COM 

HomeContribute About Us Privacy Terms Of Use • Disclaimer • SafeCompanies: Advertise on SAPTechnical.COM | Post JobContact Us  

Graphic Design by Round the Bend Wizards

footer image footer image