> ## Documentation Index
> Fetch the complete documentation index at: https://docs.ocient.com/llms.txt
> Use this file to discover all available pages before exploring further.

# DBeaver Integration

export const Windows = "Windows®";

export const Ocient = "Ocient®";

export const Maven = "Apache® Maven™";

export const macos = "macOS®";

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 {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, select **New Database Connection** in the top left of the window.
* In the New Database Connection window, find the Ocient driver. Select it, and then select **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.                                                        |

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

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/eodbub-vrltrojrajiyq5-dbeaverdb-a2095164.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=a914eafbd9f76f19818f084d8867e551" alt="Selection of Driver Manager in the Database menu" width="739" height="516" data-path="images/eodbub-vrltrojrajiyq5-dbeaverdb-a2095164.png" />
</Frame>

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

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/js7j5n-fksnmztqedj5-n-dbeaverdriverselection-fb01a614.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=5b5def57cac406e1c89063ea589af1c2" alt="Select the Ocient driver under Name in the Driver Manager window." width="1430" height="1344" data-path="images/js7j5n-fksnmztqedj5-n-dbeaverdriverselection-fb01a614.png" />
</Frame>

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

**Update the Driver to the Latest Version**

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

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/x3cs-hoxciz9pumqkdky-screenshot-2023-06-01-at-41257-pm-67fdad75.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=7a93cf7b69edcafb6f45e76ebf7b1d4f" alt="Libraries tab of the Edit Driver Ocient window contains the Download/Update button." width="1002" height="910" data-path="images/x3cs-hoxciz9pumqkdky-screenshot-2023-06-01-at-41257-pm-67fdad75.png" />
</Frame>

**Load a Specific JDBC Driver Version**

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

<Frame>
  <img src="https://mintcdn.com/ocient/z72iqRqJo7Ob2_zv/images/pximkeurkqx0ipm-9cqlz-dbeavermaven-806e0baf.png?fit=max&auto=format&n=z72iqRqJo7Ob2_zv&q=85&s=694dbb4dc08156ba2532b5bfacb159d6" alt="Specify the specific JDBC version to load in the Declare Artifact Manually section by using the Version field." width="1127" height="810" data-path="images/pximkeurkqx0ipm-9cqlz-dbeavermaven-806e0baf.png" />
</Frame>

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

## Related Links

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

[Ocient Integrations](/ocient-integrations)