Retrieving data from and external database in ABAP
How can we get external database data (SQLserver, MS Access) from ABAPs? Can we use RFCs or BAPIs?
When you register, you will start receiving targeted emails from my award-winning team of editorial writers. Our goal is to keep you informed on the hottest topics and biggest challenges faced by SAP professionals today.
Hannah Smalltree, Editorial Director
There are several ways to do this, however I will point you to the Java technique. The JCo API comes with an implementation of an RFC server. This server allows you to register a Java object as an external program in an RFC destination. Your ABAP program can use this RFC destination like any other call function routine to retrieve data from an external datastore. See my tip on the JCo RFC server at SearchSAP.com.
Dig Deeper
-
People who read this also read...
This was first published in May 2003