To have the test case repeat the test step for all the data, you need to make sure it loops at least once.
For now, you have a test case with a request, which uses the JDBC data source through a property expansion.
Click the image to enlarge it.
At this point, you will not get results after running the request.
Click the image to enlarge it.
This happens, because the request did not fetch data from the source. To solve that problem, you need to add a data source loop which runs at least once.
-
Double-click the test case in the navigator to open it. The Test Steps tab shows the test steps in the test case.
Click the image to enlarge it.
-
Click
-
Enter a name for the loop.
-
Click OK.
-
The data source loop will appear in the test case.
Click the image to enlarge it.
The Data Source Loop test step will not work if placed before the request within the test case, so make sure to place it after the request. Now, you need to configure it with the correct data source, and the request to use that source.
Double-click the data source loop.
-
Select DataSource in the DataSource Step drop-down list.
Select Request 1 in the Target Step drop-down list.
Click OK.
-
The loop updates.
Click the image to enlarge it.
-
Now, you can run the test case. Click
.
Click the image to enlarge it.
Requests’ results are available in the Transaction Log.
Click the image to enlarge it.
| Note: | You can now also run the Request step, since the loop tells ReadyAPI where to get the data and use it. |
In this tutorial, you have learned how to read data from an MS SQL Express database and use the jTDS driver and dll. This approach is similar for full MS SQL databases and other drivers.