Run Query Securely

It is prebuilt action in Avo Assure which is located under @Generic element category. It instructs Avo Assure Client to run the specified query from the input with specified DB with Password in Encrypted text.

Note: DB password must be encrypted with AES encryption.

Syntax

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

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

Use case/Example

Scenario:

Consider a scenario where user is testing a financial services application and needs to ensure that only authorized users can execute queries. For this scenario Run Query Securely action used by Avo Assure. In query execution, sensitive data is encrypted during transfer. It ensures that secure logging and monitoring of data access.

Expected Result

The Run Query Securely action needs to run query with encrypted password.

Output

The Run Query Securely action performed on specified DB.