How to connect to an Amazon RDS MySQL database via VPN from a Fabric notebook?

Hi Gmarqs ,

Thanks for your question. Connecting to an Amazon RDS MySQL database via VPN from a Microsoft Fabric notebook does present some limitations due to current support constraints, but there are several viable workarounds depending on your environment and needs.

Option 1: Ingest via Data Pipeline or Dataflow Gen2
Since on-premises data gateways are not currently supported within notebooks, a recommended approach is to first ingest your data into a Fabric Lakehouse using a Data pipeline or Dataflow Gen2. Once the data resides in the Lakehouse, you can query it seamlessly using notebooks.

A related discussion here  includes a suggestion to utilize views for better data management when adopting this pipeline.

Option 2: Use an ODBC Connector
You can also consider connecting to your RDS database using an ODBC connector from an environment that has VPN access and then transferring the data into Fabric.
Solved: Connect to AWS RDS via VPN - Microsoft Fabric Community

Option 3: VNet Gateway & Notebook Access
If your setup includes secure or private network access (like through a VPN or VNet), it’s possible to connect from a notebook using a custom script. A Microsoft consultant shared an example showing how to do this by setting up a connection through a VNet gateway.
Solved: Re: Using a VNet gateway with Notebooks - Microsoft Fabric Community

Option 4: Managed Private Endpoints.
You might consider using Managed Private Endpoints. This feature lets Fabric securely connect to services like AWS RDS without using a VPN, by setting up a private network path.
About private Links for secure access to Fabric - Microsoft Fabric | Microsoft Learn

Hope this helps. Please reach out for further assistance.
If this post helps, then please consider "Accept it as the solution" to help the other members find it more quickly and a kudos would be appreciated.

Hello finaly we do export file out of fabric and ingest file