Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
dhorrall
Frequent Visitor

JDBC Connection to Fabric Synapse Warehouse

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. 

1 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.

     
     
    PRADEEPCHMSFT_1-1685946516679.png 
  2. Select Test connection, and Finish.

     
    PRADEEPCHMSFT_2-1685946586578.png

     

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.

View solution in original post

1 REPLY 1

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

     
     
    PRADEEPCHMSFT_1-1685946516679.png 
  2. Select Test connection, and Finish.

     
    PRADEEPCHMSFT_2-1685946586578.png

     

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.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.