none
ADF connectivity to SQL managed instance RRS feed

  • Question

  • Hello Team,

    To connect to an SQL managed instance database via ADF v2, do we need to set up any integration run time ?
    Or can it be connected directly similar to Azure SQL database.(assuming SQL MI is in Azure and ADF is also Azure)

    Thursday, August 1, 2019 12:19 PM

All replies

  • Hi Nandan,

    Thank you for your inquiry. Yes in order to connect any data store we need to setup an Integration Runtime. 
    You can use a self-hosted integration runtime or an Azure integration runtime if your managed instance has a public endpoint and allows Azure Data Factory to access it. If not specified, the default Azure integration runtime is used.

    Please refer to below doc to know more about the properties required for the Azure SQL Database Managed Instance linked service. 

    Hope this helps. 


    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    Thursday, August 1, 2019 4:35 PM
    Moderator
  • Hi Nandan,

    Following up to see if the above suggestion was helpful? If you have any further query, do let us know.


    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    Friday, August 2, 2019 6:48 PM
    Moderator
  •  Hi Nandan,

    Just checking in to see if the above suggestion was helpful. If this answers your query, please do click “Mark as Answer” and Up-Vote, as it might be beneficial to other community members reading this thread. And, if you have any further query do let us know.


    [If a post helps to resolve your issue, please click the "Mark as Answer" of that post and/or click Answered "Vote as helpful" button of that post. By marking a post as Answered and/or Helpful, you help others find the answer faster. ]

    Sunday, August 4, 2019 11:33 PM
    Moderator