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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
dhorrall
Helper I
Helper I

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

3 REPLIES 3

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

Where do I find those options?

Did you ever find where to see those options?

 

Helpful resources

Announcements
Expanding the Synapse Forums

New forum boards available in Synapse

Ask questions in Data Engineering, Data Science, Data Warehouse and General Discussion.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayFBCUpdateCarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.