Now you have a test case and a project, so you can create the Data Source test step.
-
Select your new test case.
-
Add the Data Source test step.
Click the image to enlarge it.
-
ReadyAPI will suggest that you add the Data Source Loop test step. In this tutorial, you will add it manually later, so click No.
-
Open the Data Source test step and select the JDBC data source type.
Click the image to enlarge it.
-
Open the Configuration Panel.
-
To configure the connection string, click Configure.
Click the image to enlarge it.
-
In the Database Configuration dialog, select the MySQL JDBC driver.
Click the image to enlarge it.
-
Specify the settings of your MySQL Server: the host, port and so on.
-
In the Database field, specify the sample MySQL database.
-
Click Test connection to verify the settings are correct.
-
Click Yes in the Change Connection Properties dialog.
-
The Build SQL Query wizard will appear.
Click the image to enlarge it.
Select the city table in the list of tables and check the Name column in the list of table columns.
-
Click OK to add your new query to the data source configuration. This will create a property value.
Click the image to enlarge it.
-
For this tutorial, you need to set a limit for the amount of data you will get from the database.
Click
in the data source toolbar at the top.
Click the image to enlarge it.
-
On the Settings tab, set End Row to
5.
Click the image to enlarge it.
-
Click OK.
Now you can use the data source data in your request.