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.
-
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.
-
Open the Configuration Panel.
-
To configure the connection string, click Configure.
-
In the Database Configuration dialog, select the MySQL JDBC driver.
-
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.
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.
-
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.
-
On the Settings tab, set End Row to
5
. -
Click OK.
Now you can use the data source data in your request.