FAQ

Have a question about QuerySurge? Find your answers here. Don't see your question? Use our live chat.

QuerySurge FAQ

Browse some of the most commonly asked questions about QuerySurge to find answers. Navigate to the topic of your interest on the left, and all related FAQ's will show up on the right.
Is your question not here? Feel free to use our live chat (located on the left side of your browser window), or drop us a line here.

  • Architecture
  • Installation
  • Connectivity
  • Using QuerySurge
  • Data
  • Integration
  • Reporting
  • Licensing
  • Trials
  • Training
  • Support

Architecture

  1. What is QuerySurge's architecture?
  2. QuerySurge consists of the following components:

    1. The QuerySurge Application Server (Tomcat)
    2. The QuerySurge Database (MySQL)
    3. QuerySurge Agent(s) – a minimum of one must be deployed
    4. QuerySurge Execution API (optional)

    For more information and a detailed look at the QuerySurge product Architecture components, see this page: http://www.querysurge.com/product-tour/product-architecture

     

  3. What is an Agent?
  4. The QuerySurge Agent is the component of the architecture that actually executes queries against Source and Target data sources, returning the results to QuerySurge. Agents are deployed in a hub-and-spoke relationship to the QuerySurge application server, as you can see in the QuerySurge product architecture diagram.

  5. How many Agents will I need?
  6. For a QuerySurge Trial or a POC, one agent is normally sufficient.

    For production deployment, the answer is dependent on multiple factors (your Source/Target data base/data source products, the hardware Source/Target are deployed on, your style of query-writing), and is best determined as you gain more experience with QuerySurge in your own environment.

  7. Do I need to use my own backend database?
  8. Nope! QuerySurge comes with its own embedded database. We handle the database licensing, so deploying QuerySurge will not affect any licensing that your organization currently has.

Installation

  1. What can I install on for a trial?
  2. For a QuerySurge trial, the specifications can be found here>>

  3. What can I install on for production deployment?
  4. Our recommended production deployment specifications can be found here>>

  5. Does the QuerySurge Agent need to be deployed on my database servers?
  6. No – in fact, we do not recommend deploying Agents on your database servers.

    Agents should be deployed in your environment in a hub-and-spoke relationship to the QuerySurge application server. Any boxes or VMs with sufficient resources (see questions above) to perform QuerySurge tasks can be used, including the Testers’ desktops.

  7. I have queries in my trial installation of QuerySurge that I want to use after I purchase a license. Can I keep them?
  8. Yes. If you deployed your Trial installation on the same hardware as you plan for your production QuerySurge installation, you’re all set – all we need to do is apply your new license to your existing QuerySurge instance. Everything else stays the same.
    If you need to move your queries from your trial QuerySurge instance to your “permanent” QuerySurge installation, please contact us or get in touch with your account manager. We’ll be happy to help you!

  9. Does QuerySurge install locally for each user, or is it a web-based application?
  10. QuerySurge is a pure Web 2.0 application with a database server behind an app server. Users can access the software through any supported browser (Chrome, FireFox, IE 9 and newer, Safari).

  11. Where can I get help if I have issues during installation?
  12. Most users will start by searching our Knowledge base, which I available on our web site at the top menu or through the Orange Help button at the bottom left of every page of our web site. From there you can either search for information or reach out to our support team directly. To view the Knowledge Base, click here>>

Connectivity

  1. What technologies are supported?
  2. QuerySurge supports all Hadoop and NoSQL data stores, Data Warehouses, traditional databases, flat files, XML, Excel, mainframe, JSON and any other JDBC compliant data structure. For a full list of technologies supported, click here>>

  3. How do you configure the connections of the databases for source to target?
  4. All database connections can be configured using QuerySurge’s built-in Connection wizard. You will have the option to access this wizard when installing the application.

  5. Are the database connections set up on a per-user basis?
  6. No. Once a Connection has been set up in the application, all authorized QuerySurge users can build queries using any connection.

  7. How does QuerySurge handle flat file querying?
  8. QuerySurge ships with a flat file JDBC driver that makes your files “look” like database tables to QuerySurge. You can then query your files using a standard SQL dialect.

  9. How does QuerySurge handle XML file querying?
  10. We have an XML file JDBC driver that makes your XMLs “look” like database tables to QuerySurge. You query your files using a standard SQL dialect. Contact us for information.

  11. Does QuerySurge support data comparison from a flat file to data in a database?
  12. Yes, QuerySurge is built for this! You can query flat file vs. database, excel file vs. database, XML file vs. database, flat file vs. flat file, Hadoop/Hive vs. database, Hadoop/Hive vs. flat file, etc. in any combination.
    If you have a specific data source combination to ask us about, don't hesitate to reach out to us!

Using QuerySurge

  1. How setup is done for Source/Target?
  2. QuerySurge has a Connection Wizard in the Administrative view to take you through the process of setting up connections to your Source and Target data sources.

  3. QuerySurge Agents - what are they? Where are they deployed in the environment?
  4. The QuerySurge Agent is the component of the architecture that actually executes queries against Source and Target data sources, returning the results to QuerySurge. Agents are deployed in a hub-and-spoke relationship to the QuerySurge application server.

  5. Are there any syntax limitations for writing QueryPairs?
  6. There are no syntax limitations. Any query syntax that you put in QuerySurge will be executed as-is. You may use all ANSI SQL syntax plus any custom syntax your database or data source supports.

  7. Can I use my existing SQL queries in QuerySurge as QueryPairs?
  8. Absolutely - most testing groups already have SQL for their current testing process. This SQL can be either be used directly in QuerySurge or tweaked for QuerySurge to give you a jump-start in implementing your automated data testing effort.

  9. Do I have to manually run my tests, or can I schedule them to run?
  10. You can schedule runs in QuerySurge either by creating a QuerySurge Scenario, which lets you schedule based on time, or you may use the QuerySurge execution API, which lets you schedule based on events external to QuerySurge.

  11. Is there an API or command line support to kick off an execution run?
  12. The QuerySurge execution API lets you schedule based on events external to QuerySurge. This API is a command-line API that you can deploy in your environment call into QuerySurge’s execution engine from external processes.

  13. What is the typical learning curve for a new QuerySurge user? Are there education services available?
  14. QuerySurge provides a clean, intuitive workflow for all the major tasks in Data Warehouse/ETL testing and Data migration testing, and our users find it easy to move their work into QuerySurge quickly.

    QuerySurge implementation is fully supported by courseware – browse our QuerySurge course listings for more information.

  15. Do I need to know SQL to use QuerySurge?
  16. QuerySurge has a Data Wizard to generate simple SQL queries for your straightforward tests. SQL knowledge will help you craft queries for your more complex tests.
    See our course offerings to jump-start your SQL knowledge and master the skills necessary for QuerySurge.

  17. Can SQL be generated automatically within QuerySurge?
  18. QuerySurge has a Data Wizard to generate simple SQL queries for your straightforward tests.

  19. Does QuerySurge provide version control for the QueryPairs?
  20. QuerySurge retains history for your QueryPairs and your Suites. You can see all revisions on each QueryPair, who made the revision, and when it was performed. You can also generate reports on QueryPair and Suite history for project audit or other management purposes.

  21. Can I share my reports with others?
  22. Absolutely. QuerySurge reports can be exported either in pdf format or in Excel format for either sharing with co-workers of for documentation purposes.

Data

  1. Are there any data size limitations?
  2. QuerySurge imposes no data size limitations on queries. However, the hardware that you deploy QuerySurge on will impose its own limitations. More hardware resources will give you greater flexibility with QuerySurge.

  3. What technologies are supported?
  4. QuerySurge supports all Hadoop and NoSQL data stores, Data Warehouses, traditional databases, flat files, XML, Excel, mainframe, JSON and any other JDBC compliant data structure. For a full list of technologies supported, click here>>

  5. Does QuerySurge test unstructured data?
  6. If your unstructured data is in a datastore that can accommodate JDBC connectivity, we should be able to handle it. Contact us if you would like to discuss specifics.

  7. What kinds of data can QuerySurge test?
  8. QuerySurge can test most of the standard data types that are common to current data stores and databases. This includes CLOB and BLOB data types.

Integration

  1. Are there API options?
  2. The QuerySurge execution API gives you command-line access to the QuerySurge execution engine. You can call into the API from any tool that can access a command line. Common uses are to launch QuerySurge executions from your ETL tool or from a scheduler. For more information, please visit our Features page here>>

  3. Does QuerySurge integrate with any Test Management tool?
  4. QuerySurge currently integrates with HP’s ALM/Quality Center, Microsoft’s Team Foundation Server (TFS) and IBM’s Rational Quality Manager. For more information, please visit our Test Management Connectors page here>>

  5. Can QuerySurge be automatically launch for another tool?
  6. Through the API, QuerySurge can be automatically launched by any ETL tool, Scheduler or Automated Build software that has command line API access. For a list of software we integrate with, please visit our DevOps, CD/CI page here>>

Reporting

  1. Does QuerySurge support custom reporting options?
  2. QuerySurge reporting is highly customizable with multiple filters on most reports.

  3. Can my reports be distributed and/or exported to others?
  4. Reports can generally be exported to a pdf or Excel format.

  5. Can QuerySurge notify me by email about executions?
  6. Absolutely. QuerySurge has an email notification feature that lets you set up custom email notifications to other QuerySurge users about executions, including execution outcomes and metrics, based on triggers of your own choosing.

Licensing

  1. How does the licensing work?
  2. QuerySurge licensing is user-based. See our licensing model for the details.

  3. Do we need to acquire licenses for each Source/Target technology, or is this included with QuerySurge?
  4. Nope! We use standard drivers for all Source/Target technologies, and if we don’t ship with a driver you want, you can deploy it yourself. No additional licensing is required.

Trials

  1. What can I install on for a trial?
  2. You can install QuerySurge on most desktops or even laptops. Resources (memory, disk space) are important for QuerySurge! The more you have, the more you can do during your trial.

  3. What features are disabled in a trial?
  4. No features are disabled for any of our trial options! The only limitation is trial length, which for a Cloud trial is 3 days, a trial download is 15 days, and a Proof-of-Concept trial is 30 days.

  5. Do I need to install QuerySurge in my own environment to try it?
  6. Nope! You can try QuerySurge in a Hosted Cloud Trial – our environment and our data, but you’ll be up and running with QuerySurge in minutes. See what else the Cloud trial has to offer and sign up.

  7. My company would like to formally evaluate QuerySurge – do you offer support during trials?
  8. Sign-up for a QuerySurge Proof-of-Concept. You can use QuerySurge for 30 days with weekly support sessions and regular communication from your dedicated account team. See more about what you'll get with a PoC and sign up.

  9. If I have any questions or issues during my trial, what is the best way to get an answer?
  10. Most users will start by searching our Knowledge base, which I available on our web site at the top menu or through the Orange Help button at the bottom left of every page of our web site. From there you can either search for information or reach out to our support team directly. To view the Knowledge Base, click here>>

Training

  1. Can I get trained on QuerySurge?
  2. Sure! We have a full range of training, from an ETL testing fundamentals course, to introductory training for QuerySurge, to SQL courses to build your testing-by-SQL skills. Browse our course selection to see which courses best fit your needs.

  3. What are the options for training course delivery?
  4. Courses can be delivered via the Cloud or on your site (class size requirements apply).

  5. Do you offer a formal certification for QuerySurge?
  6. We don't offer one right now, but a formal certification is on our roadmap for the near future.

Support

  1. If I run into an issue with QuerySurge, how can I get help?
  2. Either visit our Knowledge Base & Community Forums (https://querysurge.zendesk.com/hc/en-us) or click on the Orange Button on the bottom left of our website! These are the quickest ways to get information or log a ticket within our system.

  3. Does QuerySurge have offices outside of the United States?
  4. While the QuerySurge team is located in the U.S., we support customers globally. We also have built an extensive partner ecosystem that is located in every locale in the world. For information on our partners, please visit our Partner page here>>