Design and Manage SAP MaxDB Databases Visually with DbSchema

DbSchema lets you design, manage, and document SAP MaxDB 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 MaxDB 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 MaxDB JDBC Driver

Visual Schema Tools for SAP MaxDB and NetWeaver Environments

SAP MaxDB (originally known as SAPDB) is an enterprise-grade relational database tightly integrated with SAP NetWeaver application servers. While less widely known than SAP HANA, MaxDB remains in active use in SAP R/3, ECC, and industry-specific SAP installations. DbSchema provides a modern visual interface for exploring MaxDB schemas, making it practical for SAP Basis administrators and developers to document and maintain database structures without relying solely on command-line tools.

ER Diagrams for MaxDB Schema Structures

DbSchema connects to SAP MaxDB and reads the schema catalog, displaying tables, views, and foreign key constraints as an interactive entity-relationship diagram. This is especially useful for large SAP installations where the database schema contains hundreds of tables with complex interdependencies that are difficult to trace through system queries alone.

Visualizing SAP MaxDB schema tables and relationships in DbSchema

SQL Editor with MaxDB Syntax

DbSchema's SQL editor supports MaxDB's SQL dialect, allowing you to run queries, inspect stored procedures, and validate table data directly from the application. This removes the need to switch between separate tools when exploring or troubleshooting a MaxDB installation in an SAP landscape.

Running SQL queries against SAP MaxDB in DbSchema's SQL editor

Schema Documentation for SAP Basis Teams

Documentation for SAP MaxDB databases is often limited to system-generated exports or manually maintained spreadsheets. DbSchema auto-generates navigable HTML documentation from the live schema, capturing table descriptions, column data types, indexes, and relationship diagrams — suitable for system auditors or new team members who need a reliable structural reference.

Auto-generated SAP MaxDB schema documentation in DbSchema

Connecting DbSchema to SAP MaxDB

SAP MaxDB listens on port 7210 by default. The JDBC URL format is: jdbc:sapdb://host:7210/dbname. The JDBC driver class is com.sap.dbtech.jdbc.DriverSapDB. Download the SAP MaxDB JDBC driver from the SAP MaxDB developer tools package (available on the SAP Community Network) and add the JAR via DbSchema's driver manager under Connections > Manage Drivers. Ensure the MaxDB X Server service is running and accepting TCP connections on the configured port before attempting a connection.

Why DbSchema for SAP MaxDB

  • Visualize MaxDB table structures and relationships without relying on command-line tools
  • Generate documentation for SAP NetWeaver database schemas for audit and handoff
  • Edit table structures and column definitions through a graphical interface
  • Compare schema differences between MaxDB instances across SAP landscapes
  • Work with MaxDB schemas offline using DbSchema's local model storage