IBM and QuerySurge
A long-term partnership built
around customer success
Automated data validation for IBM data and AI environments
Put your IBM technology investments to work with data your business can trust. QuerySurge helps teams validate data across databases, pipelines, and business intelligence reports, while QuerySurge AI supports IBM watsonx for automated test creation.
From verifying data transformations to checking the numbers in Cognos reports, QuerySurge helps your team find discrepancies before they affect business decisions.
The IBM and QuerySurge relationship
RTTS, the developer of QuerySurge, has been partners with IBM since 2003. QuerySurge is listed in the IBM Partner Plus directory.
QuerySurge combines automated data validation with support for IBM technologies, and IBM Consulting has used QuerySurge to deliver validation for complex customer projects since its launch in 2012.
View QuerySurge in the IBM Partner Plus directory
Create validation tests with IBM watsonx
QuerySurge AI supports IBM watsonx as an AI endpoint, giving organizations that have selected watsonx the flexibility to use it for two complementary testing workflows:
- Mapping Intelligence converts mapping documents into validation tests, including tests of transformation logic.
- Query Intelligence helps users generate and refine SQL tests through plain English conversations informed by schema metadata.
Your team can reduce manual test development while keeping generated SQL available for review and refinement.
Validate data across IBM environments
QuerySurge connects to supported data sources and compares query results to identify differences. Teams can apply this approach to database testing, data migrations, and reporting validation.
IBM Technology |
How QuerySurge supports validation |
|---|---|
IBM Db2 |
Connect to Db2 and compare query results with other supported data sources to validate data movement and business rules. |
IBM Netezza |
Validate warehouse data through supported Netezza connections and compare it with source systems or migration targets. |
IBM Cognos Analytics |
Use QuerySurge BI Tester to retrieve report data and compare it with trusted data sources. Group report tests into suites and schedule repeatable checks. |
IBM Db2 Warehouse |
Validate warehouse loads, transformations, and migrations by comparing Db2 Warehouse data with supported source and target systems through compatible Db2 connections. |
IBM watsonx.data |
Compare lakehouse query results with source data to validate ingestion and transformations. Confirm QuerySurge connectivity for your watsonx.data query engine and driver. |
IBM Confluent |
For streaming pipelines, compare data in supported source and destination stores to check that delivered records match expectations, using consistent event keys and time windows. |
IBM Cloud Pak for Data |
Validate data used by platform services through supported underlying databases and source and target connections, including checks of pipeline outputs and business rules. |
IBM Cloudant |
Query Cloudant JSON documents with SQL and compare them with other supported systems. |
For teams using IBM DataStage, a practical validation approach is to connect QuerySurge to the pipeline’s supported source and target data stores, then compare expected and actual results after processing. This checks the data produced by the pipeline through data connections.
Explore supported data connections
Keep mappings and validation aligned
As requirements change, testing needs to change with them. QuerySurge Mapping Studio brings mapping documentation into the same environment as the tests that validate it. Teams can import Excel or CSV mappings, standardize documentation, and generate tests through Mapping Intelligence.
QuerySurge Validation Lineage shows relationships between mappings, queries, test suites, and schedules. Teams can identify requirements without associated tests and see which validation assets need to be reviewed when transformation logic changes.
Explore Mapping Studio | Explore Validation Lineage
IBM Consulting customer success
IBM Consulting used QuerySurge to automate data validation for a leading US annuity and life insurance provider. The work covered daily file processing and a cloud migration involving more than 2,000 tables.
The published case study reports:
- File validation in under one hour, compared with a manual process taking up to eight hours.
- More than 9,000 QueryPairs created for automated validation.
- More than 2,000 tables across four schemas validated for the migration.
The team also connected QuerySurge to its automation workflow through API calls and the Azure DevOps extension.
Benefits for your team
- Reduce manual effort. Generate tests with AI and reuse automated validation suites.
- Find data issues earlier. Compare expected and actual results before downstream reports depend on them.
- Manage change with better visibility. Trace the relationships between requirements and validation assets.
- Support release decisions. Give delivery teams documented test results to review.
- Validate across platforms. Test data as it moves between supported IBM and non-IBM systems.
Frequently Asked Questions
- Can we use IBM watsonx with QuerySurge AI?
- Can QuerySurge validate data in IBM Cognos reports?
- Can QuerySurge test data moving between IBM and other platforms?
- Do we need watsonx for every validation test?
Yes. QuerySurge 15 introduced IBM watsonx endpoint support for Mapping Intelligence and Query Intelligence.
Yes. QuerySurge BI Tester retrieves data from supported Cognos Analytics reports and compares it with other supported data sources. BI Tester is licensed separately, and connectivity depends on your Cognos version and required SDK components.
Yes. QuerySurge supports comparisons across different technologies, provided the source and target have supported connections and the required drivers and access are available.
No. IBM watsonx is an option for AI-assisted test creation. QuerySurge also supports SQL-based tests and Query Wizards.
