Created
April 28, 2021 21:09
-
-
Save mdrakiburrahman/90a75792e5957877d1dff2ad9ccda4ad to your computer and use it in GitHub Desktop.
Create VNet integrated SSIS IR Integration Runtime on an existing ADF
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
### Azure Data Factory info | |
$SubscriptionName = "Azure Subscription Name" | |
$ResourceGroupName = "Resource Group Name containing Data Factory" | |
$DataFactoryName = "Data Factory Name" | |
$AzureSSISName = "SSIS IR Name that will appear in Portal" | |
$AzureSSISDescription = "E.g. Testing SSIS IR Deployment through PowerShell" | |
$AzureSSISLocation = "CanadaCentral" | |
$AzureSSISNodeSize = "Standard_D8_v3" | |
$AzureSSISNodeNumber = 4 | |
$AzureSSISEdition = "Standard" | |
$AzureSSISLicenseType = "BasePrice" | |
$AzureSSISMaxParallelExecutionsPerNode = 8 | |
$VNetId = "/subscriptions/your--subscription--id/resourceGroups/vnet--rg--name/providers/Microsoft.Network/virtualNetworks/vnet--name" | |
$Subnet = "subnet--name--for--ssis-ir" | |
### Sign in and select subscription | |
Connect-AzAccount | |
Select-AzSubscription -SubscriptionName $SubscriptionName | |
### Create an integration runtime | |
Set-AzDataFactoryV2IntegrationRuntime -ResourceGroupName $ResourceGroupName ` | |
-DataFactoryName $DataFactoryName ` | |
-Name $AzureSSISName ` | |
-Description $AzureSSISDescription ` | |
-Type Managed ` | |
-Location $AzureSSISLocation ` | |
-NodeSize $AzureSSISNodeSize ` | |
-NodeCount $AzureSSISNodeNumber ` | |
-Edition $AzureSSISEdition ` | |
-LicenseType $AzureSSISLicenseType ` | |
-MaxParallelExecutionsPerNode $AzureSSISMaxParallelExecutionsPerNode ` | |
-VNetId $VNetId ` | |
-Subnet $Subnet | |
### Start integration runtime | |
write-host("##### Starting #####") | |
Start-AzDataFactoryV2IntegrationRuntime -ResourceGroupName $ResourceGroupName ` | |
-DataFactoryName $DataFactoryName ` | |
-Name $AzureSSISName ` | |
-Force ` | |
-Debug # Comment out if you don't want verbose logs | |
write-host("##### Completed #####") |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment