topic Re: Replicate only DELETE record from Source to Target Table in Qlik Replicate

Replicate only DELETE record from Source to Target Table

tanhanyan — Thu, 15 May 2025 09:15:53 GMT

Hi, I need details steps to guide me configure QLIK replicate task to only insert into target table when source delete the record.

My source table in SQL server and Target table in Oracle. My target table already created with empty record.

Thanks.

Re: Replicate only DELETE record from Source to Target Table

john_wang — Thu, 15 May 2025 09:22:02 GMT

Hello @tanhanyan ,

Please reference to option 3, using Soft Delete in article How to Never Capture DELETE´s in QLIK Replicate. Let me know if it works for you.

Regards,

John.

Re: Replicate only DELETE record from Source to Target Table

tanhanyan — Wed, 21 May 2025 00:39:26 GMT

Hi, Thanks for the reply, however, it was not an ideal solution to our scenario and outcome expectation.

Re: Replicate only DELETE record from Source to Target Table

john_wang — Wed, 21 May 2025 00:44:20 GMT

Hello @tanhanyan ,

Can you share more details about your specific scenario? An example would really help us understand your request more clearly.

thanks,

John.

Re: Replicate only DELETE record from Source to Target Table

tanhanyan — Wed, 21 May 2025 01:05:01 GMT

Hi @john_wang

We have 1 target table (we call it table A) replicating the source table data. The source system will delete the old record after 180days, however, at our end, we need to keep the deleted source data into another table (we call it table B). So, the idea is table A always same data value with source, and table B to keep all deleted record, and we can control the table B record, e.g. move to table C when table size too big.

When we need to find the active and inactive record, we will need to join both table A + table B + table C. And we have option to query only Table A for fast performance when need only active record.

The table A and B structure to be same as source table structure. The option 3 of soft delete will require additional column in target table, and the target table size will increase over a period of time.

Thanks.

Re: Replicate only DELETE record from Source to Target Table

john_wang — Wed, 21 May 2025 01:16:22 GMT

Hello @tanhanyan ,

Looks to me the best approach is using Trigger in table A to move the deleted rows to table B, and run housekeeping jobs periodically to shift rows from table B to C.

Hope this helps.

John.

Re: Replicate only DELETE record from Source to Target Table

tanhanyan — Wed, 21 May 2025 01:21:43 GMT

Hi @john_wang

Yes, we have already implemented this approach. We want to try with QLIK replicate so we can get notification in the event data replication hit error. However, looks like we can't use QLIK replicate to replicate only deleted record. Thanks for your reply thus far.

Re: Replicate only DELETE record from Source to Target Table

john_wang — Wed, 21 May 2025 01:48:18 GMT

Hello @tanhanyan ,

Thanks for the update. Qlik Replicate can be used to replicate deleted records only, but your specific scenario involves housekeeping operations within the Oracle database. Your current implementation is the most appropriate approach for this case.

Regards,

John.