Skip to content

Exasol

Archived (pre-2022)

Preserved for reference only -- likely outdated. View original | Last updated: February 2020

General

We used to run three different Exasol clusters (instances), called BI, (SPS) PROD and TEST. PROD and TEST were used for an old release of Dashboard and have been shut down since.

To this day only BI remains active.

Accessing Exasol

Download Software

The recommended way to access Exasol is using the native client, EXAplus, which is available for download at this location:

Version 6.0.1

Alternatively, various database client products like SQuirrel SQL or DBeaver work with the JDBC driver that is available at the same download location. An ODBC driver is there as well.

Connecting to the Cluster

For connecting to the Cluster, all that is usual needed is a connection string, a username and a password. As Exasol is clustered software, the connection string denotes a range of IP addresses. In case one is down, the driver connects to another address in the range.

Fyber's connection string to BI is:

172.30.23.11..17:8563

The super user on Exasol is called SYS, the password is stored in LastPass.

Connecting with EXAplus

Select Connection profiles / New profile from the EXAplus menu and fill in the necessary information:

Edit profile BI admin_001.png

Then use EXAplus / Connect To / to connect to the database:

EXAplus - RWUNDERER@BI_720 [rw5_BI]_002.png

You can enter any SQL command in the "SQL Editor 1" window and execute it using the blue "play" buttons above.

The complete EXASolution manual can be found in the Help menu.

Exasol Documents in Fyber Wiki (partially obsolete)

Contact information

User information (eg for BI)

Technical / DevOps