I am new to Fabric, is it possible to get data into data pipeline from Azure MySQL database?

[theadventurer]

Question 1:
I am using Fabric Data Warehouse and my data is stored at Azure MySQL database. How can I fetch data from it, I only see the below Azure connectors?

Question 2:

Currently my only option is to get data via Dataflow Gen 2 (as I have ODBC connection to Azure MySQL). I am not sure if this affects performance issues if i use direct connection to azure vs odbc via data gateway. 

[areebkanwar]

Hi,

Thank you for your question.

Please type MySQL and you will see the option! I know the search is a bit annoying in Fabric. :3 

Thanks! 

[DennesTorres · Accepted solution]

Hi,

Use dataflow gen2 to access mysql.

Yes, data gateway affects performance, if you don't need to use it, after considering all security consequences, don't use it.

Kind Regards,

Dennes