Skip to content

Adding and Removing Database Connection Pools

This page describes how to add and remove Database Connection Pools in TORO Integrate.

Adding a Database Connection Pool

Creating a new database connection is simple. Here's the step-by-step process for adding a connection:

  1. In the Coder Navigator view, right click on the Databases tree element, and then click New > Integrate Database.
  2. You will then be prompted with the New Database dialog to provide the name of the database connection. Click Finish.
  3. Once that's done, you'll see the Database Connection Properties Editor. Fill out the required database properties.
  4. Finally, save the changes by pressing ⌘S on Windows.

Here's a GIF showing the process:

Adding a new database connection

  1. In the Coder Navigator view, right click on the Databases tree element, and then click New > Integrate Database.
  2. Then fill up all the required database properties.
  3. Click Create and you're done!

Here's a GIF showing the process:

Adding a new database connection

Before you can do anything related to managing database connections, you must first go to the Database Connections page. You can do so by selecting Connections from the main menu and then clicking on Databases from the appearing sub-menu.

Navigating to the *Database Connections* page

Now that we're in the Database Connections page, we can add database connections.

  1. Click on the Add button from the action bar at the top of the main section.
  2. Fill in the required database properties. To access advanced settings, just check the Advanced checkbox.
  3. Once done, click on the Add button at the bottom of the form.

Here's a GIF showing the process:

Adding a new database connection

Test your database connections!

Although it is not required when adding or editing a database connection, we recommend testing the connectivity of the database connection first before adding/editing the database. This way you'll know if a connection can be established or not.

Removing a Database Connection

As for removing a database connection, it is as simple as:

  1. Stopping the database if it isn't stopped yet. You can do this by right clicking on the database and clicking on Stop from the appearing context menu.
  2. Right clicking on the database again and clicking Delete this time to finally delete the database.

Here's a short GIF showing the process:

Removing a database connection

  1. Stopping the database if it isn't stopped yet. You can do this by right clicking on the database and clicking on Stop from the appearing context menu.
  2. Right clicking on the database again and clicking Delete this time to finally delete the database.

Here's a short GIF showing the process:

Removing a database connection

  1. Stopping the database if it isn't stopped yet. You can do this by ticking on the checkbox of the database connection entry, clicking the Stop button located at the action bar, and confirming the action.
  2. Ticking the checkbox of the database entry again but this time, clicking on the Delete button to finally delete the database.

Here's a short GIF showing the process:

Removing a database connection

Installing Additional Database Drivers

TORO Integrate supports the installation of database drivers that are not included out-of-the-box. To do this, you simply have to copy the driver into the <toro-integrate-home>/lib/ directory, and restart TORO Integrate. After doing so, you should now see the driver amongst the list of available database drivers when adding a new database connection.

List of available database drivers

The image above shows the Derby Database Driver installed. If your driver still doesn't appear in the list, simply enter the driver class name in the Driver Class field.

See the Driver Support section to see the list of all drivers that that can be installed in TORO Integrate, as well as which drivers are inherently supported in TORO Integrate.

Your drivers could be wiped out during an upgrade

Custom drivers will not be carried over if there is an update since the <toro-integrate-home>/lib/ directory will be overridden during an update.