DataSources

This page contains information on standalone SoapUI Pro that has been replaced with ReadyAPI.
To try enhanced data-driven testing functionality, feel free to download a ReadyAPI trial.

Overview - DataSources


data-source-window

Option Description
1_snag_evi Properties DataSource properties table
2_snag_evi Toolbar DataSource toolbar
3_snag_evi Configuration DataSource configuration pane
4_snag_evi Data Log Test results when running the DataSource

Properties Table

data-source-properties

Option Description
add_property Add Add new property
remove_property Remove Remove selected property
rename Rename Rename selected property
up_arrow Move Up Move selected property up one row
down_arrow Move Down Move selected property down one row


DataSource Toolbar

data-source-toolbar

Option Description
run Gets the first 10 rows from the configured DataSOurce
clear_properties Clears the Data Log
options Configure this DataSource
DataSource DataSource type
help-browser Online Help

icon-options-dialog Data Source Options

data-source-options

Option Description
Shared Controls whether this DataSource should be shared between threads in a LoadTest
Restart Shared Controls if a shared DataSource can be restarted during a LoadTest
Restart on Run Controls if the DataSource should be restarted every time the TestStep is executed
Preload Preloads the data before running the TestCase
Fail on Empty Fails the DataSource step if no data is available. This option can be used to do data-driven assertions, if for example the SQL query of a JDBC data source contains a WHERE clause that uses property expansion to select data corresponding a previously returned response
GoTo Loop on Empty If the DataSource is empty on initial execution, this option will transfer TestCase execution to the first matching DataSourceLoop step after the DataSource in the TestCase
Start Row The first row in the configured DataSource to use (first row = 0)
End Row The last row in the configured DataSource to use
Trim Trims values retrieved from the DataSource
Entitize Entity values retrieved from the DataSource
Expand Expand property-expansions in DataSource values

DataSource Type

source-type

Option Description
Data Connection Perform queries on any JDBC compatible database (uses shareable project-level connections).
Grid A user-defined table within soapUI. The results will be put in properties, whose order will map the grid columns. E.g. the first column will go into the first Property.
File Reads the contents of a file into the first Property of the Test Step.
XML Fetches data from a property containing XML via XPath.
Groovy A datasource whose output is defined by a Groovy Script. Results go into Properties by using: result["myProperty"] = "This string is the result, which will go into the Property named myProperty".
Excel Reads from an XLS-file. The results will be put in properties, whose order will map the grid columns. E.g. the first column will go into the first Property.
Directory Reads the content of files in a directory. Each iteration will read from a new file. The file contents are stored in the first Test Case Property.
JDBC Perform queries on any JDBC compatible database (uses TestStep specific connections).
JSON Fetches data from a property containing JSON via JPath.


icon-settings Data Connection DataSource Configuration

data-source-dataconnection

Option Description
1_snag_evi PreparedProperties List of properties to be replaced in the SQL query
2_snag_evi Connection Database Connection to be used
3_snag_evi Configure Configures Database Connection settings on project level (Read Reference)
4_snag_evi Test Connection Tests if connection can be established for current configuration(Read Reference)
5_snag_evi Query Editor for SQL query to be executed
6_snag_evi Stored Procedure Indicates if query should be executed as a stored procedure call
7_snag_evi Use a wizard Creates query using a wizard (Read Reference)

options icon Grid DataSource Configuration

data-source-grid

Option Description
1_snag_evi Properties Manually editable list of properties values

options icon File DataSource Configuration

data-source-file

Option Description
1_snag_evi File File to read
2_snag_evi Separator Separator between columns
3_snag_evi Charset File char set to use
4_snag_evi Trim Indicates if values should be trimmed
5_snag_evi Quote values Indicates if values are quoted

options iconXML DataSource Configuration

data-source-xml

Option Description
1_snag_evi Source Step The TestStep containing the XML property to read from (could be another DataSource)
2_snag_evi Source Property The Property containing the XML to use
3_snag_evi Row Xpath The XPath expression to use for selecting the "Rows" for the data
4_snag_evi Column Xpaths One XPath expression for each DataSource property relative to the Row XPath

options iconJSON DataSource Configuration

data-source-json

Option Description
1_snag_evi Source Step The TestStep containing the JSON property to read from (could be another DataSource)
2_snag_evi Source Property The Property containing the JSON to use
3_snag_evi Row Path The JPath expression to use for selecting the "Rows" for the data
4_snag_evi Column JPaths One JPath expression for each DataSource property relative to the Row JPath

options icon Groovy DataSource Configuration

To see an example of a Groovy DataSource, please see Scripting Tips & Tricks.

data-source-groovy
 

Option Description
1_snag_evi Groovy Script Editor The Groovy script must set desired properties in the available "result" object (a StringToStringMap)

options icon Excel DataSource Configuration


data-source-excel

Option Description
1_snag_evi File File to read
2_snag_evi Worksheet Worksheet in file
3_snag_evi Start at Cell A cell to start (for example B5)
4_snag_evi Ignore Empty Selects if raw containing empty data should be skipped

options icon Directory DataSource Configuration

data-source-directory
 

Option Description
1_snag_evi Directory The directory to scan for files
2_snag_evi Filename Filter A standard FileName filter used to narrow down which files to read
3_snag_evi Encoding Encoding to use when reading files

options icon JDBC DataSource Configuration

data-source-jdbc

Option Description
1_snag_evi PreparedProperties List of properties to be replaced in the SQL query
2_snag_evi Driver Driver to be used for a connection
3_snag_evi Connection String Connection string to be used for a connection
4_snag_evi Password Password to be used for a connection
5_snag_evi Configure Configures DatabaseConnection settings on project level (Read Reference)
6_snag_evi Test Connection Tests if connection can be established for current configuration(Read Reference)
7_snag_evi Query Editor for SQL query to be executed
8_snag_evi Stored Procedure Indicates if query should be executed as a stored procedure call
9_snag_evi Use a Wizard Creates query using a wizard (Read Reference)

Back to Top