EXASOL and SQuirreL SQL - Install JDBC Drivers to make the connection

Before you can use SQuirreL SQL to connect to EXASOL, you first have to install the EXASOL JDBC drivers. And a key part of adding a new JDBC driver in SQuirreL SQL is that name of the class name.

Summary:

1. Click on Drivers Tab on the far left (typically below Aliases tab)
2. Either:
1. click on the Blue Plus, or
2. Using the menu chose:  Drivers | New Driver
3. This brings up an empty Add Driver window
4. Extra Class Path - tab
1. In the Extra Class Path tab, use the Add button, and navigate to the folder where the EXASOL jdbc jar is located. Choose the exajdbc.jar file, and click on Open.
5. Back in the Add Driver window, add some details:
1. Name:                     I used EXASOL exajdbc, but this is user defined.
2. Example URL:    Optional, but suggest this:  jdbc:exa:<URL attribute>:<port>
3. Website URL:     Optional.
4. Class Name:         com.exasol.jdbc.EXADriver  (required)
6. OK, click on OK, and your new driver is all set.

Detailed Steps

Click on the Drivers tab on the far left:

An empty Add Driver window:

In the Extra Class Path tab, click on the Add button. This brings up a file navigator.  Locate the EXASOL JDBC driver file: exajdbc.jar.

Choose Open.

Back in the Add Driver window, add some details:

• Name:                  I used EXASOL exajdbc, but this is user defined.
• Example URL:    Optional, but suggest this:  jdbc:exa:<URL attribute>:<port>
• Website URL:     Optional.
• Class Name:        com.exasol.jdbc.EXADriver  (required)

OK:  click on OK, and your new driver should be all set. Typically, in the bottom window, you will see the following:

That's it.  Now you can make a connection to your EXASOL database.To do this, first setup an Alias.

Add Alias:  

Use the Add Alias Blue Plus, or from the menu:  Aliases | New Alias...

In the popup Add Alias window. Provide a name for your Alias, select the EXASOL driver (the one you just added), add in the URL, the user name and password.

URL:  use the format:  jdbc:exa:<URL attribute>:<port>.  The default port for EXASOL is 8563.

This creates a permanent Alias for you. When you first set the Alias up, you get a popup asking if you want to connect.

With that, you have a permanent alias setup in SQuirreL SQL that makes the connection to your EXASOL database.