Looking for something in particular?

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 the database as the 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 confirmed, 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 create Test Steps

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

Review Provar on G2
Documentation library

Trying to raise a case with our support team?

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