Export Data Securely

It is prebuilt action in Avo Assure which is located under @Generic element category. It instructs Avo Assure Client to execute the specified query from the input and export the results to external files, with the password provided as input 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: <File Path>;<Sheet name>(Optional)

Note:

• File path: The user specifies the file location where they want to export the data.

• Sheet name: The user gives sheet name of an excel sheet.

Use case/Example

Scenario

Consider a scenario where user is testing feature of web Application. For this scenario Export Data Securely action used by Avo Assure. It ensures that sensitive information is protected when exporting data from application. It ensures that only authorized users can perform the export and the data is encrypted during transfer.

Expected Result

The Export Data securely action needs to export data securely from DB to another external files.

Output

The Export Data securely action performed and export results in excel sheet (Files)