How to automate data validation between SQL Server and Qlik project - seeking recommendations

otherjainprince810 — Fri, 15 Nov 2024 21:41:18 GMT

I am the QA Analyst for a project where we have a data warehouse on a SQL Server database, with Qlik serving as the front end for report visualization.

Our primary goal from a QA perspective is to validate that the data displayed on Qlik reports is correct and consistent with the data stored in the SQL Server database tables.

Currently, we are able to perform this validation manually, but we are interested in automating the process to improve efficiency and reduce potential errors.

We need to be able to write a program that would have basically below steps.

1. Connects to a Qlik sheet/report, pulls out the displayed data into excel /csv files

2. Connects to the underlying database( SQL Server ) on which the Qlik Sense Sheet is based

2.1 Applies ETL logic to 'raw' data from the underlying DB

3. Compares the two sets of data and flags any problems.

I am able to connect SQL server DB and pull the data into excel sheet via VBA macro but the 1st part which is 'connect Qlik sheet and export into excel sheet'

I would appreciate any guidance or recommendations on how to proceed with automating our QA validation.

Thank you in advance for your help!

I am beginner of in QA automation. I just googled it about this scenario and got to know that it can be done using python.

topic How to automate data validation between SQL Server and Qlik project - seeking recommendations in Connectivity & Data Prep

How to automate data validation between SQL Server and Qlik project - seeking recommendations