Data-exchange via IDoc from SAP

[Former Member]

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

[Former Member · Accepted solution]

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-964...

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

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

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

[Former Member]

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

[Jitendra_Jeswan]

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

For more details on this please follow the following linK;

Regards.

Jeet.

[Former Member]

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