Retrieving data from and external database in ABAP

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?

    Requires Free Membership to View

    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

    By submitting your registration information to SearchSAP.com you agree to receive email communications from TechTarget and TechTarget partners. We encourage you to read our Privacy Policy which contains important disclosures about how we collect and use your registration and other information. If you reside outside of the United States, by submitting this registration information you consent to having your personal data transferred to and processed in the United States. Your use of SearchSAP.com is governed by our Terms of Use. You may contact us at webmaster@TechTarget.com.

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.

This was first published in May 2003