Skip to main content
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 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:
  1. In the main DBeaver window, click New Database Connection in the top left of the window.
  2. In the New Database Connection window, find the Ocient driver. Select it, and click Next.
  3. Enter your database parameters with this information.
FieldDescription
HostThe hostname or IP address of the SQL Node of your Ocient System. For example: databasehost-sql0
PortThe port number for your connection. The default Ocient port is 4050.
Database/SchemaThe name of the database for connection. For example: my_db
UserThe username associated with your database.
PasswordThe password associated with your username.
  1. 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.
  1. In the DBeaver window, select Database > Driver Manager.
Selection of Driver Manager in the Database menu
  1. Search among the list of driver options to find the Ocient driver, and select it.
  2. With the Ocient driver highlighted, click Edit.
Select the Ocient driver under Name in the Driver Manager window
  1. 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

  1. Double-click on the com.ocient:ocient-jdbc4:RELEASE in the Libraries window. The Edit Maven Artifact window opens.
  2. 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.