Pls suggest the way if you implemented to extract delta load from SAP R/3 ?.
Solved! Go to Solution.
have you ever tried using DeltaQ?
It offers a built-in delta-mechanism for incremenatal loads from ECC and R/3.....
yes, in an average SAP system and good infrastructure it should take less than 18-20 hours to extract 500000000 rows.
1.) The interesting point is the built-in delta option, not only the capability to extract large amount of data....
2.) I'm no QlikView expert but I expect the need for really, really good hardware to handle 500000000 rows.... Have you ever tried it in QV? In SQL server (-> non-in-Memory BI) it works fine, but maybe not in QV. I don't know....
KONV is cluster table in SAP and that table donot have any time stamp you can extract delta load directly but with help of VBRK,VBAK you can extract delta load based on KNUMV.
To extract delta load in that manner is always time out duting extraction. because SAP server takes lots of time for each KNUMV.
is it possible through DeltaQ to extract delta load from cluster table of SAP ?.
you wouldn't use direct table acces or joins to detect your delta. The DeltaQ use OLTP data sources in R/3 that bring along their own encapsulated delta logic.
For extracting conditions one would use the extractor 2LIS_11_VAKON. Check google to find our more about the extractor.....
Please check out the White Paper, that is available in the download section:
Still i have doubt regarding delta load extraction from deltaQ for KONV table ?.
Patrick , it is not simple job even though with help of deltaQ.