Verify Data

This is prebuilt action, located under the @Generic element, instructs Avo Assure to verify Data from database table with input value and save the result in dynamic variable.

Syntax

Input value: <DB IP/instance name/DB file path>;<DB port>;<DB username>;<DB password>;<DB name>; <Query>;<DB Number>;<file path to verify data>;<Sheet Name>;<collection/ warehouse>(Optional); <querytype/schema>(Optional)

Argument
Description

<DB IP/instance name/DB file path> (Required)

Specifies the database server location, instance identifier, or database file path

<DB port> (Required)

The port number used to connect to the database.

<DB username> (Required)

The username credential for database access.

<DB Password> (Required)

The password credential for database access.

<DB name> (Required)

Required name of the database to connect.

<Query> (Required)

Required SQL or Non SQL query to be executed.

<DB Number> (Required)

Database Number serves as a unique identifier for a specific database connection.

<File Path to Verify Data> (Required)

the required path to the external file (e.g., Excel)

<Sheet Name> (Required)

The specific sheet within the Excel file that holds the expected data.

<collection/warehouse> (Optional)

Required the specific data container within the database to target.

<querytype/schema> (Optional)

Defines the nature of the query or specifies the database schema to be used.

Click below link to get more information about Supported Database in Avo Assure

Supported Technologies

Output Value:

Argument
Description

<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)

This variable stores the status as True or False

Example

Verify database data against an Excel sheet

The Verify Data(DB) action uses the values from the Input Value column, including DB connection details, a query, and the file path with sheet name of the expected data. It connects to the database, executes the query, and compares the result with the data in the Excel sheet. Stores the result in the {Verify Data} variable with the following values:

  • True – if the data matches

  • False – if the data does not match

Last updated

Was this helpful?