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

EJ Marmonti 141 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.
723 questions
Azure Data Factory
Azure Data Factory
An Azure service for ingesting, preparing, and transforming data at scale.
9,697 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Zhihong He | WMDA 0 Reputation points
    2023-07-31T08:57:15.25+00:00

    Just want to give information on this. The work around as mentioned above did works for Postgresql flexible DB.

    https://learn.microsoft.com/en-us/azure/data-factory/tutorial-managed-virtual-network-sql-managed-instance

    Hope Azure will provide private endpoint service to flexible DB for mysql and postgresql in short near future as the single server will be retired in 1 and half year.

    0 comments No comments