JDBC Connection to Fabric Synapse Warehouse

[dhorrall]

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. 

[PRADEEPCH-MSFT · Accepted solution]

@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:

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

    

2. Select Test connection, and Finish.

   

For more details, refer to Connectivity to data warehousing in Microsoft Fabric - Connect using JDBC.

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