Database Operations

Database Actions in Avo Assure enable you to interact with various Databases during test execution. This actions allow connecting to the configured Database, executing queries, retrieving results, and validating data directly from the application under test. By using Database Actions, you can ensure data accuracy, verify backend operations, and perform end-to-end validation across UI and Database layers.

Here are the categories under Database Actions:

Actions	Descritpion
Get DataDB	The Get DataDB Action fetches specific data from the database.
Verify DataDB	The Verify DataDB Action compares the expected data from a local Excel file with the actual data in the database.
Export DataDB	The Export DataDB Action fetches data from the database and exports it into an Excel file.
Run QueryDB	The Run QueryDB Action allows executing an SQL query.
Get Data SecurelyDB	The Get Data SecurelyDB Action fetches specific data from the database.
Verify Secure DataDB	The Verify Secure DataDB Action compares the expected data from a local Excel file with the actual data in the database.
Export Data SecurelyDB	The Export Data SecurelyDB Action fetches data from the database and exports it into an Excel file.
Run Query SecurelyDB	The Run Query SecurelyDB Action allows executing an SQL query.

Supported Database Numbers and Tags

Avo Assure supports the following Databases with their respective Database Numbers and Database Tags.

Relational Database

Here are the Relational Databases with their respective Database Numbers and Database Tags:

Note: The database tags are not case sensitive

Database Tags	Database Numbers
MSSQL	4
Oracle	5
PostgreSQL	14

Non- Relational Database

Here are the Non- Relational Databases with their respective Database Numbers and Database Tags:

Database Tags	Database Numbers
Mongo DB	9