DataSinks

Overview - DataSinks

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.

data-sink-window

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

Properties Table

data-sink-properties

Option Description
add_property Add Add new property
remove_property Remove Remove selected property
up_arrow Move Up Rename selected property
down_arrow Move Down Move selected property up one row
arrow_down Sort Sorts properties alphabetically
clear_properties Clear Clears all curent property values
load_properties Load Loads property values from an external file
Save Saves current property values to a file

DataSink Toolbar

data-sink-toolbar

Option Description
run Writes the current property values to the configured DataSink
clear_properties Clears the Data Log
options Sets options for this DataSink
DataSink DataSink type
help-browser Online Help

icon-options-dialog DataSink Options
data-sink-options

Option Description
Shared Controls whether this DataSink should be shared between threads in a LoadTest

DataSink Type
data-sink-type

Option Description
SubReport Writes property values to a subreport that can be used for custom reporting (see The Report DataSink)
Data Connection Writes property values to a database via a Prepared SQL statement, uses a DB Connection defined at the Project Level
File Writes property values to a CSV file
Property Writes and aggregates property values to a new result property (see example in Saving Data from your Tests)
Groovy Invokes a script for handling property values
Excel Writes property values to an XLS file
JDBC Writes property values to a database via a Prepared SQL statement, uses JDBC

icon-settings-tab SubReport DataSink Configuration
data-sink-subreport

The SubReport DataSink collects data and exposes it to generated reports

icon-settings-tab Data Connection DataSink Configuration

data-sink-dataconnection

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

icon-settings-tab File DataSink Configuration

data-sink-file

Option Description
1_snag_evi File File to read
2_snag_evi Separator Separator between columns
3_snag_evi Trim Indicates if values should be trimmed
4_snag_evi Append Indicates if properties should be appended to existing file

icon-settings-tab Property DataSink Configuration

data-sink-property

Option Description
1_snag_evi Result Property The target property in this TestStep to write to (must be defined!)
2_snag_evi Prefix The prefix for the property value
3_snag_evi Content The suffix for the property value
4_snag_evi Suffix One XPath expression for each DataSource property relative to the Row XPath

icon-settings-tab Groovy DataSink Configuration

data-sink-groovy

This step allows any kind of DataSink to be created for a DataSink Step. Available context variables are:

Option Description
"context" The current TestRunContext for storing context-specific values
"properties" A Map containing the current property values
"testRunner" The current TestRunner object
"log" A log for logging

To see an example of how to implement a Groovy DataSink, please see Scripting Tips & Tricks.

icon-settings-tab Excel DataSink Configuration

data-sink-excel

Option Description
1_snag_evi File The source excel file to use as a template for adding data
2_snag_evi Out File The target excel file to write. If not specified the data is written to the source file
3_snag_evi Worksheet Worksheet in file
4_snag_evi Start at Cell A cell to start (for example B5)
5_snag_evi (Re)Generate Properties Use a wizard to add/remove properties

icon-settings-tab JDBC DataSink Configuration
data-sink-jdbc

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

Back to Top