topic Qlik Replicate Change Data Capture capabilities in Qlik Replicate

Qlik Replicate Change Data Capture capabilities

Benkku — Tue, 03 Aug 2021 12:57:49 GMT

Hi!

I have a question about Qlik Replicate Change Data Capture capabilities. Are changes in the source database captured only after the full load is done?

Let's say I have a big source database that will take 15 minutes to be fully replicated into the target database. If some data is inserted, updated or deleted during those 15 minutes, will those changes be replicated to the target?

Thanks,

Bernardo Di Chiara

Re: Qlik Replicate Change Data Capture capabilities

MarinaEmbon — Tue, 03 Aug 2021 13:06:08 GMT

when you create a full load and CDC task, replicate will start capturing changes before starting the FL. All the changes that are done on the source during the FL will be cached and applied to the target after the FL.

when applying cached events, zero rows affected and duplicates will not raise data errors as they are probably the result of the synchronization issues.

Re: Qlik Replicate Change Data Capture capabilities

Benkku — Tue, 03 Aug 2021 14:42:38 GMT

Hi!

Thanks a lot for your quick answer!

It is a great tool!

Best Regards,

Bernardo