topic Re: source and target validation in Qlik Replicate

source and target validation

suvbin — Fri, 15 Nov 2024 23:49:17 GMT

Is there any way where we can extract the record counts of a table/tables from source and target , columns matching of the source tables and target tables and the values in each column between source and target. All these can be extracted from replicate? Any tables that capture these information? my source is SAPHANA and targets are Azure managed instance and Azure synapse

Re: source and target validation

David_Fergen — Wed, 14 Oct 2020 12:50:47 GMT

Hi Suvbin,

We don't have any data profiling and data validation tools to Replicate. I would suggest you open an enhancement feature request in the Community Ideas board, following this link.

https://community.qlik.com/t5/Qlik-Product-Insight-Blog/Getting-Started-with-Ideas/ba-p/1684011

Thanks,

David

Re: source and target validation

suvbin — Wed, 14 Oct 2020 16:14:25 GMT

that's ok . sorry for asking one more question ..... do we have any statistics data or any system tables for replicate where the information on schema level (for tables src to target) is being stored.

Re: source and target validation

Bill_Steinagle — Fri, 11 Nov 2022 14:37:47 GMT

Hi,

Thank you for the post to the QDI forums. With Replicate there is no validation tool for comparing the Source and Target data as this would be done outside of the Product once the data is loaded and Replicated to the Target using a ODBC/JDBC connection to the Target. Also with the Enterprise Manager you can get other statistics about the Tasks running in Replicate. Here is the link to QEM for more information as needed.

https://help.qlik.com/en-US/search/?q=Statistics

Thanks!

Bill