topic Re: Programmatically verify Replicate action in Qlik Replicate

Programmatically verify Replicate action

MarkDBA — Mon, 28 Nov 2022 20:10:47 GMT

We are using to sync transactional data bi-directionally between SQL Server and DB2. Since it's transactional, we need the sync tasks to be fully operational else there's a strong potential for running into primary key errors. My question: is there a way to programmatically verify that the replicate task to the target has completed? In other words, if SQL is my source and DB2 is the target, is there a log table that can tell me that the insert/update to DB2 was completed?

Re: Programmatically verify Replicate action

Michael_Litz — Mon, 28 Nov 2022 20:26:07 GMT

Hi Mark,

In the task designer you should have a look at the Change Processing / Store Changes Settings and use the Store Changes. You can select either Change tables or Audit tables - each option is documented in the user guide and online help.

Please let me know if this is what you are looking for?

Thanks,
Michael

Re: Programmatically verify Replicate action

narendersarva — Mon, 28 Nov 2022 21:25:23 GMT

Hi Mark,

Please refer link below to better understand on how to enable _ct table and compare the source and target with reference to _ct table. Hope this helps.

https://community.qlik.com/t5/Official-Support-Articles/Troubleshooting-CDC-Missing-Data-using-Change-Tables/ta-p/1711995

Thanks
Naren

Re: Programmatically verify Replicate action

MarkDBA — Mon, 28 Nov 2022 22:19:50 GMT

Thanks; at a quick glance, those do look like what I'm looking for. We'll take a closer look and validate this is what we need.