on 01-24-2008 9:43 AM
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
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,
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
101 | |
13 | |
13 | |
11 | |
11 | |
7 | |
6 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.