Can Azure Data Factory connect to Azure MySql Flexible via private endpoints?

EJ Marmonti 126 Reputation points
2022-04-08T12:58:54.11+00:00

I have an Azure MySql Flexible instance, and an Azure Data Factory instance. Both resources are in the same subscription, connected to private endpoint on the same vnet (each in it's own /29 subnet).

On my Data Factory instance, I followed the steps at https://learn.microsoft.com/en-us/azure/data-factory/tutorial-copy-data-portal-private to "Create a managed private endpoint" to create the private endpoint/vnet integration runtime.

Here's where the problem is:

  • I create a new pipeline, add a "Copy data" step
  • I add a new linked service (choosing the private endpoint integration runtime I created in previous step, with the vnet enabled).
  • Then I choose the "From Azure subscription" account selection method and select my database.
  • Under the "Managed private endpoint" area, I select "Create new".
  • At this point, it opens a "New managed private endpoint (Azure Database for MySQL)" screen, with a Name populated, and this is in the Account selection method / Enter manually box: /subscriptions/xxxxxxx/resourceGroups/{name-of-my-resource-group}/providers/Microsoft.DBforMySQL/flexibleServers/{name-of-my-flexible-server}, but it gives me the error "Invalid resource ID format. Use the following format: "/subscriptions/<subscriptionID>/resourceGroups/<resourceGroupName>/providers/Microsoft.DBforMySQL/servers/<resourceName>". The suggested format it displays basically says to me that it only supports Microsoft.DBforMySQL/servers, and not Microsoft.DBforMySQL/flexibleServers.
  • If I select the "From Azure subscription" radio button, it lists my other Azure MySql standalone (non-flexible) instances, but it does not list my Flexible instance.

Does this mean that Azure MySql Flexible connections are not currently supported in Data Factory? (In which case, it looks like "flexible" MySql instances are literally not actually that flexible).

Regards

Azure Database for MySQL
Azure Database for MySQL
An Azure managed MySQL database service for app development and deployment.
503 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
7,173 questions
{count} vote