topic Re: Fabric Notebooks communication to on-premise SQL with jdbc driver in Pipelines

Fabric Notebooks communication to on-premise SQL with jdbc driver

Anonymous — Mon, 29 Jul 2024 08:58:22 GMT

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

Re: Fabric Notebooks communication to on-premise SQL with jdbc driver

Anonymous — Tue, 30 Jul 2024 01:31:13 GMT

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.

Re: Fabric Notebooks communication to on-premise SQL with jdbc driver

franklloydtehew — Thu, 03 Oct 2024 15:19:36 GMT

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.