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.
In the manager window, you can see all the available JDBC connections.
|Add||Create a new configuration.|
|Remove||Delete the configuration.|
|Configure||Edit the connection.|
|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.
You configure the database connection by using the Database configuration dialog.
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,
To learn about percent-encoding, see https://www.w3schools.com/tags/ref_urlencode.asp.
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.