Automate the Testing Effort

Technical Challenge

Your test team wrote SQL queries to test data across different legs of the data process. But they need to execute them manually using a SQL editor, dump them into Excel and compare them by eye (this is known as ​‘Sampling’). This process is time-consuming, resource-intensive and inefficient. How can you improve and automate this?

The QuerySurge Solution

QuerySurge, the smart Data Testing solution that automates the data validation and ETL testing of Big Data, Data Warehouses, BI Reports, can automate the entire process for you and fit nicely into your DevOps for Data strategy.

Here are some of QuerySurge’s key features:

• Leverage artificial intelligence to quickly convert all data mappings into tests with QuerySurge AI

• Create tests to compare tables, columns and row counts visually with our Query Wizards

• Create custom QueryPairs and reusable Query Snippets in our Design Library
• Compare data from source files & data stores to the target Data Warehouse or Big Data store
• Compare millions of rows and columns of data in minutes
• Schedule tests to run (1) immediately, (2) any date/time or (3) automatically after event ends
• Produce informative reports, view updates and auto-email results to your team

Now Let's Automate:

ETL automation:

• To automate the ETL process, have your Data Integration/ETL software kick off QuerySurge through our command line or Restful API after the ETL software completes its load process.
• QuerySurge will run automatically and unattended, executing all tests and reporting all results, including pass/fail results and full details of each individual data failure.
• QuerySurge also sends an automated email to everyone on the team with results.

DevOps, Continuous Integration & Continuous Delivery:

• Automation for CI/CD happens through QuerySurge’s command line or Restful API.
• QuerySurge runs unattended, executing all tests and reporting all results, including pass/fail results and full details of each individual data failure.
• QuerySurge also sends an automated email to everyone on the team with results.
• See more about QuerySurge and DevOps, CI & CD here ⇒

Test Management Automation:

• To automate your process through your Test Management solution, first store your tests in your favorite Test Manager (Micro Focus ALM/QC, Microsoft’s TFS or IBM’s RQM).
• Next schedule your Test Management solution to automatically kick off QuerySurge through our API.
• QuerySurge will run unattended, executing all tests and reporting all results to your Test Management solution, including pass/fail results and full details of each individual data failure.
• QuerySurge also sends an automated email to everyone on the team with results.
• See a video on our solution with Micro Focus ALM here ⇒

QuerySurge will help you:

• Leverage artificial intelligence to quickly & easily increase test coverage
• Continuously detect data issues in the delivery pipeline
• Utilize analytics to optimize your critical data
• Improve your data quality at speed
• Provide a huge ROI

But don’t believe us (or our clients). Try it for yourself.
Check out our free trials and great tutorial