Manage database connections in a workspace
This article explains how to manage database connections added to your workspaces. Such data sources can be attached to any notebook residing in the respective workspace.
On the Home page, select the workspace to which you want to add a database connection.
From the left-hand menu of the selected workspace, select Other and switch to the Databases tab. This will open the list of all workspace database connections.
All further procedures are performed from here.
note
Note for Datalore On-Premises usersThis does not apply to instance wide database connections that were added to the workspace resources when created by an admin. Such database connections can only be managed on the Admin panel. Find more details in this chapter.
Right-click the connection you want to rename. This will open a popup menu.
Select Rename from the popup menu. Now, you can edit the database connection name.
Enter the new name and press Enter.
Right-click the connection you want to manage. This will open a popup menu.
Select Edit. This will open the Edit database connection dialog.
In the Edit database connection dialog, edit the connection details. Find database-specific information in the respective article listed under Configure a database connection.
Click the Save and close button to finish the procedure.
Right-click the connection you want to clone. This will open a popup menu.
Select one of the two options:
Clone to this workspace: to clone the connection to the same workspace. It will be added to the same list under a slightly different name.
Clone to other workspaces: to clone the connection to other workspaces:
In the Clone [database_connection_name] to other workspaces dialog, expand the Workspace list.
Select the workspaces you want to clone the connection to.
Click the Clone button.
This procedure saves the details of a database connection in XML format with all current values and copies them into your clipboard. You can use the copied XML content to create another database connection.
On the Home page, select the workspace to which you want to add a database connection.
From the left-hand menu, select Databases to open the list of all workspace database connections.
Right-click the connection you want to manage. This will open a popup menu.
Select Export to .xml.
The data is copied to your clipboard.
This procedure deletes database connections from your Datalore system without moving it to Trash.
Right-click the connection you want to manage. This will open a popup menu.
Select Delete.
As a Datalore On-Premises admin, you can do the following to customize your database connection options:
Attach custom JDBC drivers to connect to databases that are not natively supported in Datalore
Create instance-wide database connections shared across all workspaces within your Datalore instance
For more details, refer to Using custom or third-party JDBC drivers.