Design and Manage SAP Adaptive Server Enterprise Databases with DbSchema
Build a clearer workflow for SAP Adaptive Server Enterprise: 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.
Download DbSchema See SAP Adaptive Server Enterprise Features Download SAP Adaptive Server Enterprise JDBC Driver
What happens after you download?
Get to your first SAP Adaptive Server Enterprise 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 Adaptive Server Enterprise or open a sample
Reverse engineer an existing SAP Adaptive Server Enterprise 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.
Visual Schema Design for SAP Adaptive Server Enterprise
SAP Adaptive Server Enterprise (formerly Sybase ASE) is an enterprise relational database with a multi-database architecture and T-SQL as its query language. Large ASE installations often span dozens of databases within a single server instance, with stored procedures, triggers, and cross-database joins making schema relationships difficult to track. DbSchema renders these relationships visually, letting your team navigate the full schema landscape without querying system tables manually.
Download DbSchema Free See SAP Adaptive Server Enterprise Features
Visualize Cross-Database Relationships on a Single Canvas
DbSchema connects to SAP ASE and reads the system catalog across all databases on the server. You can drag tables from multiple ASE databases onto a single ER diagram canvas to document cross-database relationships and trace foreign-key dependencies that span database boundaries.
T-SQL Editor with ASE Syntax Support
The built-in SQL editor in DbSchema supports T-SQL syntax used by SAP ASE, including stored procedure calls, batch separators, and proprietary ASE functions. Run queries directly against your ASE instance and review results in a tabular view without leaving the schema designer.
Auto-Generated Schema Documentation for Compliance Teams
DbSchema generates HTML documentation from your ASE schema, including table definitions, column types, indexes, and foreign key relationships. This is particularly useful for compliance audits where teams need a static, shareable record of the database structure that can be reviewed without live database access.
Connecting DbSchema to SAP Adaptive Server Enterprise
SAP ASE listens on port 5000 by default. The JDBC URL format is:
jdbc:sybase:Tds:host:5000/dbname.
Two JDBC drivers are supported: the open-source jTDS driver (available from SourceForge)
and the SAP JDBC4 driver (available from the SAP Support Portal).
After downloading the JAR, add it via DbSchema's driver manager under Connections > Manage Drivers.
For jTDS, the driver class is net.sourceforge.jtds.jdbc.Driver; for SAP JDBC4, use
com.sybase.jdbc4.jdbc.SybDriver. Ensure network connections are enabled on the ASE server
and the target login has access to the required databases.
Why DbSchema for SAP ASE
- Visualize schemas across multiple ASE databases on a single diagram canvas
- Edit table structures and column definitions directly through the DbSchema interface
- Generate shareable HTML documentation with diagrams for compliance and audit purposes
- Compare schema versions between development and production ASE instances
- Store schema models locally and work offline when the ASE server is not accessible