SoapUI Excel DataSource Definition & DataSourceLoop Usage
Comprehensive test suites require varying test datasets to cover many cases each of which can be the reason of a bug, in advance. In order to eliminate the possibility of unexpected behaviours of target application, using prepared large portion of test datasets in test cases are essential in software testing. However, preparing a test case for each of different test data might be troublesome to developer. Thus, parametrizing the inputs and using datasets iteratively to fulfill the inputs is the answer to problem. In soapUI, datasources can be added to test cases to retrieve test datasets from databases (Oracle, MySQL, Derby, SqlServer, etc.), excel files (*.xls) or files (*.xml, *.txt). Below, in SoapUI test suites, I shortly intended to present: how to use excel files as a datasource how to iterate on datasets of datasource with DataSourceLoops how to parametrize your test datas to your test cases' inputs In your soapUI project, add a datasource to your test steps then defi