Automation V3: Database Connections

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. 

Adding a Database Connection

Automation can connect with a variety of databases including Oracle, PostgreSQL, MySQL, SQL Server, or DB2.

To add a new Database Connection, navigate to the Settings view, click the +  button and select the connection type you’d like to create from the Add a database connection menu.

Enter a Connection Name, then enter the required details.

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

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

Once the details have been confirmed, click the Save button.

Check that the Connection has been added to the Database connections section of Settings:

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.

---

Feedback

Was this article helpful for you?

We really appreciate it!

Thank you for your feedback.

Tell us how we can improve this article.

No Yes