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 providing only PowerShell-based configuration examples and scripts, with no equivalent examples for Linux environments (e.g., Bash, Azure CLI). It references Windows-centric tools and patterns, such as PowerShell and Windows authentication methods, without mentioning or prioritizing cross-platform alternatives. There is no guidance for users operating from Linux or macOS environments.
Recommendations
- Provide equivalent Azure CLI or Bash script examples for all PowerShell scripts to support Linux and macOS users.
- Explicitly mention that configuration can be performed from non-Windows platforms and provide links or references to relevant cross-platform tools.
- Add a section or callout discussing cross-platform support and any platform-specific considerations.
- Where authentication is discussed, clarify options for both Windows (SQL authentication) and cross-platform (Azure AD/Entra ID) scenarios.
- Ensure that any references to tools or commands (e.g., PowerShell) are accompanied by their cross-platform equivalents.
Create Pull Request
Scan History
| Date | Scan | Status | Result |
|---|---|---|---|
| 2026-01-12 00:00 | #99 | completed |
Biased
|
| 2026-01-11 06:20 | #98 | completed |
Biased
|
| 2026-01-10 00:00 | #92 | completed |
 Clean
|
| 2026-01-06 22:28 | #78 | completed |
Clean
|
| 2025-12-29 18:00 | #48 | cancelled |
Biased
|
| 2025-12-15 00:00 | #7 | completed |
Clean
|
| 2025-12-14 05:05 | #6 | completed |
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]"