You can easily connect to a database and execute SQL queries in your tests.
The following databases are supported by our engine:
- Microsoft SQL
To establish a new connection, select the Connect to Database option from the Action dropdown.
If you just want to execute an SQL query, use the Execute SQL Query action.
If you need to get the result from an SQL query, just use the Extract result from SQL Query option from the Set Variable action.
- Connect to your database with one of the following actions:
Connect to MySQL Database
Connect to PostgreSQL Database
Connect to Microsoft SQL Database
- Select the
Execute SQL Queryaction.
- Add your SQL in the
If you want to get the result from an SQL query, use the
Extract result from SQL Query option from the
Set Variable action.