Design and Manage SAP HANA Databases with DbSchema

Build a clearer workflow for SAP HANA: 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.

DbSchema Database Designer

Download DbSchema See SAP HANA Features Download SAP HANA JDBC Driver

What happens after you download?

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

1
Install in minutes

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

2
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.

3
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.

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

Connecting DbSchema to SAP HANA

For single-container HANA systems, the default JDBC port is 39015. Multi-tenant systems use port 3[instance]15 (e.g., 30015 for instance 00). The JDBC URL format is: jdbc:sap://host:39015?databaseName=HXE. Download the SAP HANA JDBC driver (ngdbc.jar) from the SAP Development Tools page and add it to DbSchema via Connections > Manage Drivers. No SAP GUI installation is required. For HANA Cloud, use the cloud instance hostname and ensure your IP address is included in the HANA Cloud allowed IP list before attempting a connection.

Why DbSchema for 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