Design and Manage SAP HANA Databases Visually with DbSchema

DbSchema lets you design, manage, and document SAP HANA databases. Create ER diagrams, define tables and columns, and generate SQL scripts - with or without a live database connection.

Use Git to share the design, compare it with the SAP HANA database, and deploy changes. DbSchema also includes a data editor, query builder, and HTML5 documentation - everything you need in one tool.

DbSchema Database Designer

Download DbSchema Download SAP HANA JDBC Driver

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.

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