Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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)
Click below link to get more information about Supported Database in Avo Assure
Note:
When using a Non-SQL Query to run a specific action, the user must provide either the collection name or the warehouse name in the input syntax.
Output Value:
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
<Dynamic Variable>(Optional);<Dynamic Variable>(Optional)
This variable stores the status as True or False
<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.
