Skip to Content
author's profile photo Former Member
Former Member

How to design an IDOC-XI-JDBC interface

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

Add a comment
10|10000 characters needed characters exceeded

Assigned Tags

Related questions

4 Answers

  • Best Answer
    author's profile photo Former Member
    Former Member
    Posted on Dec 04, 2007 at 09:50 PM

    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

    Add a comment
    10|10000 characters needed characters exceeded

  • Posted on Dec 04, 2007 at 09:57 PM

    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

    idoc-triggering-from-a-transaction

    Message Mapping - JDBC to IDoc

    jdbc---systemapplication-acknowledgement

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

    Regards

    Agasthuri Doss

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 04:39 AM

    Hi,

    You can see :

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

    Vishal

    Add a comment
    10|10000 characters needed characters exceeded

  • author's profile photo Former Member
    Former Member
    Posted on Dec 05, 2007 at 04:48 AM

    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.

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.