Fabric Networking - Data Integration

We have a legacy 'on prem' RDBMS system that requires either a Gateway or a SHIR to connect (we're going with the former in the first instance).
We have a 'push' method from the RDBMS system that connects to Fabric/OneLake via API, uploads a parquet file, and writes/executes a notebook to convert to a Delta table, but will actually need a 'pull' form Fabric for our final state.

Hi royclack ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you spencer_sa for the prompt response.

Use Fabric Data Factory to replicate data from RDBMS or HTTPS endpoints, then apply Dataflows or Notebooks for transformations. For secure network access, deploy a Managed VNET and self-hosted integration runtime (SHIR) to reach on-prem or private endpoints and maintain a known outbound IP for whitelisting. This modernizes your legacy VM setup while keeping security intact.

Here are some Microsoft Documentations for your reference:

Overview of managed virtual networks in Microsoft Fabric - Microsoft Fabric | Microsoft Learn

Create a self-hosted integration runtime - Azure Data Factory & Azure Synapse | Microsoft Learn