Forum Discussion
Solved
Moving Data from Azure MySQL DB to MS Fabric in near real time
what is the best way to load data from Azure Mysql DB to Fabric Onelake in real time or near real time ( 15 mins latency )
You should use MySQL database as a source in Dataflow Gen 2. You will end up to Lakehouse as a destination. ( it is in ~ 5 minutes latency in Dataflow Gen 2 )
3 Replies
- lbendlin
Super User
I don't think Mirroring is available yet for that source, so I'd say data pipelines?
- BhaveshPatel
You should use MySQL database as a source in Dataflow Gen 2. You will end up to Lakehouse as a destination. ( it is in ~ 5 minutes latency in Dataflow Gen 2 )
To use Data factory do we need to enable the CDC on mySQL DB
