Get Data Securely
Last updated
Was this helpful?
Last updated
Was this helpful?
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.
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)
<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
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> (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]}
