XI idoc-jdbc scenario in details

Hi,

For IDOC to JDBC scenario:

Refer the below weblog for help:

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30 --> for jdbc receiver: file -JDBC

1) First you need to install the JDBC drivers on XI server refer the below link for installation process.

https://www.sdn.sap.com/irj/sdn/go/portal/prtroot/docs/library/uuid/3867a582-0401-0010-6cbf-9644e49f1a10

2) You need to do the IDOC configuration at R3 as well as at Xi end:

Refer the below configuration steps:

ALE configuration for pushing idocs from SAP to XI

/people/swaroopa.vishwanath/blog/2007/01/22/ale-configuration-for-pushing-idocs-from-sap-to-xi

IDOC testing using WE19

/people/sameer.shadab/blog/2005/07/25/reposting-idocs-instead-of-recreating--for-testing-purpose-xi

Pre-requisites for Outbound IDoc from R/3 to PI:

Configurations required in R/3:

Maintain Logical System (SALE)

Define RFC Destination (SM59) which points to PI system

Maintain Port (WE21)

Maintain partner profile. (WE20):

Maintain Distribution Model (BD64):

Configuration required at Xi side:

Go to IDX2: load the DOC metadata.

3) For updating the table you need to write the stored procedure:

Refer the below link for stored prcedure.

JDBC:

Receiver JDBC scenario MS access - /people/sameer.shadab/blog/2005/10/24/connecting-to-ms-access-using-receiver-jdbc-adapter-without-dsn

Stored Procedures-

/people/siva.maranani/blog/2005/05/21/jdbc-stored-procedures

http://www.ics.com/support/docs/dx/1.5/tut6.html

/people/sriram.vasudevan3/blog/2005/02/14/calling-stored-procs-in-maxdb-using-sap-xi

http://www.ics.com/support/docs/dx/1.5/tut6.html

http://java.sun.com/docs/books/tutorial/jdbc/basics/sql.html

http://www.sqlteam.com/article/stored-procedures-an-overview

Thnx

Chirag

Reward points if it helps and close the threads.