MySQL Databases as Data Sources

Applies to ReadyAPI 3.8, last modified on February 16, 2022

One of the most time-consuming tasks when testing the functionality of a web service is iterating through a great number of data sets. ReadyAPI helps you solve this issue - you can use Data Source test steps that allow you to connect to a data source and provide data to a web service.

This tutorial describes how to use a MySQL server as a data source.

In this tutorial, you will use a MySQL server with the standard MySQL sample database and the Data Science Toolkit geocoding web service.

In this tutorial

This tutorial includes the following steps:

  1. Preparation

    1. Install a MySQL server.

    2. Install a MySQL sample database.

    3. Install a JDBC driver.

  2. Implementation

    1. Create a REST project.

    2. Get data from the MySQL database.

    3. Use the data in a request.

    4. Add a data source loop.

    5. Run the test case.

Use the finished sample project to learn how to perform data-driven testing using MySQL database as a data source.

Next

See Also

Data-Driven Testing Tutorials

Highlight search results