Database Operations

Avo Assure supports the following Databases with their respective Database numbers

Relational Database Tags (Not case sensitive) with Database number

Database Tags	Database number
DB2	2
MS Assess Files	3
MSSQL	4
Oracle	5
Sybase	7
Mysql	8
SQLite	12
Snowflake	13
PostgreSQL	14
Soql	15

Non- relational Database Tags with Database number

Database Tags	Database number
Mongo DB	9
Redis	10
Cassandra	11

This section includes the following Actions:

Actions	Descritpion
Get Data	The Get Data action fetches specific data from the database to use in Test Cases during execution.
Verify Data	The Verify Data action compares the expected data from a local Excel file with the actual data in the database during automated testing.
Export Data	The Export Data action fetches data from the database and saves it in an Excel file for analysis, reporting, or validation during automated testing.
Run Query	The Run Query action lets you execute SQL queries within a test to check, verify, or update data in the database.
Get Data Securely	This action securely fetches data when the password in the input field is AES encrypted, ensuring only authorized users can access it.
Verify Secure Data	The Verify Secure Data action checks if the encrypted input password matches the encrypted password stored in the database.
Export Data Securely	The Export Data Securely action runs a specified query and exports the results to an Excel file, securing it with the provided encrypted password.
Run Query Securely	​The Run Query Securely action allows users to execute SQL queries within automated tests using an encrypted password, ensuring secure validation and manipulation of database data during testing.