Skip to end of metadata
Go to start of metadata

Toolbar

ButtonAction
New - Create a new Dataset
Create Authentication Dataset
Import a data source as a new Dataset
Edit the selected Dataset
Update the dataset from its source
Export the Dataset to a .csv file
Delete the selected Dataset


Help Boxes

 Datasets

A Datasets is a predefined set of records.
Datasets are used in request parameters to:
- retrieve a value from the Datasets,
- assigned the value to a variable and
- replace a recorded value in the request
with the variable.

The variable name is
.< column name>.

See Also:
Datasets

Dataset Commands

To import data sets from Excel, a text file or an

SQL Server query, select the source on the left

and fill out the corresponding form.


Click Preview to see a preview of the dataset, and

when you are ready to import the dataset, give it

a unique name and click Import.

See Also:
Datasets

Add/Edit Dataset StructureTo add a field, enter the field name and click
"Add Field". Double-click the field to rename it

To reposition, rename or delete a selected field,
use the Up, Down, Rename or Remove buttons.

To create or rename a Dataset, enter a
one-word Dataset name.

See Also:
Datasets
Import Datasets

To import data sets from Excel, a text file or an

SQL Server query, select the source on the left

and fill out the corresponding form.


Click Preview to see a preview of the dataset, and

when you are ready to import the dataset, give it

a unique name and click Import.


See Also:

Importing Datasets


Dataset Properties

Limit Dataset?Select Yes to allocate a range of the records to a test run. The default is No when all records are available to the test run.
Start RecordThe first record available for a test.
Record CountThe number of dataset records allocated for a test starting from the Start Record. If the value is 0 then all records will be available.
Auto-advance records?Select Yes to auto-advance the Start Record by Record Count after every test run. Use this feature to automatically allocate a new range of records for every subsequent test run. The default is No. Note: If the end of the dataset is reached, the size of the last range can be smaller than Record Count. The next range will start from the first record.
Trim SpacesSelect Yes to remove leading and trailing white spaces in parameter values bound to the dataset (default). Select No to use dataset values as is.

Select default databinding mode

Select a databinding mode for all parameters using this dataset. It can be overwritten in a parameter.

Hide advanced databinding selection

Select Yes to use the default databinding mode for parameters using this dataset. Select No to manually select databinding mode when creating parameters.

Data Source TypeSelect data source type from the drop-down
Text File PathThe full path of the text file
DelimiterA single character that delimits columns in the text file
Are Column Headings provided?Select Yes if the first line in the text file contains column headings?
Excel Connection StringExcel file path or connection string
DatasheetDatasheet name in the Excel File
Connection stringThe SQL Server Connection string
Query StringSQL select statement that returns data to the data set

Auto-sync Dataset

By default, a dataset is not synchronized with the source before running a test (Never). Select Try to attempt auto-sync before running the test. Select Always to run the test only after successful Auto-sync.
Agent-binding columnA dataset row can be agent-bound. The bound row will only be consumed by the agent that is specified in the column designated for agent-binding. Enter the name of the agent-binding column. Dataset rows that have an empty value in the agent-binding column will be consumed by all agents.



  • No labels