Anyone got an idea of the difference between the Azure Database for MySQL connector and the MySQL connector. I need to create a Linked Service to extract data from a VNet Peered MySQL database. All help gratefully received.
FYI, when I test the Linked Service connection, I'm getting timeout. SSL is required.
Azure MySQL connector is for MYSQL stored and managed by Microsoft as a service on Azure. The MYSQL connector is for MySQL on your on-prem environment or on a virtual machine in Azure.
If your MySQL server is in your own Vnet, and cannot be accessed from outside by data factory, you need to install a Self hosted integration runtime service inside your Vnet, to connect between MySQL and data factory.