Store Data

This tutorial explains how to save the data to an external MySQL database by using the data sink test step.

Sometimes, you may need to store data from a web service in a database. For example, you can use this data later as a source for other tests or web service requests.

You can get the data from a database by using the data source test step. You may have already seen it in the Functional Data-Driven Test tutorial.

You can easily store data in the database with the data sink test step.

In this tutorial

  1. Preparation

    1. Download a sample database and ReadyAPI project.

    2. Install the MySQL server.

    3. Import the sample database.

    4. Install the JDBC driver.

      Note

      The new MSSQL JDBC driver, introduced in ReadyAPI 3.62.0, enforces encryption by default. In case of connection issues due to forced SSL communication, update the MSSQL connection definition with trustServerCertificate=true. (This property is automatically included in every new connection definition.) Alternatively, you may add encrypt=false, but this is not recommended as it weakens security.

  2. Save data to database

    1. Import the project.

    2. Set the data sink test step.

    3. Transfer the data.

    4. Run the project.

Next

See Also

In this section:
© 2025
Publication date: