topic JDBC Connection to Fabric Synapse Warehouse in Data Warehouse

JDBC Connection to Fabric Synapse Warehouse

dhorrall — Thu, 25 May 2023 10:20:57 GMT

I use a third party query tool that uses SQL Server JDBC. Should this currently work to query Fabric Synapse? I am getting a timeout.

Anonymous — Mon, 05 Jun 2023 06:35:37 GMT

dhorrall - Microsoft Microsoft Fabric also supports connectivity to the Warehouse or SQL Endpoint using a Java database connectivity (JDBC) driver.

When establishing connectivity via JDBC, check for the following dependencies:

Add artifacts, choose Add Artifact and add the following four dependencies in the window like this, then select Download/Update to load all dependencies.
Select Test connection, and Finish.

Hope this helps. Do let us know if you any further queries.

joearus — Tue, 07 May 2024 07:47:40 GMT

Where do I find those options?

Javier_greens — Thu, 23 May 2024 16:27:43 GMT

Did you ever find where to see those options?