Microsoft SQL Databases as Data Sources

This tutorial describes how to use an Microsoft SQL Express server as a data source.

In this example, you will use the Microsoft SQL Express Server with a sample database and the virtual service to send the requests to.

jTDS Driver: In this tutorial, we use the Sybase jTDS driver. If your service does work with it, use the Microsoft jTDS driver that is provided with ReadyAPI instead.

NTLM.dll: Besides the jdbc driver, you will also need NTLM Auth .dll for authorization.

In this tutorial

This tutorial includes the following steps:

  1. Preparation

    1. Install MS SQL Express Server

    2. Configure the server port

    3. Install the sample database

    4. Install the JDBC driver

    5. Install the authorization DLL

  2. Implementation

    1. Import the virtual API

    2. Create a test case

    3. Create a data source

    4. Configure the JDBC connection

    5. Limit the data retrieval

    6. Use the query wizard

    7. Run the test

Resources

Use the following files to learn how to perform data-driven testing using the MS SQL Express database as a data source:

Next

See Also

In this section:
© 2025
Publication date: