Document Details

How To Schedule Azure Ssis Integration Runtime
Home / Scan #41 / How To Schedule Azure Ssis Integration Runtime
Sad Tux - Windows bias detected
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.
GitHub View on GitHub 📚 View on Microsoft Learn

Bias Analysis

Detected Bias Types
powershell_heavy
windows_tools
missing_linux_example
windows_first
Summary
The documentation demonstrates a strong Windows and PowerShell bias. All scripting and automation examples are provided exclusively in PowerShell, with no mention of Bash, Azure CLI, or cross-platform alternatives. The use of Windows-centric tools such as SQL Server Management Studio (SSMS) is assumed for verification steps. There is no guidance for users on Linux or macOS, and no examples using platform-agnostic tools or commands. The documentation also references PowerShell modules and Azure Automation runbooks in PowerShell without offering equivalent instructions for other environments.
Recommendations
  • Provide equivalent examples using Azure CLI (az) commands for starting, stopping, and monitoring Azure-SSIS IR, as Azure CLI is cross-platform.
  • Include Bash script examples for automation tasks, especially for scheduling via cron or using Azure CLI in Linux/macOS environments.
  • Mention and provide steps for using Data Factory REST APIs directly with curl or other HTTP clients, which are platform-neutral.
  • For verification steps, suggest alternatives to SQL Server Management Studio, such as Azure Data Studio (cross-platform) or querying via sqlcmd.
  • Clarify in prerequisites and throughout the guide that all steps can be performed from Linux/macOS using Azure CLI and REST APIs, not just from Windows/PowerShell.
  • Where PowerShell is referenced, explicitly note that it is available cross-platform, but also provide syntax for native shells (Bash, zsh, etc.) where possible.
GitHub Create Pull Request

Scan History

Date Scan Status Result
2025-07-12 23:44 #41 cancelled Biased Biased
2025-07-12 00:58 #8 cancelled Clean Clean
2025-07-10 05:06 #7 processing Clean Clean

Flagged Code Snippets

    Param
    (
          [Parameter (Mandatory= $true)]
          [String] $ResourceGroupName,
    
          [Parameter (Mandatory= $true)]
          [String] $DataFactoryName,
    
          [Parameter (Mandatory= $true)]
          [String] $AzureSSISName,
    
          [Parameter (Mandatory= $true)]
          [String] $Operation
    )
    
    $ErrorActionPreference = "Stop"
    
    try
    {
        "Logging in to Azure..."
        Connect-AzAccount -Identity
    }
    catch {
        Write-Error -Message $_.Exception
        throw $_.Exception
    }
    
    if($Operation -eq "START" -or $operation -eq "start")
    {
        "##### Starting #####"
        Start-AzDataFactoryV2IntegrationRuntime -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -Name $AzureSSISName -Force
    }
    elseif($Operation -eq "STOP" -or $operation -eq "stop")
    {
        "##### Stopping #####"
        Stop-AzDataFactoryV2IntegrationRuntime -DataFactoryName $DataFactoryName -Name $AzureSSISName -ResourceGroupName $ResourceGroupName -Force
    }  
    "##### Completed #####"    
    
   Get-AzDataFactoryV2PipelineRun -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -PipelineRunId $myPipelineRun
   
   Get-AzDataFactoryV2Trigger -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -Name  "myTrigger"
   
   Get-AzDataFactoryV2TriggerRun -ResourceGroupName $ResourceGroupName -DataFactoryName $DataFactoryName -TriggerName "myTrigger" -TriggerRunStartedAfter "2018-07-15" -TriggerRunStartedBefore "2018-07-16"