7. Set the Data Sink Test Step

To save the data to the database, you need to create the data sink test step.

1. Double-click the test case to open it for editing.

2. Add the data sink test step.

   

   Click the image to enlarge it.

   For the request 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.

3. Set the data sink type to JDBC.

   

   Click the image to enlarge it.

4. Click Configure.

5. The Database configuration dialog appears. You need to use it to specify database connection.

   Select the MySQL driver.

6. Specify settings you use to access your MySQL server.

   

   Click the image to enlarge it.

7. In the Database field, specify the sample test database.

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

9. Click OK.

10. After you finish the configuration, ReadyAPI will suggest that you build the query.

    Click OK.

11. The Create Query dialog appears.

    Here, specify the tutorial table and check the lat and lng columns.

    

    Click the image to enlarge it.

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

13. Click OK.

ReadyAPI creates the SQL query and the properties.

Click the image to enlarge it.

Now, you can transfer the data.

Prev          Next

See Also

Store Data