Fabric Notebooks communication to on-premise SQL with jdbc driver

[Anonymous]

Hello,

We have a scenario that we need to access on-premise data on SLQ server from microsoft fabric using notebooks with jdbc driver. Is that scenario supported because as i have seen on-premise gateway does not support jdbc.

Thanks in advance

Yannis

[franklloydtehew]

Based on my readings Fabric Notebooks do not support data gateways (On Premise or VNet). Though I would love to see this being supported. A few months ago, a Fabric Notebook connection to Azure Resources using private links were also not supported - but now it is. Hopefully this is comming soon. 

[Anonymous]

Hi @Anonymous ,

Using notebooks from Microsoft Fabric to connect to local SQL Server via the JDBC driver is a bit tricky. The local gateway does not support JDBC.

But try connecting to SQL Server using pyodbc, which may be an alternative. See below for a similar solution:

Solved: JDBC connection to Fabric Lakehouse SQL endpoint u... - Microsoft Fabric Community

Best Regards,
Adamk Kong

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.