Export Data
Last updated
Was this helpful?
Last updated
Was this helpful?
This is prebuilt action, located under the @Generic element, instructs Avo Assure to execute a specified query from the input and export the result to an external file and save the result in dynamic variable.
Input Value: <DB IP/instance name/DB file path>;<DB port>;<DB username>;<DB 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 Password> (Required)
The password credential for database access.
<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 (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, 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.
