Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
1 year ago
Solved

From notebook, with jdbc connector, we can't connect to SQL Virtual Machine (legacy)

We are developing a new Data Platform on Fabric and we need to write data from Fabric notebook to a SQLVM (legacy), as part of our immediate release. From notebook, with jdbc connector, we can't conn...
  • nilendraFabric's avatar
    1 year ago

    Hello Anonymous 

     

    Microsoft Fabric notebooks cannot use on-premises data gateways for connectivity to legacy SQL VMs or other on-prem resources

     

    From the Fabric security documentation on Private Links:
    “For Fabric users: On-premises data gateways aren’t supported and fail to register when Private Link is enabled. To run the gateway, disable Private Link for the tenant.”

     

    https://learn.microsoft.com/en-us/fabric/security/security-private-links-overview

     

     


    This limitation applies specifically to notebooks due to their reliance on Spark clusters, which operate in isolated managed virtual networks.

     

    In contrast, other Fabric tools like Dataflows Gen2 and Pipelines fully support on-premises gateways for secure data integration.
    For notebooks, Microsoft recommends:
    • Using Dataflows Gen2 (low-code ETL with gateway support) or Pipelines (gateway-enabled data orchestration) instead.
    • Avoiding direct SQL VM exposure by staging data in OneLake or Azure Blob Storage first