Applies to ReadyAPI 2.8, last modified on September 27, 2019

Before working with databases in ReadyAPI, you have to establish a database connection. For this, you use the connection drivers. You can install Postgres JDBC4 Driver or Microsoft JDBC Driver during the ReadyAPI installation.

Install Third-Party JDBC Drivers

To install a third-party JDBC driver, do the following:

  1. Download and install the needed JDBC driver package.

  2. Put the driver files in the bin/ext directory of your ReadyAPI installation.

  3. Restart ReadyAPI to load the driver.

  4. In ReadyAPI, go to  Preferences > JDBC Drivers and add the new connection template.

    Tip: ReadyAPI has preconfigured connection string templates for a number of JDBC drivers.
  5. Once you have prepared the driver and connection string, you will be able to add the database connection.

To learn how to use a Groovy script to register the JDBC driver, see Using JDBC Drivers From Scripts.

Install the MySQL JDBC Driver

To learn how to properly install and configure the MySQL JDBC driver, see the corresponding topic.

Choose a Driver for MS SQL Databases

Currently, ReadyAPI supports two connection drivers for MS SQL databases:

We recommend using the Microsoft SQL JDBC driver: it is compatible with ReadyAPI and supports all necessary features. Use the JTDS driver if your database connection requires its specific properties.

See Also

JDBC Drivers
Database Manager
Using JDBC Drivers From Scripts
Data Sources and Data-Driven Tests

Highlight search results