Features

See highlights of QuerySurge's
valuable features for Big Data & Data Warehouse Testing

QuerySurge Features

Browse through the key features of QuerySurge. Navigate to the topic of your interest on the left, and the specific Feature details will show up on the right.
If you have a specific question, please submit your question here>>.

  • Supported Technologies
  • Data Health Dashboard
  • Query Wizards
  • Design Library
  • Run Dashboard
  • Scheduling
  • Reporting
  • Administration
  • QuerySurge API
  • CI, CD & DevOps
  • Test Mgmt Integration
  • Security

Supported Technologies

    Supported Vendors and Technologies

    QuerySurge supports all of the data stores below as either a source or target.

  1. Amazon Redshift, DynamoDB
  2. Apache Hadoop/Hive/Spark
  3. EXASOL
  4. Cassandra
  5. Couchbase
  6. Cloudera
  7. Flat Files (delimited and fixed-width)
  8. JSON
  9. Hortonworks
  10. HPE Vertica
  11. IBM (DashDB, BigInsights, DB2, Netezza, Informix, Cloudant)
  12. Mainframe
  13. MapR
  14. Microsoft (SQL Server, PDW, SSAS, Access, Excel)
  15. MongoDB
  16. Oracle (Oracle db, MySQL, Exadata)
  17. Pivotal GreenPlum
  18. PostgreSQL
  19. Salesforce
  20. SAP (HANA, IQ, ASE, SQL Anywhere)
  21. Sharepoint
  22. Teradata, Aster
  23. XML
  24. We support any data store that has a jdbc connection. If you do not see it here, ask us. We can still help you.

Data Health Dashboard

    Data Health Dashboard

    See a holistic view of the health of your data
    How healthy is your data? Unlike data quality, data health is a multi-dimensional indicator of the integrity and effectiveness of your organization's most valuable asset. Get insight into your Big Data like never before with QuerySurge Data Health Dashboards.

  1. Build a customized dashboard from a selection of widgets to see the status of your project at a glance.
  2. Easily see and report on trends in both your data and your team's performance.
  3. Drill down into high-level information with interactive widgets. Get detail for a specific day, or about a specific test just by hovering or zooming in.
  4. Monitor your hard disk usage with our monitoring widget.

See more details here>>

Query Wizards

    Query Wizards

    Fast and easy. No Programming needed.
    The latest QuerySurge release introduces the new Query Wizards. The Wizards allow both novice and experienced team members to validate their organization's data quickly with no SQL programming required.

    The Wizards provide an immediate ROI through their ease-of-use and ensure that minimal time and effort are required for developing tests and obtaining results. Even novice testers are productive as soon as they start using the Wizards.

    There are 3 types of data comparisons:

  1. Column-Level Comparison
  2. Table-Level Comparison
  3. Row Count Comparison
  4. See more details here>>

Design Library

    Design Library

    Take total control of your custom test design
    Solid test design is the foundation of good testing. Use the QuerySurge Design Library tools to create collections of powerful tests across your Data architecture.

  1. Create custom QueryPairs (using SQL) between any two points (Source, Staging, Data Warehouse, Big Data, Data Mart) in your architecture.
  2. Design flexible queries with Reusable Query Snippets - query fragments that you can use to modularize your queries and speed up the process of bulk QueryPair updates.
  3. Run DesignTime QueryPair executions as you build queries to ensure they produce the required results .
  4. Data-type checking validates the data-type difference between source & target or turn this feature off to return all values as strings
  5. Duplicate row checking mechanism
  6. Column threshold option validates fields within a user-defined percentage or value
  7. Version control tracks Query Pair history changes made over time

Run Dashboard

    Run Dashboard

    View your data live during execution
    Visualize and track the real-time progress of your running Scenarios on the QuerySurge Run Dashboard. A graphical display helps you to follow the flow of your Queries, and you can drill-down to see test details and data failures.

  1. View Query execution progress live via graphical run status displays
  2. Drill-down into data as QuerySurge processes it to examine results as they become available during execution
  3. See real-time statistics for each QueryPair executed and for the Scenario execution as a whole
  4. Alert your team about the status of execution via custom email notifications
  5. Export detailed results in Excel, CSV or XML formats to share with team members and other project stakeholders

Scheduling

    Scheduling

    Schedule your testing by time and location for maximum productivity
    Contention for environments is common during Data Warehouse and ETL development. Simplify the process by scheduling your tests for the specific times when your architecture is available, or for a window of time when your activities will least impact the rest of the team.

  1. Mix-and-match Test QueryPairs in QuerySurge Test Suites to meet specific project execution goals
  2. Build groups of QuerySurge Test Suites to test specific mappings, ETL logic or Data Warehouse Sources
  3. Build QuerySurge Scenarios for scheduling your execution runs at specific dates and times
  4. Run test immediately, at a predetermined time (like Wednesday at 11:00 pm) or use the QuerySurge API to have your tests automatically run by your data integration, ETL, automated build, change management or test management solution.

Reporting

    Reporting

    Get a comprehensive audit and share detailed results with others
    Communication is critical for team and project success. Use QuerySurge reports to share both high-level and detailed views of your testing with team members, managers and business stakeholders.

  1. Configure reports for specific date ranges, asset types or specific executions to get the view into your results that you need.
  2. Design test reports with details including Query Pair history, mapping coverage and Reusable Query Snippet usage.
  3. Test Suite reports include history and last run execution results.
  4. Scenario execution reports include summary reports, detailed execution reports, and root cause analysis reports.
  5. User configuration reports include administrative summary, users, and connections.
  6. 5 new Root Cause Analysis reports allow users to analyze their results from a column-level perspective, as a quicker way to isolate core data issues. More information on these reports can be found here>>
  7. Export your reports as Excel or PDF files to share within your organization or to archive for future audit needs

See full list of reports here>>

Administration

    Administration

    Simplified application and user management
    The administration module provides access to the control features of your QuerySurge installation. Here, you have the ability to create and manage user profiles, database connections, agent configuration, and data archiving options.

  1. Create and manage QuerySurge Users and Agents
  2. Manage QuerySurge data storage with the included storage tools
  3. Create connections to Source and Target data stores
  4. Import existing SQL queries from an Excel spreadsheet or export queries from QuerySurge into an Excel spreadsheet
  5. View QuerySurge server information, including configuration settings and your application licensing details
  6. Configure email updates so users automatically receive results of test runs
  7. QuerySurge with LDAP Authentication
  8. You can have your LDAP server handle QuerySurge Authentication
  9. Both Anonymous and Simple LDAP authentication are supported

QuerySurge API

    QuerySurge API

    Extensibility for QuerySurge users
    The QuerySurge API provides users with the ability to control multiple services from the command line and automate them through scripts.

    QuerySurge API
  1. Execute QuerySurge Test Suites remotely
  2. Obtain Execution Outcome status (Pass/Fail) remotely
  3. Modify Reusable Query Snippet values for Parametrizing SQL
  4. Customize QueryPairs in real-time
  5. Pass in values such as dates or incremental ID’s
  6. Call into command-line API from any external process, including Schedulers, Automated build/Continuous Integration and ETL tools
  7. Deploy/call API on Windows or Linux operating systems
  8. Use the API to write branching scripts to create execution logic driven by pass/fail results. Email notifications can be customized and sent upon pass/fail status

See more information on the API here>>

Continuous Integration (CI), Continuous Delivery (CD) & DevOps

    Continuous Integration (CI), Continuous Delivery (CD) & DevOps

    Deliver validated data in your DevOps initiatives on a Continuous Basis

    CI, CD & DevOps
  1. QuerySurge can automatically be executed through:
  2. automated build solutions
  3. data integration/ETL solutions
  4. test management solutions
  5. configuration management solutions
  6. any other event that can trigger a command line API
  7. QuerySurge tests can run completely unattended
  8. Email results can be sent automatically to everyone on the team
  9. See more details here>>

Test Management Integration

    Test Management Integration

    Integrate seamlessly with industry-standard Test Management Solutions
    QuerySurge connectors offer support for solutions such as HPE Quality Center, Microsoft Team Foundation Server, and IBM Rational Quality Manager.

    IBM, HP, and Microsoft logos
  1. Drive QuerySurge execution from your Test Management Solution
  2. Outcome results (Pass/Fail/etc.) are returned from QuerySurge to your Test Management Solution
  3. Results are linked in your Test Management Solution so that you can click directly into detailed QuerySurge results
  4. Connectors are available for HPE Quality Center/Application Lifecycle Management (10+), Microsoft Team Foundation Server (2010+), IBM Rational Quality Manager (4.x+)
  5. See more details here>>

Security

    QuerySurge Security

    RTTS takes precautions to protect our customers from security issues. Below are some of the main features of QuerySurge security:

    QuerySurge Security
  1. Data Security – Database passwords and source/target credentials are stored and transmitted between QuerySurge components with AES 256 bit encryption
  2. LDAP – QuerySurge deploys with Lightweight Directory Access Protocol (LDAP) authentication option
  3. Kerberos – QuerySurge supports integration with Kerberos’ security mechanisms (dependent on JDBC driver Kerberos support)
  4. HTTPS/SSL - QuerySurge supports optional HTTPS/SSL deployment
  5. QuerySurge database – Our team can provide optional database data file encryption
  6. If you need information on our Software Security Program, please contact your QuerySurge representative for the full report.