Customize data integration
As an admin, use the Data tab of the Admin panel to do the following:
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
Custom JDBC drivers
Attach custom JDBC drivers to establish connections to databases that are not natively supported in Datalore. After such a driver is attached, the user can select the respective database connection type in the New database connection dialog.
Add a custom JDBC driver
Click the avatar in the upper right corner of the screen and select Admin panel.
At the bottom of the Supply custom database driver files list, click the Add custom driver button.
In the New custom database driver dialog, provide a connection title and a driver class in the respective fields.
Click the Select driver files button. This will open your file browser window.
Use the browser window to find and select the driver file.
(Optional) To cancel adding the selected file, do one of the following:
Click Stop while uploading the file
Click the ellipsis after the file is uploaded and select Delete
After the file browser window is closed and the file is uploaded, click the Create connection button. This will add the selected driver to the list and close the dialog.
Result
The added driver will be presented as a custom database connection type in the New database connection dialog.
Find more details about configuring database connections in Configure a database connection.
Manage custom JDBC drivers
Go to . Under Supply custom database driver files, you can view the list of all added driver files.
Click the ellipsis for the driver you want to edit and select Edit from the dropdown menu.
In the Edit custom database driver dialog, make the required changes.
To save the changes and finish the procedure, click the Update connection button.
Delete custom JDBC drivers
Go to . Under Supply custom database driver files, you can view the list of all added driver files.
Click the ellipsis for the driver you want to delete and select Delete from the dropdown menu.
In the confirmation window, click the Delete custom driver button.
Instance-wide database connections
As a Datalore admin, you can create and manage database connections shared across all workspaces within your Datalore instance, instance-wide database connections.
This will save you the trouble of managing several identical database connections created individually for different workspaces. You will also make sure that all of your teammates have the same access to the shared database connection, which will facilitate your collaborative process.
Add an instance-wide database connection
Click the avatar in the upper right corner and select Admin panel from the menu.
From the Admin panel, select Data.
Switch to the Instance wide db connection tab.
On the Instance wide db connection tab, click the Add db connection. This will open the New database connection dialog.
Create the new connection by following this instruction.
The newly added database connection will be added to the resources of all workspaces within your Datalore instance for all teammates to use.
Manage instance-wide database connections
Although instance-wide database connections are shared across all workspaces and available to all team members, only Datalore admins can edit them. Therefore, users cannot edit such database connections as workspace resources (like other connections available there).
Click the avatar in the upper right corner and select Admin panel from the menu.
From the Admin panel, select Data.
Switch to the Instance wide db connection tab. You will see the list of the database connections created for your Datalore instance.
Do one of the following:
To rename a connection, click the ellipsis for the respective list item and select Rename. Type the new title in the respective field and press Enter.
To edit a connection, click the ellipsis for the respective list item and select Edit. This will open the Edit [connection_title] connection dialog. Make your changes and click the Save and close button to apply them.
To delete a connection, click the ellipsis for the respective list item and select Delete.
