Datalore 2025.3 Help

Using custom or third-party JDBC drivers

Datalore supports attaching 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

  1. Click the avatar in the upper right corner of the screen and select Admin panel.

    Opening Admin panel
  2. From the sidebar of the Admin panel, select Data. You will be on the Customer driver tab. Your further steps are made on this tab.

    Customer driver tab of Data menu
  3. Click the New 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 connection type in the New database connection dialog.

Custom database connections

Find more details about configuring database connections in Configure a database connection.

Edit custom JDBC drivers

  1. Go to Admin panel | Data. On the Custom driver tab, you can view the list of all added driver files.

  2. Right-click the ellipsis for the driver you want to edit and select Edit from the popup menu.

    Editing custom drivers
  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 dialog, click the Delete custom driver button.

Last modified: 20 March 2025