Restrict delete not to replciate

[gulshanr]

Hello All,

We are replcating data from source (DB2) to Destination (Netezza). My customer want all data to be replciated but any delete on source should NOT be deleted on destination DB. 

Any idea, how can we achieve this? Cab Qlik replicate fulfil such ask or I need to build custom solution outside Qlik? 

Thanks,

[Arun_Arasu · Accepted solution]

Hello @gulshanr 

I would recommend to try   expression builder to exclude the records for which AR_H_OPERATION = delete.
Please go thru the below user guide for more information

https://help.qlik.com/en-US/replicate/May2021/Content/Global_Common/Content/SharedEMReplicate/Custom...
https://help.qlik.com/en-US/replicate/May2022/Content/Global_Common/Content/SharedEMReplicate/Custom...

Regards,
Arun

[SachinB]

Hello @gulshanr ,

There are 3 ways to filter delete expressions:

1. Simple Soft Delete
2. Conditional Soft Delete
3. Use the Filter tab of the table settings

You can refer the below community link for more information.

https://community.qlik.com/t5/Knowledge/Filter-Deletes-in-Replicate/ta-p/1801945

Regards,

Sachin B

[Michael_Litz · Accepted solution]

Hi Gulshanr,

Using the operation indicator to trap a delete operation from the source and then change it into an update on the target may work for you.

Please check out this article:
Soft Delete - Archive User
https://community.qlik.com/t5/Knowledge/Transformation-Operation-Indicator-Archive-User-Soft-Delete/...

Thanks
Michael

[gulshanr]

Thank you very much everyone for valuable input

[Michael_Litz]

Hi Gulshanr,

Glad to hear that the responses were helpful. Please do mark one of them as solution accepted.

Thanks
Michael