Connect to Ocient
Ocient Integrations

DBeaver Integration

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

Prerequisites

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

  • Ocient system Use latest version.
  • JDBC Driver Use latest version. See the Ocient Maven repository for a list of all versions.

To install, download the latest version of DBeaver from the DBeaver Community 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 host name 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. 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

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

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


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.


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