Set-AzDataFactoryV2IntegrationRuntime
Updates an integration runtime.
Syntax
Set-AzDataFactoryV2IntegrationRuntime
[-ResourceGroupName] <String>
[-DataFactoryName] <String>
[-Name] <String>
[-Type <String>]
[-Description <String>]
[-Location <String>]
[-NodeSize <String>]
[-NodeCount <Int32>]
[-CatalogServerEndpoint <String>]
[-CatalogAdminCredential <PSCredential>]
[-CatalogPricingTier <String>]
[-VNetId <String>]
[-Subnet <String>]
[-SubnetId <String>]
[-PublicIPs <String[]>]
[-DataFlowComputeType <String>]
[-DataFlowCoreCount <Int32>]
[-DataFlowTimeToLive <Int32>]
[-SetupScriptContainerSasUri <String>]
[-Edition <String>]
[-VNetInjectionMethod <String>]
[-ExpressCustomSetup <ArrayList>]
[-DataProxyIntegrationRuntimeName <String>]
[-DataProxyStagingLinkedServiceName <String>]
[-DataProxyStagingPath <String>]
[-MaxParallelExecutionsPerNode <Int32>]
[-LicenseType <String>]
[-AuthKey <SecureString>]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Set-AzDataFactoryV2IntegrationRuntime
[-ResourceId] <String>
[-Type <String>]
[-Description <String>]
[-Location <String>]
[-NodeSize <String>]
[-NodeCount <Int32>]
[-CatalogServerEndpoint <String>]
[-CatalogAdminCredential <PSCredential>]
[-CatalogPricingTier <String>]
[-VNetId <String>]
[-Subnet <String>]
[-SubnetId <String>]
[-PublicIPs <String[]>]
[-DataFlowComputeType <String>]
[-DataFlowCoreCount <Int32>]
[-DataFlowTimeToLive <Int32>]
[-SetupScriptContainerSasUri <String>]
[-Edition <String>]
[-VNetInjectionMethod <String>]
[-ExpressCustomSetup <ArrayList>]
[-DataProxyIntegrationRuntimeName <String>]
[-DataProxyStagingLinkedServiceName <String>]
[-DataProxyStagingPath <String>]
[-MaxParallelExecutionsPerNode <Int32>]
[-LicenseType <String>]
[-AuthKey <SecureString>]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Set-AzDataFactoryV2IntegrationRuntime
[-ResourceId] <String>
[-Type <String>]
[-Description <String>]
-SharedIntegrationRuntimeResourceId <String>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Set-AzDataFactoryV2IntegrationRuntime
[-ResourceGroupName] <String>
[-DataFactoryName] <String>
[-Name] <String>
[-Type <String>]
[-Description <String>]
-SharedIntegrationRuntimeResourceId <String>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Set-AzDataFactoryV2IntegrationRuntime
[-InputObject] <PSIntegrationRuntime>
[-Type <String>]
[-Description <String>]
[-Location <String>]
[-NodeSize <String>]
[-NodeCount <Int32>]
[-CatalogServerEndpoint <String>]
[-CatalogAdminCredential <PSCredential>]
[-CatalogPricingTier <String>]
[-VNetId <String>]
[-Subnet <String>]
[-SubnetId <String>]
[-PublicIPs <String[]>]
[-DataFlowComputeType <String>]
[-DataFlowCoreCount <Int32>]
[-DataFlowTimeToLive <Int32>]
[-SetupScriptContainerSasUri <String>]
[-Edition <String>]
[-VNetInjectionMethod <String>]
[-ExpressCustomSetup <ArrayList>]
[-DataProxyIntegrationRuntimeName <String>]
[-DataProxyStagingLinkedServiceName <String>]
[-DataProxyStagingPath <String>]
[-MaxParallelExecutionsPerNode <Int32>]
[-LicenseType <String>]
[-AuthKey <SecureString>]
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Set-AzDataFactoryV2IntegrationRuntime
[-InputObject] <PSIntegrationRuntime>
[-Type <String>]
[-Description <String>]
-SharedIntegrationRuntimeResourceId <String>
[-Force]
[-DefaultProfile <IAzureContextContainer>]
[-WhatIf]
[-Confirm]
[<CommonParameters>] Description
The Set-AzDataFactoryV2IntegrationRuntime cmdlet updates an integration runtime with specific parameters.
Examples
Example 1: Update integration runtime description.
Set-AzDataFactoryV2IntegrationRuntime -ResourceGroupName 'rg-test-dfv2' -DataFactoryName 'test-df-eu2' -Name 'test-selfhost-ir' `
-Description 'New description'
Id : /subscriptions/b3ee3a7f-7614-4644-ad07-afa832620b4b/resourceGroups/rg-test-dfv2/providers/Microsoft.DataFactory/factories/test-df-eu2/integrationruntimes/test-selfhost-ir
ResourceGroupName : rg-test-dfv2
DataFactoryName : test-df-eu2
Name : test-selfhost-ir
Description : New descriptionThe cmdlet updates the description of integration runtime named 'test-selfhost-ir'.
Example 2: Share Self-hosted integration runtime.
Set-AzDataFactoryV2IntegrationRuntime -ResourceGroupName 'rg-test-dfv2' -DataFactoryName 'test-df-eu2' -Name 'test-selfhost-ir' `
-SharedIntegrationRuntimeResourceId '/subscriptions/b3ee3a7f-7614-4644-ad07-afa832620b4b/resourceGroups/rg-test-dfv2/providers/Microsoft.DataFactory/factories/test-df-eu2/integrationruntimes/test-selfhost-ir' -Type "SelfHosted"
Id : /subscriptions/b3ee3a7f-7614-4644-ad07-afa832620b4b/resourceGroups/rg-test-dfv2/providers/Microsoft.DataFactory/factories/test-df-eu2/integrationruntimes/test-selfhost-ir
ResourceGroupName : rg-test-dfv2
DataFactoryName : test-df-eu2
Name : test-selfhost-ir
Description : New descriptionThe cmdlet adds the ADF to use the shared integration runtime. When using -SharedIntegrationRuntimeResourceId parameter the -Type must also be included. Note that the data factory need to be granted permission to use the integration runtime before running cmdlet.
Example 3: Configure Self-Hosted IR as a proxy for Azure-SSIS IR in ADF.
Set-AzDataFactoryV2IntegrationRuntime -ResourceGroupName testgroup `
-DataFactoryName testdf `
-Name SSISIRWithDataProxy `
-DataProxyIntegrationRuntimeName proxySelfhostedIR `
-DataProxyStagingLinkedServiceName AzureBlobStorage `
-DataProxyStagingPath teststaging
Location : EastUS
NodeSize : Standard_D8_v3
NodeCount : 1
MaxParallelExecutionsPerNode : 8
CatalogServerEndpoint :
CatalogAdminUserName :
CatalogAdminPassword :
CatalogPricingTier :
VNetId :
Subnet :
SubnetId :
VNetInjectionMethod : Express
PublicIPs :
State : Initial
LicenseType : LicenseIncluded
SetupScriptContainerSasUri :
DataProxyIntegrationRuntimeName : proxySelfhostedIR
DataProxyStagingLinkedServiceName : AzureBlobStorage
DataProxyStagingPath :
Edition : Standard
Name : SSISIRWithDataProxy
Type : Managed
ResourceGroupName : testgroup
DataFactoryName : testdf
Description :
Id : /subscriptions/cb715d05-3337-4640-8c43-4f943c50d06e/resourceGroups/testgroup/providers/Microsoft.DataFactory/factories/testdf/integrationruntimes/SSISIRWithDataProxyThe cmdlet update Azure-SSIS integration runtime to use Self-hosted integration runtime as a data proxy.
Parameters
-AuthKey
The authentication key of the self-hosted integration runtime.
| Type: | SecureString |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-CatalogAdminCredential
The catalog database administrator credential of the integration runtime.
| Type: | PSCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-CatalogPricingTier
The catalog database pricing tier of the integration runtime.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-CatalogServerEndpoint
The catalog database server endpoint of the integration runtime.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Confirm
Prompts you for confirmation before running the cmdlet.
| Type: | SwitchParameter |
| Aliases: | cf |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataFactoryName
The data factory name.
| Type: | String |
| Position: | 1 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-DataFlowComputeType
Compute type of the data flow cluster which will execute data flow job.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataFlowCoreCount
Core count of the data flow cluster which will execute data flow job.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataFlowEnableQuickReuse
To whether enable data flow cluster to be reused in the next dataflow activity.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataFlowTimeToLive
Time to live (in minutes) setting of the data flow cluster which will execute data flow job.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataProxyIntegrationRuntimeName
The Self-Hosted Integration Runtime name which is used as a proxy
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataProxyStagingLinkedServiceName
The Azure Blob Storage Linked Service name that references the staging data store to be used when moving data between Self-Hosted and Azure-SSIS Integration Runtime
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DataProxyStagingPath
The path in staging data store to be used when moving data between Self-Hosted and Azure-SSIS Integration Runtimes, a default container will be used if unspecified
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-DefaultProfile
The credentials, account, tenant, and subscription used for communication with azure.
| Type: | IAzureContextContainer |
| Aliases: | AzContext, AzureRmContext, AzureCredential |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Description
The integration runtime description.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Edition
The edition for SSIS integration runtime which could be Standard or Enterprise, default is Standard if it is not specified.
| Type: | String |
| Accepted values: | Standard, Enterprise |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ExpressCustomSetup
The express custom setup for SSIS integration runtime which could be used to setup configurations and 3rd party components without custom setup script.
| Type: | ArrayList |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Force
Runs the cmdlet without prompting for confirmation.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-InputObject
The integration runtime object.
| Type: | PSIntegrationRuntime |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-LicenseType
The license type that you want to select for the SSIS IR. There are two types: LicenseIncluded or BasePrice. If you are qualified for the Azure Hybrid Use Benefit (AHUB) pricing, please select BasePrice. If not, please select LicenseIncluded.
| Type: | String |
| Accepted values: | LicenseIncluded, BasePrice |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Location
The integration runtime location.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ManagedVNetCopyComputeScaleDataIntegrationUnit
DIU number setting reserved for copy activity execution.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ManagedVNetCopyComputeScaleTimeToLive
Time to live (in minutes) setting of integration runtime which will execute copy activity.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ManagedVNetNumberOfExternalNodeCount
Number of the the external nodes, which should be greater than 0 and less than 11.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ManagedVNetNumberOfPipelineNodeCount
Number of the pipeline nodes, which should be greater than 0 and less than 11.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ManagedVNetPipelineExternalComputeScaleTimeToLive
Time to live (in minutes) setting of integration runtime which will execute pipeline and external activity.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-MaxParallelExecutionsPerNode
Maximum parallel execution count per node for a managed dedicated integration runtime.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Name
The integration runtime name.
| Type: | String |
| Aliases: | IntegrationRuntimeName |
| Position: | 2 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-NodeCount
Target nodes count of the integration runtime.
| Type: | Nullable<T>[Int32] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-NodeSize
The integration runtime node size.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-PublicIPs
The static public IP addresses which the integration runtime will use.
| Type: | String[] |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-ResourceGroupName
The resource group name.
| Type: | String |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-ResourceId
The Azure resource ID.
| Type: | String |
| Aliases: | Id |
| Position: | 0 |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | True |
| Accept wildcard characters: | False |
-SelfContainedInteractiveAuthoringEnabled
An alternative option to ensure interactive authoring function when your self-hosted integration runtime is unable to establish a connection with Azure Relay.
| Type: | SwitchParameter |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SetupScriptContainerSasUri
The SAS URI of the Azure blob container that contains the custom setup script.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SharedIntegrationRuntimeResourceId
The resource id of the shared self-hosted integration runtime.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | True |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Subnet
The name of the subnet in the VNet.
| Type: | String |
| Aliases: | SubnetName |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-SubnetId
The ID of subnet, to which this Azure-SSIS integration runtime will be joined.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-Type
The integration runtime type.
| Type: | String |
| Accepted values: | Managed, SelfHosted |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-VNetId
The ID of the VNet that the integration runtime joins.
| Type: | String |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-VNetInjectionMethod
The edition for SSIS integration runtime which could be Standard or Enterprise, default is Standard if it is not specified.
| Type: | String |
| Accepted values: | Standard, Express |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
-WhatIf
Shows what happens if the cmdlet runs, but doesn't run the cmdlet.
| Type: | SwitchParameter |
| Aliases: | wi |
| Position: | Named |
| Default value: | None |
| Required: | False |
| Accept pipeline input: | False |
| Accept wildcard characters: | False |
Inputs
Outputs
Azure PowerShell
Feedback
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see: https://aka.ms/ContentUserFeedback.
Submit and view feedback for