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.
Below are the categories under Database Actions:
The Get DataDB Action fetches specific data from the database.
The Verify DataDB Action compares the expected data from a local Excel file with the actual data in the database.
The Export DataDB Action fetches data from the database and export into the Excel file.
The Run QueryDB Action help you to execute SQL query.
The Get Data SecurelyDB Action securely fetches data when the password in the input field is AES encrypted.
The Verify Secure DataDB Action takes the password in encrypted form and compares the expected data from a local Excel file with the actual data in the database.
The Export Data SecurelyDB Action takes the password in encrypted form. This action fetches data from the database, and exports it into an Excel file.
The Run Query SecurelyDB Action allows you to execute SQL queries using an encrypted password.
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:
DB2
2
MS Assess Files
3
MSSQL
4
Oracle
5
Sybase
7
Mysql
8
SQLite
12
Snowflake
13
PostgreSQL
14
Sql
15
Non- Relational Database
Here are the Non- Relational Databases with their respective Database Numbers and Database Tags:
Mongo DB
9
Redis
10
Cassandra
11
Last updated
Was this helpful?