Database Integration Overview

When testing your application or Web service, it is vital that you use data that is accurate and up to date. If you use a snapshot of data from a past date, it may no longer be valid or relevant.

The database integration allows you to access values in a database during your test, ensuring that the data is up to date. You can also check your returned values against those in the database.

The following is a list of the database functions, available from the Database category in the Steps Toolbox:

lr_db_connect

Connects to a database.

lr_db_disconnect

Disconnects from a database.

lr_db_executeSQLStatement

Submits an SQL statement to a database.

lr_db_dataset_action

Performs an action on a dataset.

lr_db_getValue

Retrieves a value from a dataset.

lr_db_dataset_action

Validates database contents by setting checkpoints.

The database integration functions are useful in the following scenarios:

For more information, see the Function Reference.