Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Suggest an Idea

Announcements
This page is no longer in use. To suggest an idea, please visit Browse and Suggest.

QLIK Replicate Notification for Data Discrepancy

DanielSol
Contributor II
Contributor II

QLIK Replicate Notification for Data Discrepancy

If there is a way to compare the source data with target, that would be a good feature. Then notification can be sent to alert and investigate validation issue. This kind of data inconsistency notifications will help users to rapidly pinpoint the issue on QLIK Replication. It might be a bit difficult to make row by row comparison but at least comparing the total row count of individual tables enable users to check the overall consistency. 

5 Comments
Carlo_P
Contributor III
Contributor III

We have built a separate process which we call counts and sums to compare record counts and perform basic aggregation on the tables from both systems based on the primary key and configurable criteria to ensure overall consistency and accuracy. Having this functionality built into replicate or compose would save people an enormous amount of QA time and give piece of mind that the tool is working as intended.  I would love to have an option to run this on a scheduler in replicate or after a data load in Compose.  I think this would also save a lot of support calls on your end as this would validate the data is actually making it all the way though properly.

DanielSol
Contributor II
Contributor II
Thanks Carlo_P. Are you using ETL tool for the separate process.


Carlo_P
Contributor III
Contributor III

Yes, our process is currently designed using SSIS but we are looking into using Microsoft power automate when we port it to snowflake.

Shelley_Brennan
Former Employee
Former Employee

Data validation is not currently on the Replicate roadmap.  However, there is some validation functionality available with Qlik Catalog - you may reach out to your account rep to learn if this would meet your needs.  Several of our customers also prefer to do validation and reconciliation with their own scripting or "independent" 3rd party tools.

Status changed to: Open - Not Planned
Meghann_MacDonald

Archiving due to age of idea and relevancy. If it is still needed please resubmit.

Meghann

Status changed to: Closed - Archived