Download Dataverse JDBC Driver

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

About the Dataverse JDBC driver

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

The Dataverse JDBC driver

Microsoft Dataverse is a cloud-based data platform that underlies Microsoft Power Apps, Power Automate, and Dynamics 365, providing a secure and scalable data storage service for business applications. It exposes a TDS (Tabular Data Stream) endpoint allowing read-only T-SQL queries against Dataverse tables using standard SQL tooling. Dataverse supports complex data models including relationships, business rules, and role-based access control.

The Microsoft Dataverse JDBC URL

• Required File(s): mssql-jdbc-xxx.jar
• Java Driver Class: com.microsoft.sqlserver.jdbc.SQLServerDriver
• JDBC URL: jdbc:sqlserver://{HOST}:5558;database={DB}
• Website: Microsoft Dataverse Developer Documentation

Microsoft Dataverse exposes a TDS (Tabular Data Stream) endpoint on port 5558 that accepts read-only T-SQL queries. Authentication is via Azure Active Directory (Azure AD). Use authentication=ActiveDirectoryPassword or authentication=ActiveDirectoryInteractive in the JDBC URL. The TDS endpoint is available for Dataverse environments in Power Apps.

DbSchema and Microsoft Dataverse

DbSchema connects to Microsoft Dataverse via the TDS endpoint using the SQL Server JDBC driver, enabling visualization of Dataverse table schemas, running read-only T-SQL queries against Dataverse data, and documenting Power Platform data structures for enterprise governance.