Download Azure Synapse JDBC Driver

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

Connect Azure Synapse in DbSchema Install the driver, open a connection, reverse engineer your schema, and sync changes visually.
Azure Synapse guide Free Download

About the Azure Synapse JDBC driver

A JDBC driver is a Java .jar library that lets applications connect to Azure Synapse. 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 Azure Synapse driver uses its own syntax — see the connection details below.

The Azure Synapse JDBC driver

Azure Synapse Analytics is Microsoft's enterprise analytics service that combines big data and data warehousing. It provides dedicated SQL pools (formerly SQL DW) and serverless SQL pools for querying data lakes — all integrated with Azure Data Lake Storage.

The Azure Synapse JDBC URL

  • Required File(s): mssql-jdbc-12.8.0.jre11.jar
  • Java Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • JDBC URL: jdbc:sqlserver://HOST:1433;user=USER;password=PASSWORD;database=DB;encrypt=true;trustServerCertificate=true;hostNameInCertificate=*.database.windows.net;loginTimeout=30;
  • Website: Azure Synapse

Download Azure Synapse JDBC Driver

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

DbSchema and Azure Synapse

DbSchema connects to Azure Synapse dedicated SQL pools using the SQL Server JDBC driver and renders distribution tables, hash-distributed and replicated table types in the schema diagram. Use the SQL Editor for Synapse-specific T-SQL including PolyBase and CETAS statements.

Test the driver with DbSchema

Connect Azure Synapse, build your first ER diagram in minutes. No account required.

1
Download driver & DbSchema

Get the Azure Synapse driver zip below and install DbSchema for Windows, macOS, or Linux.

2
Register the .jar

In DbSchema, open Driver Manager, add the extracted JAR, and paste your JDBC URL.

3
Design & document

Reverse engineer Azure Synapse, edit the model visually, and publish schema documentation.

Free DbSchema Download

Use Azure Synapse visually in DbSchema

After the JDBC driver connects, you get ER diagrams, SQL editor, schema sync, and HTML documentation in one desktop app. Compare DbSchema editions.

ER diagrams

Reverse engineer Azure Synapse into an interactive diagram and edit structures visually.

SQL & query builder

Run SQL with autocomplete or compose queries without writing every join by hand.

Schema documentation

Export HTML docs your team can browse without installing DbSchema.

Full Azure Synapse guide

Connection tips, ports, SSL, and schema design workflows on the database landing page.

Azure Synapse guide

Other drivers teams often configure alongside Azure Synapse.

Browse all JDBC driver downloads

Teams working with Azure Synapse often use these engines too. Explore dedicated guides and JDBC setup for each.

Browse all 100+ supported databases