Visualize SAP HANA Schemas Without HANA Studio

Connect DbSchema to SAP HANA and turn the live schema into an editable visual model: explore relationships in interactive ER diagrams, plan changes on the canvas, and generate reviewed SQL scripts for deployment.

The workflow is designed 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 SAP HANA Features Download SAP HANA JDBC Driver · All drivers

What happens after you download?

Get to your first SAP HANA schema diagram in minutes. No account, no credit card.

Install in minutes

Download the installer for Windows, macOS, or Linux and launch DbSchema. No signup required.

Connect to SAP HANA or open a sample

Reverse engineer an existing SAP HANA database or open a sample model to explore tables, relationships, and indexes.

Design, document, and deploy

Edit schema visually, generate documentation, and prepare reviewed migration scripts for safer releases.

Get Started Free

Schema Visualization for SAP HANA's In-Memory Architecture

SAP HANA is an in-memory column-store database that organizes data into schemas containing tables, views, calculation views, and analytic privileges. In complex SAP landscapes, a single HANA instance can contain dozens of application schemas, making it challenging to track data structures and cross-schema dependencies. DbSchema provides a visual layer over HANA's schema catalog, letting architects map out table structures, foreign keys, and cross-schema relationships without writing system-view queries by hand.

Everything described above — the ER diagram and the SQL editor — ships in the free Community edition, at no cost to try. If your team also wants to save the HANA model to a file and version it in Git the way application code is versioned, that capability sits in Pro, unlocked by the same 15-day trial included with the installer.

Download DbSchema Free See SAP HANA Features

Interactive ER Diagrams for HANA Schema Objects

DbSchema reads HANA's catalog views to build an interactive ER diagram of your schema objects. You can explore tables, column views, and relationships across multiple HANA schemas on a single canvas — particularly valuable when navigating SAP S/4HANA or BW/4HANA schemas with hundreds of interdependent tables.

Viewing and editing SAP HANA schemas visually in DbSchema

HANA SQL Editor for Direct Query Execution

The DbSchema SQL editor connects directly to your HANA instance and supports HANA's SQL dialect, including system view queries and column store functions. Run queries, inspect row counts, and validate data without switching to HANA Studio or the SAP Web IDE.

Executing HANA SQL queries in DbSchema's SQL editor

Schema Documentation for SAP Architects

DbSchema generates comprehensive HTML documentation from your HANA schema, covering all tables, views, column types, primary keys, and relationships. For SAP implementation teams, this documentation provides a reliable reference that non-technical stakeholders can review without direct HANA system access.

Auto-generated SAP HANA schema documentation in DbSchema

How to Connect DbSchema to SAP HANA

No SAP GUI installation is needed — DbSchema talks to HANA directly over JDBC:

Install DbSchema.
Download the SAP HANA JDBC driver (ngdbc.jar) from the SAP Development Tools page and add it via Connections > Manage Drivers.
Create a new connection with the host and JDBC port — 39015 for single-container systems, or 3[instance]15 for multi-tenant systems (for example, 30015 for instance 00) — producing a URL like jdbc:sap://host:39015?databaseName=HXE.
Connect — DbSchema queries the catalog views and lays out the ER diagram across your HANA schemas.

For HANA Cloud, use the cloud instance hostname in place of the on-premises host, and make sure your IP address is included in the HANA Cloud allowed IP list before attempting a connection.

What You Gain Pairing DbSchema with SAP HANA

Navigate complex SAP S/4HANA or BW/4HANA schema structures with an interactive ER diagram
Browse multiple HANA schemas side-by-side on a single diagram canvas
Run HANA SQL and system view queries from a desktop client
Generate documentation for HANA schemas used in SAP implementation projects
Compare schema versions between HANA development and production systems

Bring your S/4HANA or BW/4HANA schema into a single browsable view — download DbSchema for free and connect to SAP HANA without touching HANA Studio.

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