Skip to navigation
Connect to OcientOcient Integrations

DBeaver Integration

View as Markdown

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

Connect to Ocient

Ocient Integrations