SAP Extractors Delta Queue propagates every modification as inserts

andreabeschi — Mon, 21 Jun 2021 14:43:57 GMT

Hello,

We are trying to replicate some SAP Data to SQL Server using SAP Extractors as a source endpoint
We followed the configurations listed here and activated 2 extractors: 2LIS_11_VAHDR and 0MATERIAL_ATTR.
We created a new replicate task and started doing some tests:
After the Full Load completes, every modification we do on SAP is detected by Replicate as an INSERT, so Change Processing is duplicating rows in the target tables.
(For example, if we modify a Material Attributes, after the Change Processing we have 2 rows for the same Material).

Is this the correct behavior or are we missing something?

Thanks

Re: SAP Extractors Delta Queue propagates every modification as inserts

Bill_Steinagle — Tue, 28 Jun 2022 18:49:26 GMT

Hello,

The SAP Extractor for the data flowing to the Target will show a INSERTS which is the correct behavior. For more details and limitations for the SAP Extractor can be found here if needed.

Replicate 2021.11 SP06 Link:

https://help.qlik.com/en-US/replicate/November2021/Content/Replicate/Main/SAPExtractor/extractor_Limitations_SAP_app.htm

All changes are captured as INSERT operations.

Hope this helps.

Thanks!

Bill

topic SAP Extractors Delta Queue propagates every modification as inserts in Qlik Replicate

SAP Extractors Delta Queue propagates every modification as inserts

Re: SAP Extractors Delta Queue propagates every modification as inserts