Data Warehouse Testing Tool Reduces Testing Effort by at least 50%

Share Article

Newly-released QuerySurge™ 2012 adds immediate value for organizations by allowing teams to validate 100% of their data and pinpoint defects quickly.

QuerySurge - Ensuring Data Warehouse Quality

QuerySurge -

We’ve seen that QuerySurge has been immediately valuable for companies in regulated industries - these teams are finally able to fully document project history for their archiving, auditing, or compliance needs.

Real-Time Technology Solutions (RTTS) today announced the newest official release of QuerySurge™ 2012, its Web 2.0 enterprise data warehouse testing application. QuerySurge was built by RTTS to address the unique quality assurance and testing requirements of any data warehouse, data migration, data integration, or upgrade projects.

Any movement of data within an organization’s data warehouse environment introduces risk for both business and technical teams. The integrity and quality of critical data can be compromised if the project is implemented without testing or validating the data to find data discrepancies throughout the process. Traditionally, testing is either done manually or with ad-hoc methods which are labor-intensive, time-consuming, and do not always guarantee full data coverage.

QuerySurge was built specifically to solve these challenges by automating ETL data validation and streamlining associated tasks in any high-volume data integration project. It gives users the ability to test 100% of their data, and detect almost any type of data defect before it hits their company’s production environment. QuerySurge was built to validate each piece of data, persisting complete data sets from both Source and Target data sources. This exposes all data failures and differences, providing users with the ability to capture and pinpoint failures throughout the ETL development cycle.

Using QuerySurge has helped organizations increase quality and reduce the chance of transitioning bad data by giving teams all of the tools necessary to maintain queries, run queries in bulk, follow the results in real-time, collaborate, and report on results. The reporting capabilities in this product enable users to export and share the metrics provided to their teams and to project stakeholders.

“We’ve seen that QuerySurge has been immediately valuable for companies in regulated industries,” said Bill Hayduk, President and Founder of RTTS. “These teams are finally able to fully document project history for their archiving, auditing, or compliance needs.”

The latest version of QuerySurge gives organizations the ability to query flat-files as data sources, in addition to allowing the comparison of data from multiple databases and database products. This provides a broad range of connectivity options and a transparent data source for users.

Take QuerySurge on a test-drive in the QuerySurge Sandbox:

For sales-related inquiries, please email Ron Axelrod at raxelrod(at)rttsweb(dot)

About RTTS
RTTS is the premier software and services company that provides Software Quality for critical business applications. Headquartered in New York, NY, its expert team has worked closely with over 400 clients to improve their testing processes, tool knowledge, and application deployment outcomes. RTTS was founded in 1996, and has forged partnerships with the world’s leading test tool vendors. Its satellite locations are in Philadelphia, Atlanta, and Phoenix, and many of its consulting and education services are offered through the Cloud. No matter where you are, RTTS will ensure application functionality, performance, scalability, and security for your organization. To find out more, visit

Real‐Time Technology Solutions, Inc., RTTS, and QuerySurge are trademarks and/or service marks of Real‐Time Technology Solutions, Inc. in the United States and/or other countries. All other company names, product or service names mentioned in this document may be trademarks of the companies with which they are associated.

Share article on social media or email:

View article via:

Pdf Print

Contact Author

Laura Poggi
(646) 329-9305
Email >
Follow us on
Visit website