Skip to Content
avatar image
Former Member

Data-exchange via IDoc from SAP

Hello everybody,

we want to exchange data from SAP to our existing MySQL/PHP-database application by using IDocs. However,

after several hours of investigations I am still totally confused about the possibilities and methods. So, can anyone please explain me with simple words the options we have and which implementation would be the most promising way?

I have no experience with SAP, so I want to apologize my "stupid" question!

Hope anyone can help me. Thank you in advance

Kai

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

4 Answers

  • Best Answer
    avatar image
    Former Member
    Jan 24, 2008 at 01:30 PM

    Hi,

    One end is ur SAP system then u can use IDOC if u have standard IDOC, U have standard idoc so u can go with IDOC and at receiver end u have MYSQL,then u have to use JDBC adapter.

    i will send some links on JDBC check it.

    JDBC ADAPTER

    http://help.sap.com/saphelp_nw04/helpdata/en/7e/5df96381ec72468a00815dd80f8b63/content.htm

    /people/saravanakumar.kuppusamy2/blog/2005/01/19/rdbms-system-integration-using-xi-30-jdbc-senderreceiver-adapter

    To install oracle drive in XI server, just check these links,

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

    http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/index.html

    http://msdn2.microsoft.com/en-us/library/ms177523.aspx

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

    JDBC Receiver with Oracle Stored Procedures

    configuring jdbc adapter with multiple tables

    RFC -> XI -> JDBC Scenario Updating Multiple Tables

    /people/alessandro.berta/blog/2005/10/04/save-time-with-generalized-jdbc-datatypes

    JDBC Adapter multiple Selects

    https://www.sdn.sap.com/irj/sdn/advancedsearch?query=jdbc%20with%20multiple%20tables&cat=sdn_all

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

    JDBC - http://help.sap.com/saphelp_nw2004s/helpdata/en/64/ce4e886334ec4ea7c2712e11cc567c/content.htm

    multiple tables with JDBC - http://help.sap.com/saphelp_nw04/helpdata/en/2e/96fd3f2d14e869e10000000a155106/content.htm

    JDBC Response /people/swaroopa.vishwanath/blog/2006/12/28/send-rfc-to-sap-xi-150-asynchronous

    JDBC RECEIVER ADAPTER

    /people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

    Regards,

    Phani

    Reward points if Helpful 😊

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2008 at 09:45 AM

    Hi,

    As you told that One End is SAP----For this u can Use IDOC's

    Athoer End is Database----For this u can Use JDBC Adapter

    So Finally your scenario can be IDOC--XI--JDBC Or

    Proxy-XI-JDBC

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2008 at 10:01 AM

    Defianately Go for IDOC to JDBC or JDBC to IDOC scenario.

    For more details on this please follow the following linK;

    IDOC to JDBC Scenario

    Regards.

    Jeet.

    Add comment
    10|10000 characters needed characters exceeded

  • avatar image
    Former Member
    Jan 24, 2008 at 10:05 AM

    Hi,

    You can Look into this BLOG , this says which is the right adapter to choose when we are dealing with SAP

    /people/ravikumar.allampallam/blog/2005/08/14/choose-the-right-adapter-to-integrate-with-sap-systems

    Regards

    Seshagiri

    Add comment
    10|10000 characters needed characters exceeded