The SQL Connection Manager lets you configure Managed Connections for a workspace using Connection IDs.
Drivers for Managed Connections are loaded by the Studio as needed. To manually load drivers for the current workspace in the Studio, see Tools > Configure Database Drivers.
Adds a new Managed Connection. This opens the Add a Connection dialog.
Edits the currently selected Managed Connection. This opens the Edit a Connection dialog.
Deletes the currently selected Managed Connection.
Enables or Disables the currently selected Managed Connection.
You can have as many Managed Connections as you like for any given workspace. This allows you to easily manage multiples databases, even multiple different database types, in any workspace.
Only one Managed Connection using the same Connection Id can be active at any given time.
This included the ability to have multiple Managed Connections using the same Connection Id. This allows you to define the same Connection Id for multiple connections. A typical scenario for this would be having a Connection Id defined for a development database and the same Connection Id for the live version of the same database, allowing you to quickly switch between database versions.
Tests the currently selected Managed Connection. The result will be displayed in a dialog (success or an error message displaying error information from the driver or database server). A test may fail not just if credentials are incorrect, but also if a server or database are currently unavailable or unreachable (e.g. if you are disconnected from the server network).
Saves all Managed Connections and closes the dialog.
Closes the dialog without saving changes to Managed Connections.