To save the data to the database, you need to create the data sink test step.
-
Double-click the test case to open it for editing.
-
Add the data sink test step.
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. -
Set the data sink type to JDBC.
-
Click Configure.
-
The Database configuration dialog appears. You need to use it to specify database connection.
Select the MySQL driver.
-
Specify settings you use to access your MySQL server.
-
In the Database field, specify the sample test database.
-
Click Test connection to verify whether the settings are correct.
-
Click OK.
-
After you finish the configuration, ReadyAPI will suggest that you build the query.
Click OK.
-
The Create Query dialog appears.
Here, specify the tutorial table and check the lat and lng columns.
-
Enable the Add Properties property to add the property you need automatically.
-
Click OK.
ReadyAPI creates the SQL query and the properties.
Now, you can transfer the data.