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 {{ocient}} system, you must have these software prerequisites ocient system — use latest version jdbc driver — use latest version see the ocient https //mvnrepository com/artifact/com ocient/ocient jdbc4 for a list of all versions to install, download the latest version of dbeaver from the 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 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 search among the list of driver options to find the ocient driver, and select it with the ocient driver highlighted , click edit 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 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 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 docid\ y ge7svqdmn 9yie2iuv6 docid\ rykk tzyxdmrqdpodtc79