Document Details

# If your input contains a PSH special character, e.g. "$", precede it with the escape character "`" like "`$" $SubscriptionName = "[your Azure subscription name]" $ResourceGroupName = "[your Azure resource group name]" $DataFactoryName = "[your data factory name]" # For supported regions, see https://azure.microsoft.com/global-infrastructure/services/?products=data-factory&regions=all $DataFactoryLocation = "EastUS" ### Azure-SSIS integration runtime information - This is a Data Factory compute resource for running SSIS packages $AzureSSISName = "[specify a name for your Azure-SSIS IR]" $AzureSSISDescription = "[specify a description for your Azure-SSIS IR]" # For supported regions, see https://azure.microsoft.com/global-infrastructure/services/?products=data-factory&regions=all $AzureSSISLocation = "EastUS" # For supported node sizes, see https://azure.microsoft.com/pricing/details/data-factory/ssis/ $AzureSSISNodeSize = "Standard_D8_v3" # 1-10 nodes are currently supported $AzureSSISNodeNumber = 2 # Azure-SSIS IR edition/license info: Standard or Enterprise $AzureSSISEdition = "Standard" # Standard by default, while Enterprise lets you use advanced/premium features on your Azure-SSIS IR # Azure-SSIS IR hybrid usage info: LicenseIncluded or BasePrice $AzureSSISLicenseType = "LicenseIncluded" # LicenseIncluded by default, while BasePrice lets you bring your existing SQL Server license with Software Assurance to earn cost savings from Azure Hybrid Benefit (AHB) option # For a Standard_D1_v2 node, up to 4 parallel executions per node are supported, but for other nodes, up to max(2 x number of cores, 8) are currently supported $AzureSSISMaxParallelExecutionsPerNode = 8 # Custom setup info $SetupScriptContainerSasUri = "" # OPTIONAL to provide SAS URI of blob container where your custom setup script and its associated files are stored # Virtual network info: Classic or Azure Resource Manager $VnetId = "[your virtual network resource ID or leave it empty]" # REQUIRED if you use Azure SQL Database with virtual network service endpoints/SQL Managed Instance/on-premises data, Azure Resource Manager virtual network is recommended, Classic virtual network will be deprecated soon $SubnetName = "[your subnet name or leave it empty]" # WARNING: Please use the same subnet as the one used with your Azure SQL Database with virtual network service endpoints or a different subnet than the one used for your SQL Managed Instance ### SSISDB info $SSISDBServerEndpoint = "[your server name or managed instance name.DNS prefix].database.windows.net" # WARNING: Please ensure that there is no existing SSISDB, so we can prepare and manage one on your behalf # Authentication info: SQL or Entra ID $SSISDBServerAdminUserName = "[your server admin username for SQL authentication or leave it empty for AAD authentication]" $SSISDBServerAdminPassword = "[your server admin password for SQL authentication or leave it empty for AAD authentication]" $SSISDBPricingTier = "[Basic|S0|S1|S2|S3|S4|S6|S7|S9|S12|P1|P2|P4|P6|P11|P15|…|ELASTIC_POOL(name = <elastic_pool_name>) for Azure SQL Database or leave it empty for SQL Managed Instance]"