Data Management Actions

Data Management actions are responsible for gathering and / or manipulating data. Each action can be used to fulfil a unique role within a test: 

  • They can prepare tests by ensuring the expected results are up to date.
  • Clean-up an environment before or after a test execution.
  • Summarize data in preparation for asserts.
  • Generate test data for usage within a test.

 

Data Generation

Data Generation

IconDescription
SentryOne Test Data Generation

The Data Generation action creates data using a BI xPress Data Generation solution. 

SentryOne Test Data Generation Properties

Required Assets

  • Connection
  • Data Generation Solution

Once the editor has loaded, you need to input the following properties:

AssetDescription
Connection Asset
The connection string that's used during data generation.
Data Generation Solution Asset
The property stores the location to the BI xPress Data Generation solution.
Execute Query Command

Execute Query Command

IconDescription
SentryOne Test Execute Query Command

The Execute Query Command action takes the specified query command and runs it against the desired location. This element uses various assets to accomplish filling in the required information.

Execute Query Command Editor

SentryOne Test Execute Query Command Properties

FunctionDescription
Connection AssetDetermines the database that the command is run against.
Query AssetThe query command you want to execute.
TimeoutControls how long the command runs before failing with a timeout.
Execute Query Grid

Execute Query Grid

IconDescription
SentryOne Test Execute Query Grid

The Execute Query Grid action runs a query against a connection, then stores the information gathered into the resource key defined in the element's editor. This element is used for retrieving a grid of information to be compared in the assertion step. If the query pulls multiple grids, you can specify which grid to use using the Result set index. The default is zero, which is the first result set pulled.

Execute Query Grid Editor

SentryOne TestExecute Query Grid Properties

FunctionDescription
Connection AssetThe connection to the data source.
Low memory modeToggles whether the grid is stored on disk or in memory. 
Query AssetThe query that runs against the connection.
Result Set IndexSelects the result set to use if multiple sets are returned from the query.
TimeoutControls how long the query runs before failing with a timeout.
Execute Query Scalar

Execute Query Scalar

IconDescription
SentryOne Test Execute Query ScalarThe Execute Query Scalar action retrieves a single piece of data to compare and then store in the resource key defined in the element's editor.

Execute Query Scalar Editor

SentryOne Test Execute Query Scalar Properties

FunctionDescription
Connection AssetThe connection to use for the query.
Query AssetThe query that runs against the connection.
Resource KeyThe resource key where the data is stored from this element.
TimeoutControls how long the query runs before failing with a timeout.
Extract Grid Checksum

Extract Grid Checksum

IconDescription
SentryOne Extract Grid ChecksumThe Extract Grid Checksum action checks for changes in a grid set. This action would be used in conjunction with an integer compare assert. The grid checksum takes in a grid, and then returns out an integer that represents its current state. This integer state can then be compared to another integer to see if there has been any changes to the structure or content of the grid.

Extract Grid Checksum 

SentryOne Test Extract Grid Checksum Properties

FunctionDescription
Grid ResourceThe grid where the checksum is extracted.
Target Resource KeyThe name given to the result in the Test Resources. This key is used when populating an assert.
Filter Grid

Filter Grid

IconDescription
SentryOne Test Filter GridThe Filter Grid action filters an already loaded grid. If possible, avoid using this action. For example if the grid being loaded comes from an Execute Query Grid action, then modifying the query to perform the filtering at the source performs better. It's not always possible to run sufficient filtering at the source, and this is why the filter grid action is present.

Filter Grid Editor

SentryOne Test Filter Grid Element Editor

FunctionDescription
Grid to filterThe grid that you want to filter.
Filter expressionThe filter expression to use. For more information about filter expressions, please see the filtering topic.
Get Grid Row Count

Get Grid Row Count

IconDescription
SentryOne Test Get Grid Row CountThe Get Grid Row Count action takes in a grid and returns the amount of rows in the grid.

Get Grid Row Count Editor

SentryOne Test Get Grid Row Count Properties

FunctionDescription
GridThe grid where the row count is extracted.
Resource keyThe name given to the result stored in the Test Resources.
Load Excel Cell Scalar

Load Excel Scalar

IconDescription

Loads a selected excel cell file from a connection asset.

SentryOne Test Load Excel Cell Scalar Properties

FunctionDescription
Excel Cell ReferenceString reference to the excel cell in the following format :
  • "SheetName!A1"
Expected typeThe type of value expected in the cell.
File reference assetThe file reference or content specifying the data to load.
Refresh data sources before loadingRefreshes all data sources and power pivot tables in the excel file before loading.
Resource KeyName of the resource key that stores the results.
Load Excel Data Grid

Load Excel Data Grid

IconDescription

Loads a selected excel data grid from a connection asset.

SentryOne Test Load Excel Data Grid Element Editor

FunctionDescription
Flat dataThe Delimited File Reference Asset, Delimited Content Asset or Fixed Width File Reference Asset that contains the information about the file to load.
Resource KeyName of the resource key that stores the results.
Low memory modeIf true, then the grid is loaded in low memory mode - meaning that the data is stored in a temporary file.
Refresh Data SourcesRefreshes all data sources in the excel file before loading.
Edit FilterOpens the filtering window that allows you to apply a SQL-like filter expression to select data.
Selected ColumnsThis area allows you to select the columns that are loaded from the Excel data.
Load Flat File Data

Load Flat File Data

IconDescription
SentryOne Test Load Flat File Data

The Load Flat File Data action loads flat file data into a resource key for comparison and validation.

The Load Flat File Data action loads data from the following types of assets:

  • Delimited File Reference
  • Delimited Content
  • Fixed Width File Reference

Load Flat File Data Editor

SentryOne Test Load Flat File Data Element Editor

FunctionDescription
Flat dataThe Delimited File Reference Asset, Delimited Content Asset or Fixed Width File Reference Asset that contains the information about the file to load.
Resource KeyName of the resource key that stores the results.
Low memory modeIf true, then the grid is loaded in low memory mode - meaning that the data is stored in a temporary file.
Edit FilterOpens the filtering window that allows you to apply a SQL-like filter expression to select data.
Selected columnsThis area allows you to select the columns that are loaded from the flat file data.
Load Grid From Asset

Load Grid From Asset

IconDescription
SentryOne Test Load Grid From AssetThe Load Grid from Asset action loads the grid defined by a grid collection asset into a resource key for comparison.

Load Grid Editor

SentryOne Test Load Grid from Asset Properties

FunctionDescription
AssetThe Grid Collection asset to use.
Grid IndexThe index of the grid that loads into the resource key. The default value is zero.
Resource KeyName of the resource key that stores the results.
Load Tabular File Table

Load Tabular File Table

IconDescription

Loads a selected tabular file table from a connection asset.

SentryOne Test Load Tabular File Table Element Editor

FunctionDescription
Data Package FileThe asset where you want to retrieve a  test run result.
BrowseSearch for a desired data package file.
Resource PathThe path to the resource from the data package file.
Target Resource KeyName of the resource key that stores the results.
Table Row Count

Table Row Count

IconDescription

Calculates the number of rows in a table from a selected connection asset.

SentryOne Test Table Row Count Element Editor

FunctionDescription
ConnectionThe connection string for your desired table.
TableThe selected table from the connection string.
Resource KeyName of the resource key that stores the results.