Microsoft SQL Databases as Data Sources

Applies to ReadyAPI 3.52, last modified on April 18, 2024

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

Data-Driven Testing Tutorials

Highlight search results