Export Data Securely
Last updated
Was this helpful?
Last updated
Was this helpful?
It is prebuilt action, located under @Generic element, instructs Avo Assure to execute the specified query from the input and export the results to external files, with the password provided as input in encrypted text, ensuring secure access.
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:
<File Path> (Required)
The user specifies the file location where they want to export the data.
<Sheet name>
(Optional)
The user gives sheet name of an excel sheet.
Example
Export data from a database to an Excel file
The Export Data Securely (DB) action connects to a database, executes a specified query, and saves the resulting data into an external Excel file. Users provide details such as the DB IP, port, username, encrypted password, DB name, query, and DB number in the input, while the output includes the Excel file path and sheet name where the data is exported.
