Skip to Content

Extracting Data from ERP using bgrfc?

Oct 19, 2017 at 10:26 AM


avatar image

Hi Folks,

question regarding extraction data from ehp7 erp6.0 using ibm datastage 11.5 and sap pack 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

etl | bgrfc | btc | dia
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Best Answer
Patrick Weber 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.



10 |10000 characters needed characters left characters exceeded