Download SAP Adaptive Server JDBC Driver

Download the SAP Adaptive Server JDBC driver, copy the JDBC URL into DbSchema, and start designing schemas with ER diagrams — free Community Edition.

About the SAP Adaptive Server JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to SAP Adaptive Server. DbSchema uses JDBC to reverse engineer schemas, run SQL, and generate documentation. Driver files are usually published by the database vendor or an open-source project.

JDBC URL format

Host, port, database name, and SSL options are passed in a URL starting with jdbc:. Each SAP Adaptive Server driver uses its own syntax — see the connection details below.

The SAP Adaptive Server JDBC driver

SAP Adaptive Server Enterprise (ASE), formerly known as Sybase ASE, is an enterprise RDBMS commonly used in banking, telecommunications, and high-frequency trading. It is known for its T-SQL dialect, in-memory row store, and Sybase-compatible applications.

The SAP Adaptive Server JDBC URL

• Required File(s): jtds-1.2.2.jar
• Java Driver Class: net.sourceforge.jtds.jdbc.Driver
• JDBC URL: jdbc:sybase:Tds:HOST:PORT/DB
• Website: JTDS

Download SAP Adaptive Server JDBC Driver

The driver archive is a zip file. Extract it and load the .jar files using DbSchema's Driver Manager.

Connecting to SAP Adaptive Server

ASE decides where it listens from a file rather than from a single setting, and that file is on the server.

1. Read the listen address from the interfaces file. ASE takes its host and port from interfaces on Unix or sql.ini on Windows, under the server's own name. That entry is the authority on what to put in the Connection Dialog — an entry naming localhost means no remote client can connect until it is changed and the server restarted.
2. Check the port. DbSchema prefills 5000, the value SAP's own installers commonly suggest, but it is chosen at installation time. The interfaces file has the real one.
3. Pick the right driver entry. The Connection Mode combo offers jTDS and several jConnect versions. jTDS is open source and needs no SAP download; jConnect comes from SAP and matches newer server features. Both speak TDS to the same port.
4. Open port 5000 in the server's firewall. The database listens on port 5000 unless it was installed with a different one. A host firewall on the server blocks incoming connections on that port until a rule allows them. The firewall guide has the commands for Windows, ufw, firewalld and iptables.
5. Connect from DbSchema. In the Connection Dialog choose Remote computer or custom port, fill in the server host and the port, then press Test Connection to check that the server answers before you connect.

DbSchema and SAP Adaptive Server

DbSchema connects to SAP ASE using the jConnect or jTDS JDBC driver and renders complex schemas including partitioned tables, indexes, and Sybase-specific stored procedures as navigable ER diagrams.