Firstly, we will cover how to define SQL queries and link them to development and testing environments.

Before you can create a new SQL lookup you need to define what databases it will be connecting to. To do this, click on Connections in the left side menu:

This will open the list of current connections, here you may activate, edit, create or delete connections.

SQL needs to run against specific databases and different database types. Inside Test Modeller you need to create connections that are linked to each SQL query that will be run to find the test data. Before you begin adding in connections and SQL to Test Modeller use an SQL Management studio to test run the SQL. This will check the validity of the syntax and make sure you can connect to the databases being used by the application under test.


The example above shows the SQL Server Management studio running SQL to find leads for testing a CRM system.