‎2006 Aug 24 4:57 PM
Hi All,
Currently this is what I have:
ABAP program uses OPEN SQL of course collect information from SAP database, then using NATIVE SQL goes thru DBCON to transfer information directly to another application (Non SAP system) database (not SAP database).
I just dont like this idea anymore since I was reading about the Java Connector.
So what I want to do is...Not sure feasible this is where I need your help on:
Remove all my NATIVE SQL statements, use JCo and rewrite those statements in Java language and communicate to the Non SAP application thru their API (their API is also Java base)
Will reward points.
Tim
‎2006 Aug 24 5:00 PM
HI Tim,
Check out this link it has some useful information on this ...
http://www.sapdevelopment.co.uk/java/jco/bapi_jco.pdf
http://www.sapgenie.com/interfaces/javaconnector.htm
http://www.thespot4sap.com/Articles/SAP_Netweaver_Java_Connector.asp
Regards,
Santosh
Message was edited by: Santosh Kumar P
‎2006 Aug 24 5:00 PM
HI Tim,
Check out this link it has some useful information on this ...
http://www.sapdevelopment.co.uk/java/jco/bapi_jco.pdf
http://www.sapgenie.com/interfaces/javaconnector.htm
http://www.thespot4sap.com/Articles/SAP_Netweaver_Java_Connector.asp
Regards,
Santosh
Message was edited by: Santosh Kumar P
‎2006 Aug 24 5:31 PM
Thanks Santosh.
The PDF document was helpful. I will have to review it more details.
Where do I replace those Native SQL statements to? inside the Servlet Program?
‎2006 Aug 24 5:36 PM
hi,
you will find more info on.
http://www.sapgenie.com/faq/jco.htm
http://help.sap.com/saphelp_nw04/helpdata/en/47/80f671ee6e4b41b63c0fe46bd6e4f8/content.htm
http://www.sapdevelopment.co.uk/java/jco/bapi_jco.pdf
http://searchsap.techtarget.com/tip/1,289483,sid21_gci854012,00.html
http://www.sap.info/public/INT/int/glossary/int/glossaryletter/Word-64134159551ecde70_glossary/S
for installing JCO zip file...
http://help.sap.com/saphelp_nw04/helpdata/en/47/80f671ee6e4b41b63c0fe46bd6e4f8/content.htm
You simply have to have a connection with SAP system and then you can call BAPI with which you can read / update the data in the SAP system.
Hope this info proves useful.
Regards,
Richa.
‎2006 Aug 24 6:10 PM