Database Manager

Applies to ReadyAPI 3.56, last modified on November 25, 2024

The Databases manager is a built-in ReadyAPI tool, which you can use to create and edit database connection strings. The connection strings allow you to obtain the database data and add it to your tests. If one of your test steps needs such a connection, you have to configure it properly.

Tip: To establish a database connection in ReadyAPI, you need a JDBC driver. See below for more information.

To open the Databases manager, click on the toolbar.

ReadyAPI: Opening the preferences menu from the toolbar

Click the image to enlarge it.

In the manager window, you can see all the available JDBC connections.

ReadyAPI: The Databases window

Click the image to enlarge it.

Icon Option Description
ReadyAPI: Add button Add Create a new configuration.
ReadyAPI: Remove button Remove Delete the configuration.
ReadyAPI: Configure button Configure Edit the connection.
ReadyAPI: Run button Run Test the configuration.
Note: Before adding a new connection, make sure you have placed the driver in the bin/ext directory. To learn how to install the driver, see Installing Database Drivers.

After you finish configuring the connections, you can use them by selecting the Data Connection type for data source test steps.

Database Configuration

You configure the database connection by using the Database configuration dialog.

Database Configuration dialog

Click the image to enlarge it.

In the dialog, you select the driver to use and specify additional properties. The list of properties depends on the specified driver. Usually, you should provide the host address, port, username, password, and so on. Also, you can specify additional properties that will be passed to the database driver.

Due to the specifics of the MySQL Connector/J drivers, when you work with MySQL or MariaDB databases, you have to manually percent-encode all the reserved URL characters (for example, /, :, @, (, ), [, ], &, #, =, ?, and space) that appear in your password. For example, if your password is p@ssw?rd, you must enter it as p%40ssw%3Frd.

To learn about percent-encoding, see https://www.w3schools.com/tags/ref_urlencode.asp.

Connection Drivers

ReadyAPI comes with preconfigured JDBC connectors. However, you can install different JDBC drivers in your environment. For a full list of available connection strings, see Preconfigured JDBC Drivers.

See Also

Installing Database Drivers
Preconfigured JDBC Drivers
Connection String Template
Working With Database Drivers

Watch the video
 
Highlight search results