Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Team,
I want to extract the details of count, number of records being updated, deleted & inserted during CDC task of a particular table through Qlik enterprise Manager API.
Can anyone help me on the above.
Thanks & Regards,
Vinay
the API does not connect those information.
for the API , from user guider only have :
====
what you looking could be from the Analytic
The Enterprise Manager API function GetTableStatuses delivers the data you seem to request.
"table_cdc_info":{
"insert_count":"{int64}",
"update_count":"{int64}",
"delete_count":"{int64}",
"ddl_count":"{int64}",
"last_update_time":"{string}",
One typically calls this in a timed loop - once an hour, once a day or similar. Please do note that this information is dynamic and will disappear when the task is stopped and resumed. One might want to ensure a final data collection run just before the task is stopped but you can never get it 'exact'.
If you need this data for auditing purposes you may want to add CHANGE TABLES to you task. You can interrogate and summarize those tables on a regular basis and purge once done.
Another alternative for BATCH_APPLY tasks is to run the tasks with LOGGING for TARGET_APPLY set to DEBUG and go spelunking in the reptask logs.
Enjoy,
Hein.
Hi Steve_Nguyen,
Thanks for the solution. But I want to do it in Qlik Enterprise Manager python API.
I had worked on it and got the solution.
Thanks & Regards,
Vinay Kumar Bareth