Managing Database Connections

Search Knowledge Base by Keyword

< Back

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:

Managing Database Connections in Test Modeller

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

Managing Database Connections in Test Modeller

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. SQL Management Data Catalogues

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