Skip to main content

Qlik Replicate

Discussion board for collaboration on Qlik Replicate.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $400 before Dec 31st: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
gulshanr
Partner - Contributor II
Partner - Contributor II

Restrict delete not to replciate

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,

 

Labels (1)
2 Solutions

Accepted Solutions
Arun_Arasu
Employee
Employee

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

View solution in original post

Michael_Litz
Support
Support

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

View solution in original post

5 Replies
Arun_Arasu
Employee
Employee

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
Support
Support

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
Support
Support

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
Partner - Contributor II
Partner - Contributor II
Author

Thank you very much everyone for valuable input

Michael_Litz
Support
Support

Hi Gulshanr,

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

Thanks
Michael