1

I am trying to create and use Azure data factory by Rest API but while creation of linked service connection has created successfully but when I checked connection it got failed so is there anything to do test connection by API or PowerShell command.

Sudarshan Sharma
  • 105
  • 1
  • 11

2 Answers2

1

There is no this method in Microsoft documentation.You can track this feature here.

But there is a blog about testing link service by PowerShell.Here is the script on github.

Hope this can help you.

Steve Johnson
  • 8,057
  • 1
  • 6
  • 17
0

Now, you can use one of cmdlet in azure.datafactory.tools PowerShell module:
Test connection of Linked Service (preview)

# Example 1
$LinkedServiceName = 'AzureSqlDatabase1'      
Test-AdfLinkedService @params -LinkedServiceName $LinkedServiceName

Alternatively, if you prefer, you can run such test as part of your CI/CD process in Azure DevOps installing #adftools extension, which uses the same PS module behind the scenes.
More: https://sqlplayer.net/adftools

Disclaimer: I'm author of the tool.

Kamil Nowinski
  • 486
  • 3
  • 9