Problem Statement :
As of Dec 17,2022 ; One can identify the dependencies on an Integration Runtime in an Azure Data Factory by logging in to the Azure Data Factory via Portal and accessing the Integration Runtime under Manage Section.
And Clicking the Related number values to get the Dependencies details as seen below :
A) Linked Service on Integration Runtime
Also, an Integration Runtime can be shared with other Azure Data Factories, the list of which can be be identified by clicking on the IR name and moving to the Sharing section.
So how can one get the related / dependent objects on an Integration Runtime in an Azure Data Factory in an automated way.
Solution :
- Open Powershell in admin mode and import the Azure SDK modules by executing the below commands :
| Import-Module Az.Accounts Import-Module Az.DataFactory |
2. Install the custom module by executing the below command
| Install-Module -Name AzDataFactoryV2IntegrationRuntimeDependencies |
3. Now the environment is set for us to execute the commands to fetch the pipeline details .
| To get the list of all Integration Runtime in an ADF and its corresponding dependent objects, execute the below command: Get-AzDataFactoryV2IntegrationRuntimeDependencies -ResourceGroupName “<<RGName>>” -DataFactoryName “<<ADFName>>” |
| To get the details of a specific Integration Runtime in an ADF and its corresponding dependent objects, execute the below command: Get-AzDataFactoryV2IntegrationRuntimeDependencies -ResourceGroupName “<<RGName>>” -DataFactoryName “<<ADFName>>” -IntegrationRuntimeName“<<IntegrationRuntimeName>>” |
Output Results :
- Linked Service on Integration Runtime
2. Azure Data Factory on Integration Runtime
The ADF name with which the IR is shared would be appended in front of a string “ADF_Share : “
This would avoid manually identifying the dependent objects of an Integration Runtime in Azure Data Factory.
Similarly for Synapse, refer the below blog :
Automated Way to Identify the Dependencies on an Integration Runtime in Synapse
DataSharkX 