DataDrivenTest Download Trial - Free 14 day evaluation

DataSources

PDF Print E-mail
User Rating:  / 43
Rate this article: PoorBest 

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