Different ways to extract SAP table data

Different ways to extract SAP table data

I need to send data extracted from SAP database tables to an external system like a server. Would it be preferable for JCo to call the BAPI and get an entire extract in one call, or is it possible for SAP to connect to an external system and pass the data? Which option would you choose and why? If the latter is preferred (SAP connecting with external system), how do I go about making it happen?
There

    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.

are numerous technologies available for pushing large volumes of data out of SAP. Certainly an external trigger that calls an RFC/BAPI via JCo is one way to get data out. You can also implement a JCo server that can be called by an ABAP/SAP program to pass data to an external system. If the volumes are truly huge, ALE and IDOC technology is the best for doing asynchronous, batch processing to an outside system. In my upcoming book, I detail the JCo server and how to build Java applications for SAP.

This was first published in April 2003