Verify Secure Data
Last updated
Was this helpful?
Last updated
Was this helpful?
It is prebuilt action, located under @Generic element, instructs the Avo Assure to verify data from database table with Input password in encrypted form and store result in dynamic variable.
Note: DB password must be encrypted with AES encryption.
Input Value: <DB IP/instance name/DB file path>; <DB port>; <DB username>; <Encrypted password>; <DB name>; <Query>; <DB Number>; <file path to verify data>; <Sheet Name>; <collection/ warehouse>(Optional); <querytype/ schema>(Optional)
<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.
<Encrypted Password> (Required)
The required DB password must be encrypted with AES encryption
<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
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:
<Dynamic Variable> (Optional)
This variable holds the data, that has been validated from the database.
<Dynamic Variable> (Required)
This variable stores the status as True or False
Example:
Verify database data against an Excel sheet
​The Verify Data Secure(DB) action utilizes input values such as database connection details, username, encrypted password, 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 specified Excel sheet. Stores the result in the {Verify Data} variable. The verification result is stored in the {Status} variable with the following values:
True – if the data matches
False – if the data does not match
