Verify Secure Data

It is prebuilt action in Avo Assure which is located under @Generic element category. It instructs the Avo Assure Client to verify data from database table with Input password in encrypted form.

Note: DB password must be encrypted with AES encryption.

Syntax

Input: <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)

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

Use case/Example

Scenario:

Consider a scenario where user enters their username and password to log into an online banking application. For this scenario Verify Secure Data action used by Avo Assure. Application receives encrypted password and compares it with the stored encryption data in the database to keep the data secure. It ensures that if credentials match, the user gains access or otherwise, an error is returned.

Expected Result

The Verify Secure Data action needs to verify data securely in specified databases.

Output

The Verify Secure Data action performed and saves status in the {Result} output variable.