Turn Your Exasol Warehouse into a Visual Schema Model

Build a clearer workflow for Exasol: reverse engineer existing schemas into interactive ER diagrams, model changes visually, and generate reviewed SQL scripts before deployment.

DbSchema is built for visual modeling, schema documentation, and deployment. Keep an offline model in Git, collaborate across teams, and publish documentation that developers, analysts, and stakeholders can navigate in minutes.

Download DbSchema See Exasol Features Download Exasol JDBC Driver · All drivers

Visualizing Exasol Schemas and Virtual Schemas

Exasol is an in-memory columnar database engineered for extreme analytical query throughput. It supports both standard schemas and virtual schemas — virtual schemas provide a read-only projection over external data sources such as Amazon S3, Hive, or relational databases, exposed through the same SQL interface as native tables. DbSchema connects to Exasol via JDBC and renders both schema types as ER diagrams, giving analytics engineers a unified view of physical and virtual table structures alongside their relationships, without switching between the Exasol client and other documentation tools.

Download DbSchema Free See Exasol Features

Design Exasol Schemas in the Visual Editor

DbSchema's diagram editor lets you create and edit Exasol tables, select column types suited to Exasol's analytical SQL dialect, and define constraints and relationships on the canvas. The editor generates Exasol-compatible DDL that can be applied directly or exported as a migration script for peer review.

Write and Execute Exasol SQL

The SQL editor in DbSchema supports Exasol's SQL syntax with highlighting and result display in a tabular grid. Write analytical queries — including Exasol-specific functions and window operations — and execute them directly against the in-memory engine to take advantage of its sub-second response times for large aggregations.

Explore and Validate Table Data

The data explorer lets you browse Exasol table contents row by row, apply column filters, and paginate through results without writing a query. Use this to verify ETL pipeline output, audit data quality after batch loads, or inspect the contents of virtual schema tables backed by external sources.

Steps to Connect DbSchema to Exasol

Getting your first Exasol ER diagram on screen takes four steps:

1. Install DbSchema on your platform of choice — Windows, macOS, or Linux.
2. Open the connection wizard, select Exasol, and register the Exasol JDBC driver (downloaded from the Exasol download portal) via DbSchema's driver manager.
3. Enter the host and Exasol's default JDBC port 8563, following the URL format jdbc:exa:host:8563. For EXACloud or self-hosted deployments with TLS enabled, use the cluster's primary IP address.
4. Connect — DbSchema pulls in both standard schemas and virtual schemas and builds the diagram.

On non-production environments using self-signed certificates, append ;validateservercertificate=0 to the JDBC URL to suppress certificate validation errors during initial setup.

Why Exasol Users Pick DbSchema

• Visualize both physical schemas and virtual schemas in a unified ER diagram
• Write Exasol SQL with syntax support and execute against the in-memory engine
• Explore and validate table data interactively without a separate query client
• Document the Exasol data warehouse schema for analytics team reference
• Design schema changes visually and generate Exasol-compatible DDL for deployment

Physical tables and virtual schemas over S3 or Hive both belong on the same diagram. Download DbSchema free and give your Exasol warehouse the visual model it is missing.

Related databases

Teams working with Exasol often use these engines too. Explore dedicated guides and JDBC setup for each.

• Amazon Athena
• Amazon Timestream
• Azure Synapse
• ClickHouse
• Databricks
• Dataverse

Browse all 100+ supported databases