Data-Driven Testing

Combine automated tests with a data source to test faster and more accurately.

Download Trial

Accelerate testing

Complete more tests in less time with automated procedures and test data.

Increase accuracy

Ensure that inputs are handled correctly and compared to the correct expected results.

Reduce test maintenance

Easily add or change test scenarios just by modifying the test data.

Maximize resources

Execute tests during off-hours, free manual testers for exploratory testing.

Introduction to data-driven testing

Data-driven testing separates test procedures from test data, to increase efficiency and reduce maintenance. An automated test consists of two parts: the procedure, which is a set of steps to perform; and the data to use in the test. For example, a test for a login dialog would include steps to open the application, enter the username, enter the password, click the Submit button, and check that the application responded correctly. The data for this test would include a username, password, and the expected results of the test, such as a successful login or an appropriate error message. Typically, a login test would be repeated for multiple combinations of valid and invalid username and passwords. In data-driven testing, the test data is stored in a table separate from the test procedure. During a test run, the test procedure is performed once for each row in the data table. Thus, the data in the table can be said to “drive” the execution of the test.

What is a data-driven testing framework?

Build automated test cases and connect them to a data source with a data-driven testing framework.
With a data-driven testing framework, you can create an automated test and connect it to a data source using one or more variables. In the example of a login process, the username, password, and expected result can all be configured as variables. When the test executes, the variables are replaced by values from the data source. In Ranorex Studio, your data source could be a simple internal table, a CSV file, a Microsoft Excel spreadsheet, or a SQL database connector. Using the SQL database connector, you could execute your automated tests against a test database, or even your full production database.

What are the benefits of data-driven testing?

Reduced test maintenance

Instead of redundant test cases that each check a particular set of data values, with data-driven testing, you have just a single test case to maintain. Easily add or remove scenarios by changing the test data without affecting the test procedure.

Faster test execution

A data-driven automated testing framework can execute a large volume of tests far more rapidly than manual testing, especially for repetitive test cases that cover positive and negative test data values, or corner, edge, and boundary cases.

Increased accuracy

Even the most diligent manual tester can make typing errors when entering large amounts of data and performing repetitive tasks. With automated data-driven testing, the exact data values specified in the data source are used to execute the test case.

Improved use of resources

Automated data-driven test cases can execute during off-hours, when test machines would otherwise be idle. With manual testers freed from entering repetitive test data, they can focus on more challenging exploratory and user experience testing.

Better storage of test data

Because test procedures and data are maintained separately, you can store test data in a location accessible to everyone on the team, whether that’s an Excel spreadsheet, CSV file or database file. This makes the data easier to share, re-use, backup, and maintain.

Use for more than just testing

In addition to functional testing, you can use data-driven procedures to simulate data entry for load and performance testing. It’s also possible to use a data-driven test case to populate a test or even a production database.

Watch Our On-Demand Webinar

Mastering Data-Driven Testing with Ranorex Studio: Maximize the benefit of your test cases by linking them to data sources such as spreadsheets or SQL databases.

View now

“The large amount of test data that had to be entered manually before over and over again can now be entered easily by Ranorex. This saves a lot of time for other testing efforts. Also, since the automation covers a large area of the software in a short time, bugs are discovered much earlier.“

QA Engineer, Large Enterprise Computer Software Company

Why choose Ranorex Studio for data-driven testing

Improve test efficiency and coverage with Ranorex Studio test automation features.

Supported data sources

You aren’t limited to CSV files for your data-driven testing. Ranorex Studio also supports simple internal data tables, Microsoft Excel spreadsheets, and SQL database connectors. Use a single source or combine sources for maximum flexibility.

Powerful automation

Rapidly build tests with tools for codeless automation, or use the full IDE. Ranorex Studio automatically identifies UI elements and stores them as objects in an object repository. In addition to input fields, the repository enables data-driven testing for controls such as radio buttons and checkboxes.

Easy editing

Editing a test procedure is easy with the Ranorex Studio action editor. Use drop-down menus make to create variables that connect repository objects to your data source(s). Point and click to manually bind test variables to input values, or allow the auto-bind function to do it for you.

Sophisticated validation

Validations are essential to verify the correct functionality of your application. Easily build complex data-driven validations while recording tests. Compare images as well as text, all without writing a single line of code. Mask input and validation values as desired, to keep them from appearing in the test report.

Remote testing

Accelerate testing and increase productivity by running your tests in parallel using a Ranorex Agent. Or, use the built-in Selenium WebDriver integration to distribute tests on a Selenium Grid, either locally or in the cloud. Beginning with Release 8.3, save even more time with our installation-free remote test execution.

Full control with conditions

Manage the behavior of automated tests with conditions. Each condition can include up to 10 rules to manage decisions such as whether to perform a test based on the current data value. If a test fails, a rule can control whether to continue with the next data value, jump to the next test case, or stop the test run.

Trusted by over 4000 companies worldwide

Download free 30-day trial

Explore the benefits of data-driven testing with Ranorex Studio free for 30 days

Data-driven testing in Selenium WebDriver

Selenium WebDiver integration in Ranorex Studio simplifies data-driven cross-browser and cross-platform testing
Designing a Selenium WebDriver framework for data-driven testing is technically challenging, and that doesn’t include the effort necessary to automate and execute tests. Increase your efficiency by using Ranorex Studio to easily configure data-driven testing for a web application in a single browser. Define a variable for the browser, and you can use a data table to drive your cross-browser testing. Ranorex Studio’s built-in Selenium WebDriver integration allows you to execute your automated tests on all Selenium-supported platforms and browsers, including Linux and macOS. Then, save even more time by executing your cross-browser tests in parallel. Simply use the Ranorex Parallel Runner to execute your test suite across multiple capability sets on a Selenium Grid through a WebDriver endpoint in parallel.

Ranorex Studio recognized in Test Automation based on user reviews

Outstanding customer satisfaction

Reviews from satisfied users help make Ranorex Studio a leader in the Summer 2019 G2 Crowd Grid for Test Automation Software

The G2 Crowd Grid for Test Automation Software identifies leading solutions based on market presence and customer satisfaction. To determine market presence, G2 Crowd uses a combination of 15 metrics about a vendor and product such as the number of employees, web and social presence, and growth. The customer satisfaction rating is based on an analysis of reviews submitted by real, verified users.

An overall customer satisfaction rating of 91% contributed to Ranorex Studio's position as a leader in the G2 Crowd Grid. Ranorex Studio also received high marks in areas such as ROI, ease of use, and ease of implementation. For more independently-verified research and reviews, visit the Ranorex Studio page at G2 Crowd,TechValidate, or Capterra.

G2 Crowd Grid^® for Test Automation Software

Download free 30-day trial

Start test automation now. No credit card required.