SAP Extractors Delta Queue propagates every modification as inserts

[andreabeschi]

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

[Bill_Steinagle · Accepted solution]

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_Lim...

• All changes are captured as INSERT operations.

Hope this helps.

Thanks!

Bill