> For clean Markdown of any page, append .md to the page URL.
> For a complete documentation index, see https://ocient.ferndocs.com/llms.txt.
> For AI client integration (Claude Code, Cursor, etc.), connect to the MCP server at https://ocient.ferndocs.com/_mcp/server.

# DBeaver Integration

> Learn how to integrate Ocient with DBeaver, enabling a powerful and intuitive interface for managing and analyzing your Ocient data.

DBeaver is a free and open-source application for database administration and SQL querying.

## Prerequisites

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

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

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

Follow the installation steps and open DBeaver.

## Connect to Ocient

You can connect to your database by following these steps:

* In the main DBeaver window, click **New Database Connection** in the top left of the window.
* In the New Database Connection window, find the Ocient driver. Select it, and click **Next**.
* 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**.

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

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

![Selection of Driver Manager in the Database menu](https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/eOdBub_VRltroJRAjiyq5_dbeaverdb.png)

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

![Select the Ocient driver under Name in the Driver Manager window.](https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/JS7J5n-FkSNMZtQeDj5_n_dbeaverdriverselection.png)

* In the Edit window, select the **Libraries** tab.

**Update the Driver to the Latest Version**

To update the driver to the latest version, click **Download/Update**.

![Libraries tab of the Edit Driver Ocient window contains the Download/Update button.](https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/_x3CS_Hoxciz9PuMQKDky_screenshot-2023-06-01-at-41257-pm.png)

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

![Specify the specific JDBC version to load in the Declare Artifact Manually section by using the Version field.](https://api.archbee.com/api/optimize/zLEvgH2ISPR6In81OlyIL/pXImKEurkQx0iPm_9cQlZ_dbeavermaven.png)

> **Note**
>
> For accurate time values, you might need to configure the DBeaver time zone settings.
>
> * For macOS® systems, configure this setting in **Settings** > **User Interface**.
> * For Windows® systems, configure this setting in **Preferences** > **User Interface**.

## Related Links

[**Connect to Ocient**](/guides/connect-to-ocient)

[**Ocient Integrations**](/guides/connect-to-ocient/ocient-integrations)