SAP HANA runs entire S/4HANA and BW/4HANA landscapes from an in-memory column store — and scatters their data structures across dozens of application schemas. DbSchema reads HANA's catalog views and gives architects interactive ER diagrams, a desktop SQL client, and shareable documentation.
Trusted by teams at
The platform answers analytical queries in memory, instantly — but ask it how its own schemas relate and you are writing catalog-view queries by hand. In a grown SAP landscape, hundreds of interdependent tables hide behind schema boundaries no single screen shows.
DbSchema builds that missing screen: an interactive ER diagram assembled from HANA's catalog views, spanning every schema your user can reach.
For the architects who keep S/4HANA and BW/4HANA understandable.
Place tables, column views, and relationships from multiple HANA schemas side by side, then split the landscape into focused, color-coded diagrams.
Run HANA SQL — system view queries and column store functions included — inspect row counts, and validate data without opening HANA Studio or the Web IDE.
Generate HTML documentation of tables, views, column types, primary keys, and relationships — a reference implementation teams hand to non-technical reviewers.
The ER diagram and the SQL editor ship free in the Community edition. Pro saves the HANA schema as a model file for Git — branch it, diff it, review it like application code — and compares development against production systems. The same 15-day trial in the installer unlocks it.
DbSchema reaches HANA directly over JDBC — no SAP GUI required. Download the SAP HANA
JDBC driver (ngdbc.jar) from the SAP Development Tools page and register it
under Connections > Manage Drivers. Single-container systems listen on port
39015; multi-tenant systems use 3[instance]15 —
30015 for instance 00 — giving a URL like
jdbc:sap://host:39015?databaseName=HXE.
For HANA Cloud, swap in the cloud instance hostname and add your IP address to the allowed IP list before connecting. The SAP HANA JDBC driver page has the full walkthrough.
Free Community Edition and the 15-day Architect trial arrive in one installer — no signup.
Teams working with SAP HANA often use these engines too. Explore dedicated guides and JDBC setup for each.