What is QuerySurge?

About QuerySurge

QuerySurge is the smart Data Testing solution that automates the data validation and ETL testing of Big Data, Data Warehouses, Business Intelligence Reports and Enterprise Applications with full DevOps functionality for continuous testing.

Automated Data Testing Use Cases

QuerySurge provides the smart data testing solution for your automated testing needs.

Data Warehouse & ETL Testing
Automate the data validation & testing of Data Warehouses and the ETL process. more ⇒
Big Data Testing
Test any Big Data implementation, whether it be Hadoop or NoSQL data store from all major vendors. more ⇒
DevOps for Data /
Continuous Testing
Dynamically create data validation tests and integrate with other solutions in your DataOps pipeline. more ⇒
Data Migration Testing
Migrating from legacy systems to a new system, from one vendor to another, or from on-prem to the cloud. more ⇒
BI Report Testing
Retrieve data from reports and validate that data against a source or target data or another report. more ⇒
Enterprise App / ERP Testing
Automate the testing of data feeds into/out of ERP, CRM, HR system, or any large enterprise system. more ⇒

Challenges we Solve

Your need for data quality at speed. Validate up to 100% of all data up to 1,000 x faster than traditional testing. more »
Your test automation issue. Now you can automate your data testing from the kickoff of tests to performing the validation to automated emailing of the results and updating your test management system. more »
Your ability to test across platforms, whether a Big Data lake, Data Warehouse, traditional database, NoSQL document store, BI reports, flat files, JSON files, SOAP or restful web services, xml, mainframe files, or any other data store. more »
Your need to integrate for Continuous Delivery. QuerySurge integrates with most Data Integration/ETL solutions, Build/Configuration solutions, and QA/ Test Management solutions. more»
Your ability to analyze your data, with our Data Analytics Dashboard & Data Intelligence Reports more »

Supported technologies — Click to Enlarge

To see the full list of technologies supported, visit this page»

Key Features

Projects — Multi-project support in a single instance, new Global Admin user, assign users and agents, import and export projects, user activity log reports
Smart Query Wizards — Create tests visually, without writing SQL, perform column/table/row level comparisons, auto-matching of columns
Create Custom Tests — Modularize functions with snippets, set thresholds, stage data, check data types & duplicate rows, full text search, asset tagging
Scheduling — Run test immediately, at a predetermined date & time or after any event from a build/release, CI/CD, DevOps or test management solution
DevOps for Data — API Integration (both RESTful & CLI) with build/release, continuous integration/ETL , operations/DevOps monitoring, test management/issue tracking and more. Swagger documentation.

Run Dashboard — View test execution progress live via graphical displays, drill-down into data to examine results, see real-time statistics for executed tests, alert your team about the status of execution via custom email notifications
Data Analytics & Data Intelligence — Data Analytics dashboard, Data Intelligence reports, auto-emailed results, Ready-for-Analytics back-end data access
Test Management Integration — Out-of-the-box integration with Azure DevOps, IBM RQM, Micro Focus (formerly HP) ALM, Atlassian Jira and any other solution with API access

Data dashboard image full a — Click to Enlarge

BI Testing — Testing data embedded in Microsoft Power BI, Tableau, SAP BusinessObjects, MicroStrategy, IBM Cognos or Oracle OBIEE
Available On-Premises and In-the-Cloud — Install on a bare metal server, virtual machine, any private cloud or in the Microsoft Azure Cloud as a pay-as-you-go service
Security — AES 256-bit encryption, support for LDAP/LDAPS, TLS, Kerberos support, HTTPS/SSL, auto-timeout, security hardening and more

For more on QuerySurge features, visit here ⇒