How to Never Capture DELETE´s in QLIK Replicate

Leandro_Medeiros — Thu, 10 Apr 2025 10:52:06 GMT

Hi everyone,

I would like to create a QLIK Task to capture only INSERT and UPDATE from a table.

To Never process DELETE.

Is it possible ?

Thanks in advance.

Rgds., Leandro Medeiros

Re: How to Never Capture DELETE´s in QLIK Replicate

john_wang — Thu, 10 Apr 2025 15:55:35 GMT

Hello Leandro Medeiros @Leandro_Medeiros ,

I'm not entirely sure which source database you're using, but in most relational databases, all operations, including INSERT, UPDATE, and DELETE are recorded in the transaction logs. Typically, there's no straightforward way to prevent DELETE operations from being logged.

However, in Qlik Replicate, there are a few options available to ignore DELETE operations, even though they are still present in the transaction logs:

Using a Filter
   You can add a global filter rule like:
   $AR_H_OPERATION != 'DELETE'
   This will cause all DELETE operations to be ignored.
   ⚠️ Note: This may lead to warnings or errors if the same primary key row is deleted and then re-inserted. Since the DELETE is ignored, the INSERT could result in a duplicate primary key violation on the target.
Using Filter + UPSERT mode
Similar to approach (1) however the UPSERTmode will solve the duplicate PK violation issue. Check this article for more detailed info:
https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Implementing-UPSERT-and-MERGE-modes-by-applying-a/ta-p/1780009
Using Soft Delete
With this approach, Qlik Replicate still processes DELETE operations from the source and replicates them to the target. However, instead of removing the row from the target, it marks the row with a "deleted" flag, this is known as a soft-delete.
You can find more details in the related documentation/articles on soft-delete:

https://community.qlik.com/t5/Official-Support-Articles/Qlik-Replicate-Global-Transformation-Soft-Delete-Limitation/ta-p/2054414

https://community.qlik.com/t5/Official-Support-Articles/How-to-implement-quot-soft-quot-deletes-on-replicated-table/ta-p/1825769

https://community.qlik.com/t5/Official-Support-Articles/How-to-create-a-Qlik-Replicate-task-to-capture-soft-deletes-and/ta-p/2121662

Hope this helps.

John.

Re: How to Never Capture DELETE´s in QLIK Replicate

Leandro_Medeiros — Wed, 30 Apr 2025 11:58:46 GMT

Hi John,

"$AR_H_OPERATION != 'DELETE' " is Perfect !!!

Thank you so much.

Re: How to Never Capture DELETE´s in QLIK Replicate

john_wang — Wed, 30 Apr 2025 12:13:05 GMT

Thank you so much for your outstanding support! @Leandro_Medeiros

topic Re: How to Never Capture DELETE´s in QLIK Replicate in Qlik Replicate

How to Never Capture DELETE´s in QLIK Replicate

Re: How to Never Capture DELETE´s in QLIK Replicate

Re: How to Never Capture DELETE´s in QLIK Replicate

Re: How to Never Capture DELETE´s in QLIK Replicate