6. Set the Data Sink Test Step

To begin, you need to simulate a request and get some sample responses. ReadyAPI will use the data to automatically configure assertion properties.

Switch to the test case editor and click on the editor toolbar:

1. Open the test case and add the data sink test step.

   

   Click the image to enlarge it.

2. To store data in the data sink, you have to place the data sink after the request. The data source loop, in its turn, should be placed after both these steps in order for these to work properly in every iteration of the loop.

   To move the test step, drag it to the needed place in the Navigator:

   

   Click the image to enlarge it.

3. Set the data sink type to JDBC.

4. The Data Sink test step can use a project-wide JDBC connection or a specific connection for this test case.

   In this tutorial, we will use a test case-specific connection. Click Configure to set up the connection:

   

   Click the image to enlarge it.

5. The Database configuration dialog appears.

   First, you need to select the driver. Select the pre-configured MySQL driver:

   

   Click the image to enlarge it.

6. Specify the remaining settings you use to access your MySQL server. In the Database field specify the datasink database:

   

   Click the image to enlarge it.

7. Click Test connection to verify whether the settings are correct.

8. After you finish the configuration, ReadyAPI will suggest that you build the query. Click Yes:

   

9. The Create Query dialog appears.

   Here, specify the tutorial table and check the id and team columns.

   

   Click the image to enlarge it.

10. Enable the Add Properties property to add the property you need automatically.

11. Click OK.

ReadyAPI creates the SQL query and the properties.

Click the image to enlarge it.