Get Data Securely

This is prebuilt action, located under the @Generic element, instructs Avo Assure to retrieve data from database table specified in input and store result in dynamic variable with Input password in encrypted text.

Note: DB password must be encrypted with AES encryption.

Syntax

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

Argument	Description
<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 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.
<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

Supported Technologies

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:

Argument	Description
<Dynamic Variable> (Required)	This variable holds secure data which we fetched from the database.​
<Dynamic Variable> (Optional)	This variable stores the status as True or False

Example: Retrieve data from a database using the Get Data Securely Action

The Get Data Securely(DB) action takes the database connection details and a query from the Input Value column. It connects to the specified database (using parameters like DB IP, port, username and Encrypted Password etc.), executes the query, and stores the result in the {DB_Data} variable. The execution status is stores in the {Status} variable, with the following possible values:

• True – if data is successfully retrieved

• False – if the data retrieval fails or no records are returned

Note: If user want to display the stored data then they can use display variable value action and in the input value column user can give value in array format {Variable name [row number][Column number]}