Search

Database Interaction Capabilities with DB Explorer

Overview

Functionize provides a DB Explorer feature that allows you to connect to supported databases to perform backend validation during test execution. This is useful for verifying data integrity and state directly within the database as part of your automated tests.

How It Works

The DB Explorer enables the execution of SQL SELECT queries for read-only validation. Key capabilities include:

  • Executing complex SELECT queries that involve multiple joins, filters, and aggregations.
  • Storing the query results in variables.
  • Using the stored variables for validations and assertions within your test cases.

Limitations

The DB Explorer is strictly designed for read-only validation purposes. Therefore, it has the following limitations:

  • DML Commands: Execution of Data Manipulation Language (DML) commands such as INSERT, UPDATE, and DELETE is not supported.
  • DDL Commands: Execution of Data Definition Language (DDL) commands like CREATE, ALTER, and DROP is not supported.
  • External Job Triggers: Functionize cannot directly trigger SSIS jobs or execute database agent jobs through its native database connection feature.

  • Stored Procedures : As they can internally call DML commands.

    This is mainly due to security reasons as we don't want to allow anyone to modify client real time database.

Related Information

For detailed steps on configuring and utilizing this feature, please see the article on Using the DB Explorer.