How to design an IDOC-XI-JDBC interface

[Former Member]

Hello Experts!

I'm looking for some guidance on how to design an interface where R/3 is sending an IDOC to XI (via IDOC Adapter Receiver), then XI transforms this data into a JDBC database INSERT action.

I want to make to make the JDBC request a SYNC interface so that I can capture the number of rows inserted into the database and do some appropriate action when the insert count returns a zero value.

Since the IDOC to XI interface is ASYNC, how do I design my link so I can redirect the JDBC response out to a different adapter?

Thanks for your help!

XI Rookie

[Former Member · Accepted solution]

use BPM

search for File to RFC scenario in blogs section on SDN,it explains a async to sync scenario and explains about BPM

basically you would have a IDOC to JDBC scenario

Thanx

Aamir

Message was edited by:

Aamir Suhail

[Former Member]

hi hernando,

u can do it using an asynch/synch bridge in BPM. this bridge design will help u take msg from an asynch interface and transfer this as request to synch, take response from it and further transfer it to an asynch interface.

refer this blog

/people/arpit.seth/blog/2005/06/27/rfc-scenario-using-bpm--starter-kit

while u get the response message from synch interface, u can handle it according to BPM design (like checking for number of rows affected etc)

[reward if helpful]

regards,

latika.

[Former Member]

Hi,

You can see :

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

Vishal

[agasthuri_doss]

Hi,

This will help you

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

/people/laxman.molugu/blog/2006/08/13/integration-with-databases-made-easy-150-part-1

/people/michal.krawczyk2/blog/2005/09/01/xi-idoc-adapter--edidc40--demystified

Regards

Agasthuri Doss