Download Fabric Lakehouse JDBC Driver

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

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

About the Fabric Lakehouse JDBC driver

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

The Fabric Lakehouse JDBC driver

Microsoft Fabric Lakehouse is a unified data lakehouse platform within Microsoft Fabric that combines the flexibility of data lake storage with the structure and query performance of a data warehouse. It stores data in Delta Lake format on OneLake and exposes a SQL Analytics Endpoint for standard SQL querying using familiar tools. Fabric Lakehouse integrates with Power BI, Azure Synapse, and other Microsoft data services for end-to-end analytics.

The Microsoft Fabric Lakehouse JDBC URL

  • Required File(s): mssql-jdbc-xxx.jar
  • Java Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
  • JDBC URL: jdbc:sqlserver://{HOST}:1433;database={DB};authentication=ActiveDirectoryPassword;encrypt=True
  • Website: Microsoft Fabric Documentation

Microsoft Fabric Lakehouse provides a SQL Analytics Endpoint accessible via the SQL Server JDBC driver on port 1433. Authentication requires Azure Active Directory credentials. The connection string is available from the Fabric workspace settings. Use encrypt=True;trustServerCertificate=False for production connections.

DbSchema and Microsoft Fabric Lakehouse

DbSchema connects to Microsoft Fabric Lakehouse via the SQL Analytics Endpoint using the SQL Server JDBC driver, enabling visualization of Delta Lake table schemas, SQL query execution against Fabric Lakehouse data, and schema documentation for enterprise data lakehouse architectures.

Test the driver with DbSchema

Connect Fabric Lakehouse, build your first ER diagram in minutes. No account required.

1
Download driver & DbSchema

Get the Fabric Lakehouse 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 Fabric Lakehouse, edit the model visually, and publish schema documentation.

Free DbSchema Download

Use Fabric Lakehouse 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 Fabric Lakehouse 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 Fabric Lakehouse guide

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

Fabric Lakehouse guide

Other drivers teams often configure alongside Fabric Lakehouse.

Browse all JDBC driver downloads

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

Browse all 100+ supported databases