Extracting Data from ERP using bgrfc?

[marcbaumann]

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

[weberpat · Accepted solution]

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