Moving Data from Azure MySQL DB to MS Fabric in near real time

[kiranMaddipati]

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 )

[lbendlin]

I don't think Mirroring is available yet for that source, so I'd say data pipelines?

[kiranMaddipati]

To use Data factory do we need to enable the CDC on mySQL DB 

[BhaveshPatel · Accepted solution]

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 )