How to Use DBeaver With OmniSciDB

Introduction

In the previous article, we discussed one installation recipe for OmniSciDB and briefly used the Command Line Interface (CLI) to test our installation. The CLI is very powerful and enables SQL commands to be quickly tested. However, an alternative method to connect to OmniSciDB is to use a tool with a Graphical User Interface (GUI). From the first article in this series, we know that the OmniSci Platform can be used with a browser-based tool called Immerse. However, there are many GUI-based tools available today that can also be used with OmniSciDB. One such popular tool is DBeaver. Let's see how we can use this with OmniSciDB.

Prerequisites

This article assumes that you have followed the installation steps described in the previous article and that you have loaded the sample database. In my environment I have now additionally installed a full Java Development Kit (JDK). My Java environment is as follows: