Exasol

Exasol is an in-memory, massively-parallel analytics database. Clients talk to it with JSON messages over a WebSocket rather than a traditional wire protocol. AddisDB implements that protocol directly.

Who it is for

Exasol is chosen for speed on analytical workloads — it is consistently at the top of independent analytics benchmarks. It suits organisations with a well-defined reporting workload and the budget for an in-memory system, and is typically run as a cluster.

Set up the connection

1. Note a cluster node’s host and the port — 8563 by default.
2. Note the user. sys is the built-in administrator.
3. Optionally note a schema to open on connect, which scopes the schema tree and lets you write unqualified table names.
4. Check whether the cluster presents a self-signed certificate — most on-premise installs do.

Connect from AddisDB

1. New Connection → Exasol. Port prefills to 8563 and username to sys.
2. Enter the host and password, and optionally a schema in the database field.
3. Leave SSL mode at require — Exasol expects TLS.
4. Test, then Save.

What AddisDB gives you

Queries and the Big Data Console, the schema tree read from EXA_ALL_COLUMNS, exports, saved queries and mock data.

Exasol returns results column by column rather than row by row. AddisDB transposes them, so the grid shows what you would expect rather than a result set turned on its side.