Skip to Content
avatar image
Former Member

idoc to jdbc

Hi All,

i am working on idoc to jdbc scenario. Anybody have worked on this, Please send the full scenario ( with all details ), based on that i will create my scenario.

Thanks & Regards,

Nagarjuna.

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • avatar image
    Former Member
    Oct 24, 2007 at 05:03 AM

    hi nagarjuna,

    Refer these threads

    idoc-xi-jdbc

    idoc-to-jdbc

    Regards

    Ramesh P

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2007 at 05:07 AM

    Hi

    <b>have a look on these for step via step</b>

    While configuring the JDBC adapter you can give the select statement or update statement to update or select the data from database table.

    <b>For JDBC receiver You can refer to this blog</b>

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

    <b>For JDBC sender you can refer to this blog</b>

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    <b>JDBC receiver</b>

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

    <b>

    JDBC sender</b>

    /people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

    <b>

    IDoc sender</b>

    /people/prateek.shah/blog/2005/06/08/introduction-to-idoc-xi-file-scenario-and-complete-walk-through-for-starters

    more details look

    /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

    Process Integration (PI) & SOA Middleware

    Thanks!!

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Oct 24, 2007 at 05:50 AM

    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-guides/how%20to%20install%20and%20configure%20external%20drivers%20for%20jdbc%20and%20jms%20adapters.pdf

    For the real configurations

    XML SQL Format and Native XML Format

    Regarding JDBC Adapter in SAP XI

    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.

    Add comment
    10|10000 characters needed characters exceeded

  • Oct 24, 2007 at 06:14 AM

    Try this

    /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

    Process Integration (PI) & SOA Middleware

    Add comment
    10|10000 characters needed characters exceeded