Updating an external database from SAP

Updating an external database from SAP

Can you tell me how to find which RFC should be used for specific table update?

    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.

The first step is to build a JCO server, following the examples provided by the JCO API or my book, Enterprise Java for SAP. The JCO server takes import parameters, structures and can execute JDBC code against an external database. This allows you to store data from any source that can execute the JCO server. Inside SAP, you need to build a user exit or scheduled ABAP program that calls an RFC destination, exporting the data you need to save in your external database. When the JCO server is started, it registers itself with the specific RFC destination you created for it. Once registered, any SAP application that can call an RFC destination canm now pass data to your JCO server.

This was first published in August 2004