Document Details
Configure Azure Ssis Integration Runtime Performance
This page contains Windows bias
About This Page
This page is part of the Azure documentation. It contains code examples and configuration instructions for working with Azure services.
Bias Analysis
Detected Bias Types
powershell_heavy
missing_linux_example
windows_tools
Summary
The documentation page demonstrates a Windows bias by exclusively providing PowerShell scripts for configuration, referencing only Windows-centric tools and patterns, and omitting any Linux or cross-platform CLI examples. There is no mention of how to perform equivalent tasks using Azure CLI, Bash, or other cross-platform tools, which may hinder Linux users or those working in non-Windows environments.
Recommendations
- Provide equivalent configuration examples using Azure CLI and/or Bash scripts alongside PowerShell examples.
- Explicitly mention cross-platform tooling options (e.g., Azure CLI) and link to relevant documentation.
- Clarify which steps are platform-agnostic and which are specific to Windows, and provide guidance for Linux/macOS users where applicable.
- Ensure that references to scripts or automation do not assume a Windows environment by default.
Create Pull Request
Scan History
| Date | Scan | Status | Result |
|---|---|---|---|
| 2025-07-12 23:44 | #41 | cancelled |
Biased
|
| 2025-07-12 00:58 | #8 | cancelled |
 Clean
|
| 2025-07-10 05:06 | #7 | processing |
Clean
|
Flagged Code Snippets
# 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®ions=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®ions=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]"