Run Query Securely
Last updated
Was this helpful?
Last updated
Was this helpful?
It is prebuilt action, located under @Generic element, instructs Avo Assure to run the specified query from the input with specified DB with Password in Encrypted text and save the result in dynamic variable.
Note: DB password must be encrypted with AES encryption.
Input Value: <DB IP/instance name/DB file path>; <DB port>; <DB username>; <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.
<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 stores the outcome of the operation
<Dynamic Variable> (Optional)
This variable stores the status as True or False
Example:
Execute Database Query
The Run Query Securely (DB) action utilizes values from the Input Value column, including database connection details, username, encrypted password, and a query. It establishes a connection to the specified database and executes the provided query. The result of the query is stores in {Outcome} Variable, while the execution status is saved in the {Status} variable with the following possible values:
True – if the query runs successfully
False – if the query execution fails
