www.querysurge.com Open in urlscan Pro
157.230.67.176  Public Scan

Form analysis
2 forms found in the DOM

https://www.querysurge.com/search

<form action="https://www.querysurge.com/search"><input type="search" name="keywords"></form>

POST

<form method="post" data-id="d88d92-form-3ezr2XOQD_VpZDxO25X_a55cba991ff7d35cdbe0ccafa933394d5f788c956345a1201ee34" data-handle="formFooter" data-ajax="" data-disable-submit="" data-success-message="Form has been submitted successfully!"
  data-error-message="Sorry, there was an error submitting the form. Please try again." data-freeform="" data-recaptcha="v3" data-recaptcha-key="6Lf9YuMUAAAAAE4AmI7NEYs4hflPnRLv1uQZ2xwo" data-recaptcha-action="homepage">
  <input type="hidden" name="action" value="freeform/api/form"><input type="hidden" name="formHash" value="3ezr2XOQD_VpZDxO25X_a55cba991ff7d35cdbe0ccafa933394d5f788c956345a1201ee34"><input type="hidden" name="CRAFT_CSRF_TOKEN"
    value="huJtNBX1f37e6SRGg8JjcoallmD05tzVFTaVO45Z1b6lXjmEwyD_B8LSWWNBvEc8kYxKH9r2JErj669XpJCv4kFn5WjXOpfPxj9J_I5juFE="><input class="form-control" name="referringPage" type="hidden" id="form-input-referringPage"
    value="https://www.querysurge.com/resource-center/case-studies/escholar-selects-querysurge-to-automate-their-data-testing-efforts?utm_source=mailer&amp;utm_medium=qs_october"><input class="form-control" name="00N7000000279V1" type="hidden"
    id="form-input-00N7000000279V1" value="Prospect"><input class="form-control" name="00N70000002yT8b" type="hidden" id="form-input-00N70000002yT8b" value="1"><input class="form-control" name="00N7000000279iK" type="hidden"
    id="form-input-00N7000000279iK" value="QS Contact"><input class="form-control" name="00N70000002yx9g" type="hidden" id="form-input-00N70000002yx9g" value="QuerySurge"><input class="form-control" name="00N70000002zx6b" type="hidden"
    id="form-input-00N70000002zx6b" value="1"><input class="form-control" name="w2lsubmit" type="hidden" id="form-input-w2lsubmit" value="1"><input class="form-control" name="ipAddress" type="hidden" id="form-input-ipAddress"
    value="138.199.38.133"><input class="form-control" name="type" type="hidden" id="form-input-type" value="service">
  <div id="d88d92-form-3ezr2XOQD_VpZDxO25X_a55cba991ff7d35cdbe0ccafa933394d5f788c956345a1201ee34" data-scroll-anchor=""></div>
  <div class="freeform_form_handle" style="position: absolute !important; width: 0 !important; height: 0 !important; overflow: hidden !important;" aria-hidden="true" tabindex="-1"><label aria-hidden="true" tabindex="-1"
      for="freeform_form_handle">Leave this field blank</label><input type="text" value="" name="freeform_form_handle" id="freeform_form_handle" aria-hidden="true" tabindex="-1"></div>
  <script>
    var form = document.querySelector('[data-id="d88d92-form-3ezr2XOQD_VpZDxO25X_a55cba991ff7d35cdbe0ccafa933394d5f788c956345a1201ee34"]');
    if (form) {
      form.addEventListener("freeform-ready", function(event) {
        var freeform = event.target.freeform;
        freeform.setOption("errorClassBanner", ["alert", "alert-danger", "errors"]);
        freeform.setOption("errorClassList", ["help-block", "errors", "invalid-feedback"]);
        freeform.setOption("errorClassField", ["is-invalid", "has-error"]);
        freeform.setOption("successClassBanner", ["alert", "alert-success", "form-success"]);
        // Show loading message on ajax submit
        freeform.addOnSubmitCallback(function(formElement, options, isBackButtonPressed) {
          $('#loadmask').show();
          return true;
        });
        // Hide loading message on ajax complete
        freeform.addOnFailedAjaxSubmit(function(formElement, options, isBackButtonPressed) {
          $('#loadmask').hide();
          return true;
        });
        // Do something on a successful ajax submit
        freeform.addOnSuccessfulAjaxSubmit(function(event, form, response) {
          // Redirect the user
          window.location.href = response.returnUrl;
        });
      });
      form.addEventListener("freeform-stripe-styling", function(event) {
        event.detail.base = {
          fontSize: "16px",
          fontFamily: "-apple-system,BlinkMacSystemFont,\"Segoe UI\",Roboto,\"Helvetica Neue\",Arial,sans-serif,\"Apple Color Emoji\",\"Segoe UI Emoji\",\"Segoe UI Symbol\",\"Noto Color Emoji\"",
        }
      })
    }
  </script>
  <div id="loadmask"></div>
  <div class="form__row ">
    <div class="form__field col-ml-12 col-sm-12">
      <label for="form-input-email" class="required form-label">Email</label>
      <input class="form__control form-control" name="email" type="email" id="form-input-email" placeholder="Email" required="">
    </div>
  </div>
  <div class="form__row ">
    <div class="form__field col-ml-12 col-sm-12">
      <label for="form-input-00N700000026RUs" class="required form-label">Request Details</label>
      <textarea id="sf_description" class="form__control form-control" name="00N700000026RUs" rows="2" required="" placeholder="Request Details"></textarea>
    </div>
  </div>
  <div class="form__row ">
    <div class="form__field col-ml-12 col-sm-12 submit-align-left">
      <button class="button button--gradient button button--primary" data-submit-button="1" type="submit" name="form_page_submit" data-original-text="Submit" data-loading-text="null">Submit</button>
    </div>
  </div>
  <script src="https://www.querysurge.com/freeform/plugin.js?v=dbf36844f78f7defc1506758ca9bdff86aa4b9ef"></script>
  <link rel="stylesheet" href="https://www.querysurge.com/freeform/plugin.css?v=ac7ec6ff2a861f36a476cabb10430036545bc25f"><input type="hidden" name="g-recaptcha-response">
</form>

Text Content

 * Features
 * Knowledge Base
 * Pricing
 * Our Customers
 * Resource Center
 * Join Our Team
 * Contact Us
 * Try it Free!
 * 

 * Product Tour
   * What is QuerySurge?
   * Features
   * Roles and Uses
   * Licensing & Pricing
   * QuerySurge Tutorial - Free
   * QuerySurge Customer Portal
   * Video & Slide Library
   * Defects We Find
   * Product Architecture
   * FAQ
 * Challenges
   * Finding Bad Data
   * Automate the Testing Effort
   * Testing Across Platforms
   * Data Analytics & Data Intelligence
   * Data Quality at Speed
   * The DevOps for Data Challenge
   * Improve your Data's Health
 * Solutions
   * Data Warehouse Testing
   * Big Data Testing
   * Data Migration Testing
   * DevOps & Continuous Testing
   * BI Report Testing
   * Enterprise Application / ERP Testing
 * Services & Support
   * Proof-Of-Concept
   * Pilot Project
   * Premium Services
   * Training: Instructor-Led
   * Training : Self-Paced
   * QuerySurge Certification
   * Knowledge Base
   * Support
 * Partners
   * Our Partners
   * Become A Partner
   * Partner Portal
 * Company
   * About Us
   * The QuerySurge Team
   * Our Customers
   * Partners
   * Resource Center
   * Follow Us
   * Contact Us


SUCCESS STORY


ESCHOLAR SELECTS QUERYSURGE TO
AUTOMATE THEIR DATA TESTING EFFORTS



 * Home
 * Case Studies
 * eScholar Selects QuerySurge to Automate their Data Testing Efforts

Contact Us


ESCHOLAR SELECTS QUERYSURGE TO AUTOMATE THEIR DATA TESTING EFFORTS

eScholar connects data, solves problems, and empowers decision making to support
all learners and stakeholders. Educational data processed by eScholar must
adhere to a particular format to ensure accuracy and privacy conditions are met.
Given the amount of data processed, existing manual testing efforts were
impacting delivery times and an automated solution was required to improve
efficiency. After researching several products, eScholar chose QuerySurge
because of its ease of use and structured design.


BACKGROUND

eScholar processes data for EDFacts; a U.S. Department of Education (ED)
initiative to collect, analyze, and promote the use of high-quality,
pre-kindergarten through grade 12 data. This information is collected through
text and Excel files after extraction from a variety of sources. These files are
then transformed and loaded into a data mart for analysis, where they will
ultimately be exported into a format established by EDFacts business rules and
guidance.



CHALLENGES

The eScholar QA team was performing their data validations manually, as many
organizations currently do. Complex transformations based on look-up tables
split individual source data sets into hundreds or sometimes thousands of target
records. Verifying all the transformation logic on large data sets manually
proved time consuming and error prone. To meet delivery deadlines, the team
utilized the sampling method, which could only verify a subset of their total
data set. This method provides a minimum amount of testing coverage and led to
incidents of bad data late in the testing cycle.

QuerySurge was built on a distributed architecture and optimized to execute
tests, perform data compares, and show results quickly – as much as 1,000 times
faster than a manual process.


SOLUTION

QuerySurge provided an automated solution that verified business-critical
processes by confirming datasets went through all transformation logic
accurately. Utilizing QuerySurge’s flat file and Excel drivers allowed the QA
team to write SQL queries against their source files, which could then be
compared to corresponding tables in the database. QueryPairs that were focused
on specific functions in the transformation process pinpointed issues and helped
to reduce defect triage time.




QuerySurge’s data staging feature was used to test all permutations generated by
the various look-up table scenarios. Creating data staging tables directly in
QuerySurge allowed for joining of disparate data sources, such as Excel and flat
files, with the look-up table rules located in the database. This helped the QA
team to quickly identify missing data and logic issues within the source data
files. With over 1,000 QueryPairs (automated tests) and 1,000 staging queries,
the team continues to build out new tests each cycle and incorporates existing
QueryPairs to aid in regression efforts.


BENEFITS

QuerySurge helped eScholar reduce their testing cycle time while also expanding
their data coverage. What used to require two weeks’ worth of effort, now takes
the team three days to verify. The ability to organize their tests within Test
Suites has facilitated the scheduling of test runs in an automated fashion. The
QA team is now able to verify the end-to-end ETL process of loading data into
their data warehouse from a variety of source files while also validating the
EDFacts output files. With QuerySurge, bad data is being captured at an earlier
stage in the testing cycle resulting in a significantly improved data validation
effort.

> After the deployment of QuerySurge as the key Automation tool for all our ETL
> processes, we noticed that the return on investment was quite apparent in the
> efficient utilization of resources and higher quality of data validation and
> report analysis, leading to an overall improved deployment process.
> 
> - Suleena Sharma
> Quality Assurance Lead at eScholar


ABOUT ESCHOLAR:

eScholar connects data, solves problems, and empowers decisions for education
agencies across the country. eScholar’s solutions suite includes statewide
longitudinal data systems, early childhood integrated data systems, unique
identifier systems, matching systems, and more. eScholar award-winning solutions
support the work and education of over 50 million individuals.

https://escholar.com/


ABOUT RTTS & QUERYSURGE:

RTTS, the developer of QuerySurge, is the premier pure-play QA & Testing
organization that specializes in Test Automation. Headquartered in New York,
RTTS has had 1,000+ successful engagements at over 700 corporations since 1996. 

QuerySurge is the smart data testing solution that automates the data validation
and ETL testing of Big Data, Data Warehouses, Business Intelligence Reports and
Enterprise Applications with full DevOps/DataOps functionality for continuous
testing.



 * Trial Options
 * Private Demo
 * Licensing & Pricing
 * Services

LOOKING FOR MORE INFORMATION?

Leave this field blank

Email
Request Details
Submit

Please let us know how we can help you and our team will contact you right away.

Thanks!
the QuerySurge Team

 * LEARN ABOUT QUERYSURGE
   
   * What is QuerySurge?
   * Key Features
   * Product Architecture
   * Licensing & Pricing
   * Resource Center

 * TAKE A TRIAL
   
   * Compare Trial Options
   * 3-Day Trial in the Cloud
   * 15-day Trial Download
   * Request a 30-day PoC
   * Frequently Asked Questions

 * POPULAR LINKS
   
   * Big Data Testing
   * Data Warehouse Testing
   * Defects We Find
   * Automate the Testing Effort
   * Knowledge Base & Community Forums

 * COMPANY
   
   * About RTTS
   * The QuerySurge Team
   * Our Customers
   * Our Partners
   * Privacy Policy
   * Contact Us

 * 
 * 

© 2022 Real-Time Technology Solutions, Inc. All Rights Reserved.
22 West 38th Street, 11th Floor, New York, NY 10018
Email: info@querysurge.com | Phone: 212-240-9050
 * 
 * 
 * 
 * 
 *