Database testing setup

The first step in testing a database is to add a Database Connection.

Once created, these details will be saved in the Connections tab within Test Settings. Information in the database can be viewed and acted upon via the Org Browser. Refer to Database Operations for more information on the available actions.


Adding a Database Connection (Oracle, PostGreSQL, MySQL, SQL Server or DB2)

To add a new Database Connection, navigate to the Test Settings view and click the + () button to create a new Connection.

Enter a Connection Name and Description, then specify Database as Connection Type. As a subtype, select Oracle, PostGreSQL, MySQL, SQL Server or DB2. (Note that DB2 is available for Provar version 1.9.7 and later.)

Enter the other information as follows:

  • Host Name (e.g. localhost)
  • Port Number (e.g. 1433)
  • Database (Name), Service, SID or Database and Schema (depending on database type – see below for examples)
  • User
  • Password


Oracle example:

MySQL example:

SQL Server example:

Once the details have been entered, click the Test Connection button to verify the details are correct:

Once the details have been verified, click the OK button.
Check that the Connection has been added to the Connections tab:

Database browser view

Once you have created your Database connection, you can initiate testing from the Database Browser in the following ways:

  • Drag Database data rows into the Query window to generate SQL and execute
  • Drag Data or tables into the Test Case to generate Test Steps

Refer to Database Operations for more information on the available actions.

Review Provar on G2
Documentation library

Other available resources

Looking for something different?

We use cookies to better understand how our website is used so we can tailor content for you. For more information about the different cookies we use please take a look at our Privacy Policy.

Scroll to Top