Edit

Share via


Set-AzDataFactoryV2IntegrationRuntime

Updates an integration runtime.

Syntax

ByIntegrationRuntimeName (Default)

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>]
    [-DataFlowEnableQuickReuse]
    [-DataFlowCoreCount <Int32>]
    [-DataFlowTimeToLive <Int32>]
    [-ManagedVNetCopyComputeScaleDataIntegrationUnit <Int32>]
    [-ManagedVNetCopyComputeScaleTimeToLive <Int32>]
    [-ManagedVNetPipelineExternalComputeScaleTimeToLive <Int32>]
    [-ManagedVNetNumberOfPipelineNodeCount <Int32>]
    [-ManagedVNetNumberOfExternalNodeCount <Int32>]
    [-SelfContainedInteractiveAuthoringEnabled]
    [-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>]

ByResourceId

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>]
    [-DataFlowEnableQuickReuse]
    [-DataFlowCoreCount <Int32>]
    [-DataFlowTimeToLive <Int32>]
    [-ManagedVNetCopyComputeScaleDataIntegrationUnit <Int32>]
    [-ManagedVNetCopyComputeScaleTimeToLive <Int32>]
    [-ManagedVNetPipelineExternalComputeScaleTimeToLive <Int32>]
    [-ManagedVNetNumberOfPipelineNodeCount <Int32>]
    [-ManagedVNetNumberOfExternalNodeCount <Int32>]
    [-SelfContainedInteractiveAuthoringEnabled]
    [-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>]

ByLinkedIntegrationRuntimeResourceId

Set-AzDataFactoryV2IntegrationRuntime
    [-ResourceId] <String>
    -SharedIntegrationRuntimeResourceId <String>
    [-Type <String>]
    [-Description <String>]
    [-Force]
    [-DefaultProfile <IAzureContextContainer>]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

ByLinkedIntegrationRuntimeName

Set-AzDataFactoryV2IntegrationRuntime
    [-ResourceGroupName] <String>
    [-DataFactoryName] <String>
    [-Name] <String>
    -SharedIntegrationRuntimeResourceId <String>
    [-Type <String>]
    [-Description <String>]
    [-Force]
    [-DefaultProfile <IAzureContextContainer>]
    [-WhatIf]
    [-Confirm]
    [<CommonParameters>]

ByIntegrationRuntimeObject

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>]
    [-DataFlowEnableQuickReuse]
    [-DataFlowCoreCount <Int32>]
    [-DataFlowTimeToLive <Int32>]
    [-ManagedVNetCopyComputeScaleDataIntegrationUnit <Int32>]
    [-ManagedVNetCopyComputeScaleTimeToLive <Int32>]
    [-ManagedVNetPipelineExternalComputeScaleTimeToLive <Int32>]
    [-ManagedVNetNumberOfPipelineNodeCount <Int32>]
    [-ManagedVNetNumberOfExternalNodeCount <Int32>]
    [-SelfContainedInteractiveAuthoringEnabled]
    [-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>]

ByLinkedIntegrationRuntimeObject

Set-AzDataFactoryV2IntegrationRuntime
    [-InputObject] <PSIntegrationRuntime>
    -SharedIntegrationRuntimeResourceId <String>
    [-Type <String>]
    [-Description <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 description

The 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 description

The 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/SSISIRWithDataProxy

The 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.

Parameter properties

Type:SecureString
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-CatalogAdminCredential

The catalog database administrator credential of the integration runtime.

Parameter properties

Type:PSCredential
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-CatalogPricingTier

The catalog database pricing tier of the integration runtime.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-CatalogServerEndpoint

The catalog database server endpoint of the integration runtime.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Confirm

Prompts you for confirmation before running the cmdlet.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False
Aliases:cf

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DataFactoryName

The data factory name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:1
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False
ByLinkedIntegrationRuntimeName
Position:1
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-DataFlowComputeType

Compute type of the data flow cluster which will execute data flow job.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DataFlowCoreCount

Core count of the data flow cluster which will execute data flow job.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DataFlowEnableQuickReuse

To whether enable data flow cluster to be reused in the next dataflow activity.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DataFlowTimeToLive

Time to live (in minutes) setting of the data flow cluster which will execute data flow job.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DataProxyIntegrationRuntimeName

The Self-Hosted Integration Runtime name which is used as a proxy

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments: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

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments: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

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-DefaultProfile

The credentials, account, tenant, and subscription used for communication with azure.

Parameter properties

Type:IAzureContextContainer
Default value:None
Supports wildcards:False
DontShow:False
Aliases:AzContext, AzureRmContext, AzureCredential

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Description

The integration runtime description.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Edition

The edition for SSIS integration runtime which could be Standard or Enterprise, default is Standard if it is not specified.

Parameter properties

Type:String
Default value:None
Accepted values:Standard, Enterprise
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments: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.

Parameter properties

Type:ArrayList
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Force

Runs the cmdlet without prompting for confirmation.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-InputObject

The integration runtime object.

Parameter properties

Type:PSIntegrationRuntime
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeObject
Position:0
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:False
Value from remaining arguments:False
ByLinkedIntegrationRuntimeObject
Position:0
Mandatory:True
Value from pipeline:True
Value from pipeline by property name:False
Value from remaining arguments: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.

Parameter properties

Type:String
Default value:None
Accepted values:LicenseIncluded, BasePrice
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Location

The integration runtime location.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ManagedVNetCopyComputeScaleDataIntegrationUnit

DIU number setting reserved for copy activity execution.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ManagedVNetCopyComputeScaleTimeToLive

Time to live (in minutes) setting of integration runtime which will execute copy activity.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ManagedVNetNumberOfExternalNodeCount

Number of the the external nodes, which should be greater than 0 and less than 11.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ManagedVNetNumberOfPipelineNodeCount

Number of the pipeline nodes, which should be greater than 0 and less than 11.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ManagedVNetPipelineExternalComputeScaleTimeToLive

Time to live (in minutes) setting of integration runtime which will execute pipeline and external activity.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-MaxParallelExecutionsPerNode

Maximum parallel execution count per node for a managed dedicated integration runtime.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Name

The integration runtime name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False
Aliases:IntegrationRuntimeName

Parameter sets

ByIntegrationRuntimeName
Position:2
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False
ByLinkedIntegrationRuntimeName
Position:2
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-NodeCount

Target nodes count of the integration runtime.

Parameter properties

Type:

Nullable<T>[Int32]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-NodeSize

The integration runtime node size.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-PublicIPs

The static public IP addresses which the integration runtime will use.

Parameter properties

Type:

String[]

Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-ResourceGroupName

The resource group name.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:0
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False
ByLinkedIntegrationRuntimeName
Position:0
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False

-ResourceId

The Azure resource ID.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False
Aliases:Id

Parameter sets

ByResourceId
Position:0
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments:False
ByLinkedIntegrationRuntimeResourceId
Position:0
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:True
Value from remaining arguments: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.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SetupScriptContainerSasUri

The SAS URI of the Azure blob container that contains the custom setup script.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SharedIntegrationRuntimeResourceId

The resource id of the shared self-hosted integration runtime.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByLinkedIntegrationRuntimeResourceId
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByLinkedIntegrationRuntimeName
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByLinkedIntegrationRuntimeObject
Position:Named
Mandatory:True
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Subnet

The name of the subnet in the VNet.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False
Aliases:SubnetName

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-SubnetId

The ID of subnet, to which this Azure-SSIS integration runtime will be joined.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-Type

The integration runtime type.

Parameter properties

Type:String
Default value:None
Accepted values:Managed, SelfHosted
Supports wildcards:False
DontShow:False

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-VNetId

The ID of the VNet that the integration runtime joins.

Parameter properties

Type:String
Default value:None
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-VNetInjectionMethod

The edition for SSIS integration runtime which could be Standard or Enterprise, default is Standard if it is not specified.

Parameter properties

Type:String
Default value:None
Accepted values:Standard, Express
Supports wildcards:False
DontShow:False

Parameter sets

ByIntegrationRuntimeName
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByResourceId
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False
ByIntegrationRuntimeObject
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

-WhatIf

Shows what happens if the cmdlet runs, but doesn't run the cmdlet.

Parameter properties

Type:SwitchParameter
Default value:None
Supports wildcards:False
DontShow:False
Aliases:wi

Parameter sets

(All)
Position:Named
Mandatory:False
Value from pipeline:False
Value from pipeline by property name:False
Value from remaining arguments:False

CommonParameters

This cmdlet supports the common parameters: -Debug, -ErrorAction, -ErrorVariable, -InformationAction, -InformationVariable, -OutBuffer, -OutVariable, -PipelineVariable, -ProgressAction, -Verbose, -WarningAction, and -WarningVariable. For more information, see about_CommonParameters.

Inputs

String

PSIntegrationRuntime

Outputs

PSIntegrationRuntime