Skip to main content

Tab navigation

QuerySurge is a testing tool built specifically to automate the testing of Big Data and Data Warehouses. QuerySurge ensures that the data extracted from source files/databases remains intact in the target data data store by analyzing and pinpointing any differences in data quickly.

QuerySurge is the preferred tool of:  

  • Testers (regression testing) 
  • Developers (unit testing)
  • Data Analysts (data analysis) 
  • Operations teams (monitoring) 
  • Managers


 QuerySurge helps you:

  • Automate the ETL testing effort in minutes 
  • Find Bad Data in your data warehouse and BI implementation
  • Test across different platforms (IBM® Netezza®, DB2®, other DWHs, Hadoop, NoSQL stores, DBs, flat files, xml) 
  • Schedule test runs for a certain date/time or after an event occurs (such as when the ETL process ends) 
  • View and share test results (through reporting and automated email notifications) 
  • Speed up the time it takes to test your ETL process (up to 100x faster)

Try our Free Trial download or play in our Cloud™-based Sandbox now! 

Business information

Show all   |   Hide all


  • + Functional details

    QuerySurge provides the following advantages:

    • Monitor the health of your data through data dashboards
    • Automate the ETL testing effort in minutes  
    • Find Bad Data in Big Data quickly.,  
    • Test across different platforms (IBM® Netezza®, DB2®, other DWHs, Hadoop, NoSQL, flat files, xml)  
    • Schedule test runs for a certain date/time or after an event occurs (such as when the ETL process ends)  
    • View and share test results (through reporting and automated email notifications)  
    • Speed up the time it takes to test and compare your data (up to 1,000x faster)

  • + Business problem

    QuerySurge solves the problem of automating the manual process of testing data from source databases/files through the ETL process to the data warehouse.

    The 6 biggest issues customers face are the:

    1. need to verify more data 
    2. need to automate the testing effort
    3. need to be able to test across different platforms
    4. need to speed up the testing cycle
    5. need to be able to schedule test runs
    6. need to share test results

  • + Business opportunity

    There are numerous business opportunities available through QuerySurge.

    1. For IBM® or any services firm implementing an Big Data, IBM data warehouse or ETL solution, use of QuerySurge will quickly and easily allow you to determine if the ETL process was in line with the requirements
    2.  There are partnerships available for consulting, sales, technology and referral partners

  • + Return on investment

    The return on investments are: :

    • a reduction in head count by 75% because of increased coverage
    • a savings of 26,000 per defect found in a regulated industry
    • an increase in better data due to shorter and more thorough testing cycle, saves the firm millions of dollars from preventing decisions made on bad data. 

  • + Competitive advantage

    QuerySurge provides a competitive advantage by either:

    • significantly increasing the testing coverage of your data from 1% - 10% to upwards of 100%
    • dramatically reducing testing time by as much as 1,000 x 
    • or a combination of increasing test coverage while reducing testing time

  • + Industries

    Banking Industry
       Banking - Global Customer Management
       Banking - Other

  • + Solution areas

    Cross industry
       Business Intelligence
          Data Warehousing

  • + Customer size

    Midmarket Business (100 to 499 employees)
    Midmarket Business (500 to 1000 employees)
    Large Business (greater than 1000 employees)

  • + Languages supported

    English

  • + Countries/regions available for distribution

    Canada , United States

    Australia , New Zealand

    Belgium , Denmark , Finland , France , Germany , Iceland , Ireland , Italy , Luxembourg , Netherlands , Norway , Spain , Sweden , Switzerland , United Kingdom

  • + Solution collateral

Technical information

Show all   |   Hide all


  • + Hardware/OS platforms

    Windows Server 2003
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       IBM BladeCenter HSxx (Intel processor-based)
       IBM BladeCenter LSxx (AMD processor-based)
       Dell servers
    Other Windows
       Desktops and Notebooks (all brands, including ThinkPad/ThinkCentre PCs by Lenovo)
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       IBM Systems: IntelliStation Pro
       IBM IntelliStation Pro (Intel and AMD processor-based)
       Dell servers
    RHEL5
       Desktops and Notebooks (all brands, including ThinkPad/ThinkCentre PCs by Lenovo)
       Non-IBM Hardware
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       IBM Systems: IntelliStation Pro
       Dell servers
    Windows Server 2008 (inclusive)
       Non-IBM Hardware
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       Dell servers
    RHEL6
       Desktops and Notebooks (all brands, including ThinkPad/ThinkCentre PCs by Lenovo)
       Non-IBM Hardware
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       IBM Systems: IntelliStation Pro
       Dell servers
    Windows Server 2012 (inclusive)
       Desktops and Notebooks (all brands, including ThinkPad/ThinkCentre PCs by Lenovo)
       Non-IBM Hardware
       Hewlett-Packard servers (incl. Compaq)
       Other non-IBM servers
       IBM BladeCenter HSxx (Intel processor-based)
       IBM BladeCenter LSxx (AMD processor-based)
       IBM Systems: IntelliStation Pro
       Dell servers

  • + Services

    Consulting
    Education & Training
    Infrastructure Solutions: Business Intelligence & Data Warehousing

  • + Software

    IBM Information Management
       Information Management
          DB2 Analytics Accelerator for z/OS
          DB2 Connect Application Server Advanced Edition
          DB2 Connect Application Server Edition
          DB2 Connect Enterprise Edition
          DB2 Connect Personal Edition
          DB2 Connect Unlimited Advanced Edition for System z
          DB2 Connect Unlimited Edition for System i
          DB2 Enterprise Server Edition
          DB2 Everyplace
          DB2 Everyplace Enterprise Edition
          DB2 Express Edition
          DB2 for Linux, UNIX and Windows
          DB2 for z/OS
          DB2 for z/OS Value Unit Edition
          DB2 Merge Backup for Linux UNIX and Windows
          DB2 Query Patroller
          DB2 Server for VSE & VM
          DB2 Universal Database for Linux
          DB2 Workgroup Server Edition
          InfoSphere DataStage
          InfoSphere DataStage MVS Edition
          InfoSphere DataStage Pack for Data Masking
          InfoSphere Warehouse Advanced Departmental Edition
          InfoSphere Warehouse Advanced Enterprise Edition
          InfoSphere Warehouse Departmental Base Edition
          InfoSphere Warehouse Departmental Edition
          InfoSphere Warehouse Developer Edition
          InfoSphere Warehouse Enterprise Base Edition
          InfoSphere Warehouse Enterprise Edition
          InfoSphere Warehouse on System z
    IBM Other
       PureData Systems
          PureData System for Analytics
          PureData System for Operational Analytics
          PureData System for Transactions


Date last modified:    Sep 25, 2014


qs-100x50.jpg

Contact information

Laura Poggi
212-240-9050 x9305

Company

Real-Time Technology Solutions, Inc.
360 Lexington Avenue
9th Floor
New York, NY 10017
United States

212-240-9050

Contact PartnerWorld

Live Chat is currently unavailable


The live chat service is normally available weekdays 8am-8pm Eastern Time. Use the 'Contact us' link or one of the other links for help now.