Share this page

# 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:

Function | Description
--- | ---
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:

- Connect to a database

- Use data retrieved from SQL queries

- Validate database values

- Check returned values through a database

- Perform actions on datasets

For more information, see the Function Reference.

https://admhelp.microfocus.com VuGen,Professional Performance Engineering,Performance Engineering for Developers 8942
Tips to improve your search results... OpenText™ Virtual User Generator Help Center OpenText™ VuGen Help 26.1-26.3 All View Local Help Center View Online Help Center Version: