Datalore 2023.5 Help

Manage custom JDBC drivers

As an admin, you can attach custom JDBC drivers to connect to databases that are not natively supported in Datalore.

Add a custom JDBC driver

  1. Click the avatar in the upper-right corner and select Admin panel from the menu.

  2. From the Admin panel, select Data.

  3. At the bottom of the Supply custom database driver files list, click the Add custom driver button.

  4. In the New custom database driver dialog, provide a connection title and a driver class in the respective fields.

  5. Click the Select driver files button. This will open your file browser window.

  6. Use the browser window to find and select the driver file.

  7. (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

    Adding a custom driver
  8. 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 type in the New database connection dialog.

Manage custom JDBC drivers

  1. Go to Admin panel | Data. Under Supply custom database driver files, you can view the list of all added driver files.

  2. Click the ellipsis for the driver you want to edit and select Edit from the dropdown menu.

  3. In the Edit custom database driver dialog, make the required changes.

  4. To save the changes and finish the procedure, click the Update connection button.

Delete custom JDBC drivers

  1. Go to Admin panel | Data. Under Supply custom database driver files, you can view the list of all added driver files.

  2. Click the ellipsis for the driver you want to delete and select Delete from the dropdown menu.

  3. In the confirmation window, click the Delete custom driver button.

Last modified: 30 October 2023