Download Exasol JDBC Driver

Download the Exasol JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the Exasol JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Exasol. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each Exasol driver uses its own syntax — see the connection details below.

The Exasol JDBC driver

Exasol is an in-memory columnar analytical database known for its exceptional query performance on large datasets, used by enterprises for data warehousing, financial analytics, and BI reporting. It features automatic statistics collection, adaptive compression, and a massively parallel query engine.

The Exasol JDBC URL

• Required File(s): exajdbc.jar
• Java Driver Class: com.exasol.jdbc.EXADriver
• JDBC URL: jdbc:exa:HOST:PORT;schema=DB
• Website: Exasol

Download Exasol JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Connecting to Exasol

Exasol is a cluster, and its JDBC URL can name every node at once so the driver picks a live one rather than depending on whichever you typed.

1. Use port 8563. That is the default TCP port for client connections to the database.
2. Give the whole cluster, not one node. The URL accepts a range — jdbc:exa:192.168.6.11..14:8563 — or a comma-separated list of host:port pairs. The driver picks one at random and works through the others if that one fails, which is how a connection survives a node being down.
3. Name a schema if you want one opened. Exasol connects without a current schema unless the URL says ;schema=myschema, so unqualified queries otherwise fail even though the connection is fine.
4. Open port 8563 in the server's firewall. The database listens on port 8563 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

Exasol SaaS is reached the same way over TLS, with the host and port taken from the service console and your address added to its allowlist.

DbSchema and Exasol

DbSchema connects to Exasol using the Exasol JDBC driver and renders schema objects including virtual schemas, tables, and views in the diagram. Use the SQL Editor to write Exasol SQL with scripting (Lua, Python, Java UDFs) for in-database transformations.