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 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.
Dig Deeper on SAP data management
Related Q&A from Austin Sincock
Explaining the difference between BAPIs and RFCs, how to find BAPIs in SAP and how to determine errors made from BAPI/RFC calls Continue Reading
Is there a way to view a list of SAP interfaces such as RFC, BAPI and ALE? Continue Reading
Retrieving a list of parameters for a specific remote function module using JCo connector. Continue Reading