Chart Cross-Database Relationships in SAP ASE

DbSchema gives SAP Adaptive Server Enterprise teams a design-first workflow: import the existing schema as an interactive ER diagram, refine it visually, and ship every change as a reviewed SQL script.

Built for visual modeling, schema documentation, and deployment, with an offline model you can keep in Git, team collaboration, and 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 · All drivers

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.

The cross-database reverse engineering and the T-SQL editor shown above cost nothing — both are included in the Community download. Where Pro comes in is comparing two ASE environments directly: it works out the gap between them and writes the migration script needed to close it.

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.

Getting DbSchema Connected to SAP Adaptive Server Enterprise

Connecting DbSchema to an Adaptive Server Enterprise instance involves picking a driver, then supplying the server details:

1. Install DbSchema on Windows, macOS, or Linux.
2. Download a JDBC driver JAR — either the open-source jTDS driver (from SourceForge) or the SAP JDBC4 driver (from the SAP Support Portal) — and register it under Connections > Manage Drivers.
3. Select the matching driver class: net.sourceforge.jtds.jdbc.Driver for jTDS, or com.sybase.jdbc4.jdbc.SybDriver for SAP JDBC4.
4. Enter the host and port — 5000 by default — which together with the database name form jdbc:sybase:Tds:host:5000/dbname.
5. Once connected, DbSchema pulls the catalog across every accessible ASE database into one diagram.

Before connecting, confirm network connections are enabled on the ASE server and that the target login has access to the required databases.

The Case for Running DbSchema Against 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

Stop tracing SAP ASE cross-database joins by hand — download DbSchema for free and see every dependency across your ASE databases on one canvas.

Related databases

Teams working with SAP Adaptive Server Enterprise often use these engines too. Explore dedicated guides and JDBC setup for each.

• Access
• Aurora MySql
• Aurora PostgreSQL
• AzureSQL
• Cache
• Cockroach

Browse all 100+ supported databases