To allow ReadyAPI to access the MS SQL Express data, you need to install a JDBC driver. When working with this tutorial, you will use jTDS.
Install the driver
To install the JDBC driver:
Download the jTDS.zip archive from here: http://sourceforge.net/projects/jtds/files/latest/download?source=files
For other drivers, see the JDBC Drivers List.
Extract the ZIP file.
Copy the jtds-x.x.x.jar file to the bin/ext directory of your ReadyAPI installation.
You always need to restart ReadyAPI after installing
Add a connection string template
To use the correct authentication, you need to add a connection string. You can configure it inside ReadyAPI Preferences:
Click in the toolbar.
Open the JDBC drivers settings.
Enter a descriptive name for the driver.
For this tutorial, use
Find the new driver on the list. Usually, it is at the end.
Add a Connection String template. It should look like this:jdbc:jtds:sqlserver://<HOST:127.0.0.1>:<PORT:1433>/<DB>;domain=yourdomain;trusted_connection=yes
In the preceding example, replace
yourdomainwith your domain, and
PORTwith the port number you have set up earlier.
Now, you can install the authorization DLL.