QuerySurge

Main Features

• Test across different platforms. 
• Automate the testing effort from the kickoff of tests to the data comparison to auto-emailing the results. 
• Speed up data testing and validation by as much as 1,000 times.
• Schedule tests to run immediately, every Tuesday at 2:00am or after an event, such as an ETL job, triggers the tests.
• Share information on your data’s health with the entire team through real-time reports, audit history and dashboards.
• Integration with leading Test Management Solutions. integrate with HP, IBM and Microsoft.
• Query Wizards - fast and easy with no programming needed. 
• DevOps and Continuous Integration. Integrates with most Build, ETL & QA management software.
• Include 5 modules:
  • Design Library - Take total control of your 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 Warehouse architecture.
  • 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.
  • 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.
  • 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.
  • 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.

More Features

• Supported Environments

  • QuerySurge supports databases, data marts, data warehouses and flat files as either sources or targets. the following database are supported by QuerySurge: Oracle, Teradata, Microsoft, IBM, Sybase, Netezza, Aster Data, Hadoop, Exadata, GreenPlum, In-Memory DB, Flat files (delimited and fixed-width) and any other JDBC-compliant database or data source

     

• Creates Test QueryPairs (using SQL)between two points (Source, Staging, Data Warehouse, Data Mart)
• Query Snippets - Snippet libraries of query fragments to modularize the queries.
• Mix-and-match Test QueryPairs in QuerySurge Test Suites .
• Builds groups of QuerySurge Test Suites to test specific mappings, ETL logic or Data Warehouse Sources
• Builds QuerySurge Scenarios to schedule execution runs
• Execution API for event-based scheduling
• Supports real-time progress of running Scenarios on the QuerySurge Run Dashboard. 
• Graphical drill-down run status displays
• Custom email notifications
• Export detailed results in Excel,PDF, CSV or XML formats
• Configurable, Built-in reports reports within the QuerySurge Report Library
• Configures reports for specific date ranges, asset types or specific executions 
• Storage tools included
• Creates connections to Source and Target data stores
• View QuerySurge server information, including configuration settings and your application licensing details