---
title: DBeaver Integration
slug: lLH7VrjcDt-XTZl7iSTeO
description: Learn how to integrate Ocient with DBeaver, enabling a powerful and intuitive interface for managing and analyzing your Ocient data.
docTags: 
createdAt: Thu Jun 01 2023 22:50:59 GMT+0000 (Coordinated Universal Time)
updatedAt: Mon Mar 30 2026 18:52:46 GMT+0000 (Coordinated Universal Time)
---

DBeaver is a free and open-source application for database administration and SQL querying.&#x20;

## Prerequisites

To use DBeaver with the Ocient® System, you must have these software prerequisites:&#x20;

- Ocient System — Use latest version.
- JDBC Driver — Use latest version. See the Ocient Apache® Maven™ [repository](https://mvnrepository.com/artifact/com.ocient/ocient-jdbc4) for a list of all versions.&#x20;

To install, download the latest version of DBeaver from the [DBeaver Community](https://dbeaver.io/download/) for your respective operating system.&#x20;

Follow the installation steps and open DBeaver.  &#x20;

## Connect to Ocient&#x20;

You can connect to your database by following these steps: &#x20;

- In the main DBeaver window, click **New Database Connection** in the top left of the window.&#x20;
- In the New Database Connection window, find the Ocient driver. Select it, and click **Next**.&#x20;
- Enter your database parameters with this information.

| **Field**       | **Description**                                                                                     |
| --------------- | --------------------------------------------------------------------------------------------------- |
| Host            | The hostname or IP address of the SQL Node of your Ocient System. For example: `databasehost-sql0`  |
| Port            | The port number for your connection. The default Ocient port is `4050`.                             |
| Database/Schema | The name of the database for connection. For example: `my_db`                                       |
| User            | The username associated with your database.                                                         |
| Password        | The password associated with your username.                                                         |

- Click **Finish**. &#x20;

## Update Ocient JDBC

By default, DBeaver downloads the latest JDBC version available in the [Maven repository](https://mvnrepository.com/artifact/com.ocient/ocient-jdbc4). If you need to update the JDBC driver or load a specific version, follow these steps.&#x20;

- In the DBeaver window, select **Database** > **Driver Manager**.

::Image[]{src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/eOdBub_VRltroJRAjiyq5_dbeaverdb.png" size="76" width="739" height="516" position="center" alt="Selection of Driver Manager in the Database menu" darkWidth="739" darkHeight="516"}

- Search among the list of driver options to find the Ocient driver, and select it.&#x20;
- With the Ocient driver highlighted, click **Edit**.&#x20;

::Image[]{src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/JS7J5n-FkSNMZtQeDj5_n_dbeaverdriverselection.png" size="72" width="1430" height="1344" position="center" alt="Select the Ocient driver under Name in the Driver Manager window." darkWidth="1430" darkHeight="1344"}

- In the Edit window, select the **Libraries** tab.&#x20;

**Update the Driver to the Latest Version**

To update the driver to the latest version, click **Download/Update**.&#x20;

::Image[]{src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/_x3CS_Hoxciz9PuMQKDky_screenshot-2023-06-01-at-41257-pm.png" size="68" width="1002" height="910" position="center" alt="Libraries tab of the Edit Driver Ocient window contains the Download/Update button." darkWidth="1002" darkHeight="910"}

**Load a Specific JDBC Driver Version**

- Double-click on the `com.ocient:ocient-jdbc4:RELEASE` in the Libraries window. The Edit Maven Artifact window opens.
- Enter the JDBC version in the **Version** field. &#x20;

::Image[]{src="https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/pXImKEurkQx0iPm_9cQlZ_dbeavermaven.png" size="70" width="1127" height="810" position="center" alt="Specify the specific JDBC version to load in the Declare Artifact Manually section by using the Version field." darkWidth="1127" darkHeight="810"}

:::hint{type="info"}
For accurate time values, you might need to configure the DBeaver time zone settings.&#x20;

- For macOS® systems, configure this setting in **Settings** > **User Interface**.&#x20;
- For Windows® systems, configure this setting in **Preferences** > **User Interface**.&#x20;
:::

## Related Links

[Connect to Ocient](<./././Connect to Ocient.md>)

[Ocient Integrations](<././Ocient Integrations.md>)
