Please give me the steps for IDOC to JDBC

[Former Member]

Hi Experts,

Please provide me with the Step by Step procedure for IDOC to JDBC scenario.

Thanks & Regards,

Kish.

[Former Member · Accepted solution]

HI,

Just check this doucment on what is to be done,

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/docs/library/uuid/cdded790-0201-0010-6db8-beb...

For JDBC you need to first deployee the JDBC driver on XI.

Thanks and Regards,

Chirag Gohil.

[Former Member]

Hi

I have done IDoc to JDBC using a Purchase Order IDoc.Its done like a normal scenario.

1) Get the IDoc into the XI system by doing the ALE Configuration as you do in case of IDoc to File Scenario.

https://www.sdn.sap.com/irj/sdn/wiki?path=/display/xi/sapR3%28Idocs%29ToXI--Steps+Summarized&

2)Do not create Sender CC for IDoc and no Sender Agreement also.

3)For JDBC Adapter you need to deploy the particular driver, in order to enable XI talk to your DB

Also have a look at the following to install these driver in XI

https://www.sdn.sap.com/irj/servlet/prt/portal/prtroot/com.sap.km.cm.docs/library/xi/xi-how-to-guide...

For the real configurations

XML SQL Format and Native XML Format

FILE to JDBC Adapter using SAP XI 3.0

/people/sap.user72/blog/2005/06/01/file-to-jdbc-adapter-using-sap-xi-30

Configuring the Receiver JDBC Adapter

http://help.sap.com/saphelp_nw04/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

These are the basic required for any scenario with JDBC Adapter.

Be sure about the Receiver structure because JDBC Adpter requires a special structure as i have mentioned above.

4)Once the JDBC Reciever CC is done, finish the scenario like a normal one.

Rest if you have any scenario specific queries let me know..

Thanks.

[Former Member]

hi kish,

refer this:

/people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters --> For Idoc sender: IDOC -file

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

you can refer these two blogs to configure ur IDOC sender and JDBC receiver

[reward if helpful]

regards,

latika.