Skip to Content

Extracting Data from ERP using bgrfc?

Hi Folks,

question regarding extraction data from ehp7 erp6.0 using ibm datastage 11.5 and sap pack 8.0.0.3. it supports RFC in dialog or batch using qrfc, trfc, bgrfc with qrfc or bgrfc with trfc.

what is the best (performance) option to extract data on a daily basis (~500 tables, ~30GB) from the list above?.

anyone any experience with this topic?

Regards Marc

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    avatar image
    Former Member
    Oct 19, 2017 at 12:12 PM

    Hi Marc,

    Out of the options mentioned I would say that bgRFC without queues will give you the best performance / lowest backend performance impact.

    However, if you are intending to regularly replicate large amounts of data on a table by table basis - and license constraints aside :-) -, I would challenge the list of options and propose to consider trigger-based replication using SAP's SLT or a similar third party technology. A while back, we implemented a proof of concept scenario for a customer in which we replicated data with deltas bigger than your projected volume into a HANA database with very low latency and negligible performance impact to the backend. I'm sure the latency would suffer a little if your target is not an in-memory database but the performance impact should be similarly low.

    Regards,

    Patrick

    Add comment
    10|10000 characters needed characters exceeded