We're excited to share that Database Connectivity is available for mabl tests in early access! Database Connectivity is the fastest and most intuitive way to integrate database testing into your automated workflows and eliminate the need for manual testing and cumbersome technical integrations.
Creating a new database query step
With this powerful addition to the mabl platform, you can
- Verify that changes made in your application are accurately reflected in your database. For example, when creating a new user via a web form, you can assert that the new user was accurately stored in the database.
- Verify that changes made in your database are accurately reflected in your application. For example, you can insert a new user into the database and assert that the web application displays the new user accurately.
- Populate mabl test data using data from your database. For example, if a list of product IDs are stored in a database, you can pull those into mabl as variables for your test.
- Set up and tear down test data in your database to support your mabl tests. For example, you can use queries to ensure your database is in a desired state at the start of a test and returns to a desired end state when the test is complete.
Database Connectivity is available to all accounts during the early access period. When the feature is fully released, it will be available to accounts on any Core plan. If you'd like to learn more about what this means for your account, please contact your Customer Success Manager, or email support@mabl.com.
Prior to general availability, changes to this feature may be made without notice.
Database connectivity highlights
Database Connectivity is built to supercharge your complex testing workflows, including the following highlights and capabilities:
- Create queries that are dynamically generated from parameters you define.
- Direct the same query to run against different database environments by defining environment-specific overrides.
- Seamlessly use the same queries across multiple tests, and centrally manage these reusable queries for any updates you need to make.
- Store and manage your database access credentials securely, directly in mabl.
- Securely access non-public databases through mabl Link or by allowlisting mabl IP addresses.
Adding an environment override
Try it out
Before you start, make sure to update to the latest version of the mabl Desktop App: Help > Check for updates. During the early access period, workspace owners can enable Database Connectivity on the Labs page: Settings > Labs.
- Go to Configuration > Database connections
- Create a new database connection with all the connection details required to connect to your database.
- When creating a web or mobile test, create a new database query step directly in the mabl Trainer.
- Write your query, save it, and create any assertions or variables from the results of the query.
If you are connecting to a non-public database, you must first configure mabl Link in your workspace and configure your environment to use the Link Agent or add mabl IP addresses to your firewall's allowlist.
Current limitations
- This capability currently supports MySQL and Microsoft SQL Server. We plan to soon support PostgreSQL, MongoDB, and Oracle.
- Database query steps are available in both web and native mobile tests, but not for API tests. For guidance on how to incorporate data from databases in API test workflows, please contact support@mabl.com and we can explore available paths.
- Additional configuration options for connecting to databases are currently limited, and some databases with specific connection settings may not be supported. Please reach out to support@mabl.com if you are unable to connect your database and we can work together to support your needs.
For more detailed information on limits for this functionality please visit our help documentation on configuring database connections and creating database queries.