Qlik Replicate to hold history data in unmanged storage account

[AnujGupta]

Is there any way in Qlik replicate which will hold the history data in storage account. I am using source as oracle & destination as Azure databricks unmnaged storage account with Full mode on & apply changes on. 

Business need - 

[SachinB · Accepted solution]

Hello @AnujGupta ,

Thanks for reaching the Qlik community !!

We hope you are looking for an option where it holds the previous data and current data (Before and after image)

If yes, then you can refer the store change option. "https://help.qlik.com/en-US/replicate/May2023/Content/Global_Common/Content/SharedEMReplicate/Custom...

Actually, we do have 3 different apply changes modes in Replicate CDC, You can refer to the below community link for the same.

1. Using Apply change

2. Using Store change

3. Using Audit

https://community.qlik.com/t5/Qlik-Replicate/Change-Tables-vs-Audit-Tables/td-p/2073593

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Change%20Tables/use_change_tabl...

https://help.qlik.com/en-US/replicate/May2023/Content/Replicate/Main/Audit%20Table/use_audit_table.h...

We do have a history table provides information about the replication history including the number and volume of records processed during a replication task, latency at the end of a CDC task, among others, However this is at the task level not at individual table data level.

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

Let us know in case if you are looking something else, We are happy to assist you !!

Regards,

Sachin B