0
votes

I am trying to make the "Managed Instance" as destination in Azure Data Factory(copy data). But, I couldn't see any option to select "Managed Instance" in Linked service.

enter image description here

Here is the list of Azure supported data stores,

enter image description here

Source : https://docs.microsoft.com/en-us/azure/data-factory/concepts-datasets-linked-services#dataset-type

I tried selecting "Azure SQL Database" and entered the managed instance credentials, obviously it didn't work. Is there a workaround for this?

Is there a way to make managed instance as my data store ?

3
Do you mean SQL Server hosted in a VM ?Venkataraman R

3 Answers

0
votes

I hope you mean SQL Server hosted in VM as Managed Instance. Yes. It is supported for copy Activity.

In the link you provided : https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server , I am giving the snapshot of SQL Server.

Sql Server supported in the Database Section Please refer to the link: https://docs.microsoft.com/en-us/azure/data-factory/connector-sql-server

0
votes

For connecting to Azure SQL Managed Instance, you can choose “SQL Server” as the Linked Service type and associate a self-hosted Integration Runtime installed on a VM inside the VNet. Microsoft is planning to add Azure Managed Instance as an option in the near future.

0
votes

Here is a good blog post that discusses how they work together:

Azure SQL Managed Instances and Azure Data Factory: a walk-through