Operating Systems & Resources
Windows and Linux.Currently, we support installation on most Windows flavors and the Red Hat Linux operating system. Performing a QuerySurge trial on a laptop has some nuances, but if you choose this path, please read this article>>. Virtual Machines (VM images) are supported. If you use our trial-in-the-Cloud, no installation is necessary.
As far as CPU, RAM and disk space, more is always better, especially if your data sets are in the 100s of millions of rows with 100s of columns. For trial downloads and POCs, please click to view our System Requirements>>.
Uses & Browsers
QuerySurge is a pure Web 2.0 application that all users access through any browser, simplifying usage and deployment across distributed project teams.
Current browsers supported are:
- Internet Explorer (support for Edge coming soon)
A QuerySurge User is named user, which each team member needs in order to access and use QuerySurge.
QuerySurge has both a Full User and a Participant User functionality.
Full User – Unlimited access to create, schedule & run tests, view results, run & export reports, send & receive email notifications, export data.
Participant User – Cannot create or run tests, but can view all other information including viewing all query pairs, results, reports, receiving email notifications, exporting test results and reports.
Agents & Servers
QuerySurge Agents are the components of the architecture that actually execute queries against Source data and Target data stores, returning the resulting data sets to QuerySurge. They are also the component that allows QuerySurge to perform simultaneous testing on your Data Warehouse or Big Data store, increasing the testing throughput. The more Agents you have, the more testing throughput.
Agents are deployed on either the PC or Server where QuerySurge is installed or on any “satellite” box in the environment (often, these are test lab boxes or available desktop/laptop boxes).
The Agent, when it receives a bundle of queries, can run multiple queries concurrently (in parallel). The number of queries that an Agent can handle depends on the resources of the box you deploy it on (more RAM is better) and how you configure the Agents in QuerySurge. The trial download version comes with 5 Agents (more than enough for almost all projects).
The Agents execute SQL queries at both the Source and Target, extracting the data and inserting it into the QuerySurge database, where validation of each of data set is processed. This eliminates processing overhead on the Source and Target data stores in your architecture. QuerySurge then exposes all data mismatch failures, row count differences, and column type mismatch failures, affording you the ability to test 100% of your data quickly.
QuerySurge can be installed in the following 3 ways:
(1) On a single PC for individual users
(2) On a single server for a team of users
(3) On multiple servers for a large team and/or for large amounts of data
- You can install QuerySurge directly on a PC/Server or in a virtual image (VM)
- You can install QuerySurge on Windows or Red Hat Linux operating systems
- A QuerySurge instance includes 5 agents, although you may not need that many
- All users can see all data on an instance (a QuerySurge installation)
QuerySurge Supported Environments
QuerySurge supports Hadoop, data warehouses, databases, NoSQL document stores, XML, json, web services and flat files, and almost any other data store that has a JDBC driver.
Bundled Data Connectors (bundled JDBC drivers)
QuerySurge supports the following JDBC connectors:
- Hadoop/Hive (Apache*, Cloudera*, Hortonworks, Pivotal)
- Amazon Redshift
- Oracle (Oracle*, MySQL*, Exadata)
- IBM (DB2, Netezza, Informix)
- Teradata*, Aster
- HP Vertica
- Microsoft (SQL Server, SSAS*)
- SAP (HANA, IQ, ASE*, SQL Anywhere)
- Pivotal GreenPlum
- Flat File (delimited and fixed-width)
- Microsoft Excel, Access
- Almost any other JDBC-compliant data store
Multiple Environments/Multiple Instances
QuerySurge supports the concept of multiple testing environments (dev, test, staging, prod, etc.). Many of our customers keep each environment separate, for data security or other reasons. QuerySurge has the ability to transfer tests among instances so that the tests and queries are in sync in all instances.
Would you like more information or have questions?
Do you have a technical question? Please click on the orange button on the left side of all our web pages for access to our Knowledge Base.
Do you want to speak with someone? Please fill out the form below if you would like a member of our team to contact you.