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.