0

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://learn.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 ?

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
Pரதீப்
  • 91,748
  • 19
  • 131
  • 172

3 Answers3

0

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://learn.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://learn.microsoft.com/en-us/azure/data-factory/connector-sql-server

Venkataraman R
  • 12,181
  • 2
  • 31
  • 58
  • This is On-Premises Sql Server. I am talking about this [Managed Instance](https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance) – Pரதீப் Aug 06 '18 at 08:32
  • To clarify, the screenshot you have showed is On-Premises Sql Server, but am talking about, [Managed Instance](https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance) Azure service. Or am I missing something here ? – Pரதீப் Aug 06 '18 at 08:46
  • @Pரதீப் Sorry. I misunderstood your question. I will update it. – Venkataraman R Aug 06 '18 at 09:04
  • From the ServerEdition of Managed Instance mentioned https://learn.microsoft.com/en-us/azure/sql-database/sql-database-managed-instance, it is Azure SQL. So, you can connect to it similar to Azure SQL, i think. Please give a try. `SERVERPROPERTY ('Edition') SQL Azure` – Venkataraman R Aug 06 '18 at 09:07
0

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.

Alberto Morillo
  • 13,893
  • 2
  • 24
  • 30
0

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

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

Mike Ubezzi
  • 1,007
  • 6
  • 8