topic Re: Getting Daily updates for Range of dates in Qlik Replicate

Getting Daily updates for Range of dates

adbdkb — Wed, 12 Oct 2022 15:00:01 GMT

Is there a way to get Qlik updates ( INSERTS, DELETES, UPDATES ) for a specific day or interval from the Qlik UI or using the Qlik REST calls or even Qlik logs?

The way I know in the UI shows the information for today until the now - the time when I check

If there is a way, can someone please let me know how ?

Thanks

Re: Getting Daily updates for Range of dates

Dana_Baldwin — Wed, 12 Oct 2022 17:16:28 GMT

Hi @adbdkb

Have you looked at the capabilities built into Enterprise Manager?

Analytics ‒ Qlik Enterprise Manager

Thanks,

Dana

Re: Getting Daily updates for Range of dates

adbdkb — Wed, 12 Oct 2022 17:29:23 GMT

At this point, I do not have access to the server ( and am not be able to request the admins to install PostgreSQL or do any other set-up ) - but in dev region, I have access to run the REST calls, hence I was wondering / hoping if there is a REST endpoint which can take the starting and ending timestamp and give me those details - I tried to look at the doc, but couldn't find any.

Thanks,

Re: Getting Daily updates for Range of dates

Heinvandenheuvel — Wed, 12 Oct 2022 19:28:31 GMT

As @Dana_Baldwin indicates you should check out Analytics ‒ Qlik Enterprise Manager

Indeed that would require PostgreSQL accessible by the EM, but not necessarily on the EM server best I know. But at any rate, if you cannot get the admins to help you with that, may we conclude that your business does not see the value of the (attempted) work? Last time I looked admins are mere 'servers' who are there to act on and answer to requests from the business. - tongue in cheek to some degree.

Another approach you may want to consider is to poll the task for details at your desired intervals and subtract the period start operation counter values from the period end counters. This plan fails if the task has an uncontrolled restart in the period which may or might not be an acceptable reporting 'risk'.

Using the Enterprise manager RestAPI you would look at 'gettaskdetails' responsebody "cdc_event_counters"."applied_xxx_count". The xxx stands for Iinsert/update/delete. Attached an example using the .NET API. Note - I haven't used this since version 5 or so some 5 years ago so it might need tweaks.

You can also get there using REPCTL gettaskstatus output fields task_cdc_event_counters - cdc_applied_xxxx_count

Start with: repctl -d <data-directory> gettaskstatus ?

Good luck

Hein