Direct Connect using DBeaver

This article explains how to connect to One Model data using DBeaver.

Below are the high-level instructions for connecting to One Model Data using DBeaver - which is a free tool for connecting to Databases. For specific details on your Redshift cluster, please work with a member of the One Model Support Team.


There are many different tools that can be used to connect to the One Model SQL Databases. We recommend using DBeaver because it's free, but still supports all of the main features we use for connecting to Databases.


Step 1 - Create your connection

The first time you open DBeaver, it will display a Wizard for connecting to a Database. You can also get to this menu by clicking the "Add Connection" button at teh top left of the screen. When it asks you to "Select Your Database", choose "SQL", and type "Redshift" in the Fitler bar:


Click Next, and it will guide you through the process of installing the driver.


Once the Driver is installed, enter the details for your database instance into the Connection Settings window:


Note: Be careful to select the SSL option or specify the SSL mode as required wherever it is available. SSL is used to encrypt all of the communication between your client machine and the One Model database. If this is not configured, the connection will be rejected by the database. If you have any questions on the SSL options, please see the AWS documentation around SSL setup for Redshift here.


Step 2 - Start querying

Once you're finished configuring the database, click "Finish" to save. To query, selct SQL Editor -> Open SQL Script:



Once you've opened a SQL Editor, you can build, and run your queries!


Was this article helpful?

0 out of 0 found this helpful



Please sign in to leave a comment.