Using DBeaver with Exasol

Over the past year I’ve started using Exasol (in-memory database for Analytics) and migrating away from the traditional Microsoft SQL Server.

Exasol has it’s own user interface called Exaplus, to write SQL statements for EXASolution. It’s a GUI based software that has syntax highlighting, a very useful transfer wizard to import/export files as well as a schema browser.

As good as Exaplus is it didn’t have that personal “oumph” to it until I came across DBeaver. DBeaver is a “Free Universal SQL Client” that has a variety of different features that I find useful as a SQL Developer.

Installing DBeaver is a relatively simple process and links to the download will be included at the end of the article. After downloading the SQL Client make sure to download the JDBC driver. This can be done from DBeaver > Drive Manager and select Exasol .

dbeaver-screenshot
DBeaver Version 3.8.1

Below are some useful keyboard shortcuts that I currently use on a daily basis;

Execute Query CTRL + ENTER
Execute Script ALT + X
Auto Complete CTRL + SPACE
Format CTRL + ALT + F
Edit Cell Value SHIFT + ENTER

More keyboard shortcuts can be found from Help > Key Assist.

Other Useful Features:

Templates/Snippets – Window > Preferences > General > Editors > SQL Editor > Templates
Formatting – Window > Preferences > Database > Result Sets > Data Formats

Overall I’m really pleased with DBeaver and credit is due to the developer(s) and I’d suggest to test it out. It works perfectly well for my day to day general tasks when writing queries and scripts. The only aspect it’s currently missing is creating DDL scripts to recreate schema for development environments.

Download DBeaver

– Vinit Joshi

Advertisements

One thought on “Using DBeaver with Exasol

  1. […] So, in my round up of 2016, I promised you a look at a blog written by one of the guys on my team at Atheon. Vinit has written in his blog about another GUI which can interface with Exasol. An alternative to Exaplus if you will. And, best of all it comes with intellisense! I’ll let Vinit tell you the rest over at his blog optimumretrieval. […]

    Liked by 1 person

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s