Analytics Data Factory top-250-pre130-priority-upgraded launch-ready field-manual-complete

Integration runtime

Integration runtime controls which compute, region, and network path data integration workloads use when moving data or executing pipeline activities. Teams see it in data factory integration runtime blade, synapse pipelines. It is not a pipeline, dataset, linked service, Databricks cluster, VM scale set, or Azure Container Apps environment; confusing them can create blocked on-premises connectivity, slow copy jobs. Use the term when reviewing access, monitoring, cost, recovery, or performance. It keeps architects, operators, security reviewers, and support teams focused on the same setting, resource, or behavior.

Aliases
ADF integration runtime, Azure integration runtime, self-hosted integration runtime, SSIS integration runtime, IR, Azure Data Factory integration runtime
Difficulty
intermediate
CLI mappings
4
Last verified
2026-06-03

Microsoft Learn

Integration runtime controls which compute, region, and network path data integration workloads use when moving data or executing pipeline activities. Microsoft Learn places it in Integration runtime in Azure Data Factory and Azure Synapse Analytics; operators confirm scope, configuration, dependencies, and production impact.

Microsoft Learn: Integration runtime in Azure Data Factory and Azure Synapse Analytics2026-06-03

Technical context

Technically, Integration runtime sits in Data Factory integration runtime blade, Synapse pipelines, copy activities, linked services. Key fields include runtime type, region, managed virtual network, node count. Operators verify it with integration runtime status, node health, activity run details, copy throughput. In production reviews, connect the term to resource scope, identity, network path, diagnostics, cost ownership, and rollback. Confirm subscription, resource group, service tier, dependent workload, and current Azure evidence before changing it. Capture the current resource ID, region, and dependency path before approving changes.

Why it matters

Integration runtime matters because it turns an architecture choice into day-to-day workload behavior. If the team misunderstands it, the failure usually appears as blocked on-premises connectivity, slow copy jobs, failed credential sync before anyone notices the documentation gap. The term also affects security, reliability, operations, cost, and performance because one setting can influence access, recovery, automation, user experience, and budget. Naming it precisely helps engineers compare portal settings, CLI output, infrastructure-as-code, monitoring data, and incident notes without guessing. It also gives reviewers a practical checklist: where is it configured, who owns it, what depends on it, what evidence proves it works, and how rollback happens.

Where you see it

Signals, screens, and Azure surfaces where this term usually becomes operational.

Signal 01

In the Azure portal, Integration runtime appears near data factory integration runtime blade, synapse pipelines, where owners review configuration, health, access, and dependent workload impact before safe production changes.

Signal 02

In CLI or REST output, Integration runtime shows up through integration runtime status, node health and related fields that confirm live Azure state during audits, releases, and incidents.

Signal 03

In incident reviews, Integration runtime is discussed when users report blocked on-premises connectivity, and engineers compare logs, metrics, ownership, dependencies, recent changes, support impact, and deployment evidence together.

When this becomes relevant

Specific situations where this term helps solve real Azure design, operations, migration, security, reliability, cost, or governance problems.

  • Choose the compute and network path for Data Factory copy or pipeline activity.
  • Connect on-premises data sources through self-hosted integration runtime nodes.
  • Review runtime region, node health, linked services, and private connectivity before changes.
  • Troubleshoot slow copy jobs, offline nodes, credential problems, and blocked network paths.
  • Standardize runtime ownership, upgrades, monitoring, and scale planning across factories.

Real-world case studies

Different enterprise-style examples that show the term being used to hit measurable objectives.

Case study 01

Integration runtime in action for on-premises warehouse migration

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

Wingtip Finance, a financial services organization, needed to move nightly data from an on-premises SQL Server estate into Azure without opening inbound firewall access. The team had to improve the design without disrupting existing users or weakening governance.

Business/Technical Objectives
  • Use Integration runtime to solve the immediate workload problem
  • Keep security and compliance evidence available for review
  • Reduce manual support effort during operations
  • Measure results with production telemetry and owner signoff
Solution Using Integration runtime

Architects treated Integration runtime as a production control point rather than a background detail. They reviewed the current Azure resources, confirmed owners, and documented how the term connected to identity, networking, monitoring, cost, and rollback. Engineers implemented self-hosted integration runtime nodes, Key Vault-backed linked services, high-availability node pairing, copy activity monitoring, and private endpoint access to sinks, then validated the change with read-only CLI checks and portal evidence. The rollout used a pilot scope first, with diagnostic logging enabled before wider release. Support teams received a runbook explaining expected output, common failure modes, and the safest rollback path. Security reviewers checked access boundaries and data-handling assumptions before the change moved to production.

Results & Business Impact
  • reduced nightly transfer failures by 63 percent
  • kept inbound firewall ports closed
  • improved copy throughput by 29 percent after node tuning
  • created clear operational ownership for runtime upgrades
Key Takeaway for Glossary Readers

Integration runtime is valuable when teams connect the Azure setting to measurable security, reliability, operational, cost, and performance outcomes.

Case study 02

Integration runtime in action for regional data movement

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

Contoso Retail Group, a retail organization, needed to avoid cross-region latency when moving store telemetry into regional lake zones during peak shopping windows. The team had to improve the design without disrupting existing users or weakening governance.

Business/Technical Objectives
  • Use Integration runtime to solve the immediate workload problem
  • Keep security and compliance evidence available for review
  • Reduce manual support effort during operations
  • Measure results with production telemetry and owner signoff
Solution Using Integration runtime

Architects treated Integration runtime as a production control point rather than a background detail. They reviewed the current Azure resources, confirmed owners, and documented how the term connected to identity, networking, monitoring, cost, and rollback. Engineers implemented Azure integration runtime region selection, pipeline parameters, copy activity monitoring, and cost dashboards comparing transfer paths, then validated the change with read-only CLI checks and portal evidence. The rollout used a pilot scope first, with diagnostic logging enabled before wider release. Support teams received a runbook explaining expected output, common failure modes, and the safest rollback path. Security reviewers checked access boundaries and data-handling assumptions before the change moved to production.

Results & Business Impact
  • cut average copy duration by 35 percent
  • reduced interregional transfer exposure
  • kept Black Friday pipeline queues below ten minutes
  • made runtime selection visible in release reviews
Key Takeaway for Glossary Readers

Integration runtime is valuable when teams connect the Azure setting to measurable security, reliability, operational, cost, and performance outcomes.

Case study 03

Integration runtime in action for legacy SSIS modernization

Scenario, objectives, solution, measured impact, and takeaway.

Scenario

Fabrikam Manufacturing, a manufacturing organization, needed to run legacy SSIS packages while gradually migrating warehouse jobs into modern Data Factory pipelines. The team had to improve the design without disrupting existing users or weakening governance.

Business/Technical Objectives
  • Use Integration runtime to solve the immediate workload problem
  • Keep security and compliance evidence available for review
  • Reduce manual support effort during operations
  • Measure results with production telemetry and owner signoff
Solution Using Integration runtime

Architects treated Integration runtime as a production control point rather than a background detail. They reviewed the current Azure resources, confirmed owners, and documented how the term connected to identity, networking, monitoring, cost, and rollback. Engineers implemented Azure-SSIS integration runtime, scheduled start and stop automation, SSISDB checks, pipeline triggers, and run-history alerts, then validated the change with read-only CLI checks and portal evidence. The rollout used a pilot scope first, with diagnostic logging enabled before wider release. Support teams received a runbook explaining expected output, common failure modes, and the safest rollback path. Security reviewers checked access boundaries and data-handling assumptions before the change moved to production.

Results & Business Impact
  • reduced idle SSIS runtime cost by 44 percent
  • kept legacy packages running during phased migration
  • cut support tickets about package starts by 31 percent
  • improved release confidence with repeatable runtime health checks
Key Takeaway for Glossary Readers

Integration runtime is valuable when teams connect the Azure setting to measurable security, reliability, operational, cost, and performance outcomes.

Why use Azure CLI for this?

CLI checks are useful for Integration runtime because they capture live Azure state, reduce guesswork, and separate safe inspection from approved changes.

CLI use cases

  • Confirm the live Azure resource or configuration related to Integration runtime before approving a production change.
  • Capture read-only evidence for Integration runtime during incident response, audit review, or release validation.
  • Compare CLI output with infrastructure-as-code, portal settings, and runbook expectations for Integration runtime.
  • Validate graph-connected dependencies for Integration runtime before changing production scope.

Before you run CLI

  • Confirm tenant, subscription, resource group, service name, and environment before trusting command output.
  • Run list or show commands first, then save evidence before any create, update, delete, restore, or deploy action.
  • Check whether the command exposes secrets, customer data, training examples, file paths, keys, or private endpoints.
  • Have an approved rollback path and owner contact ready before changing production configuration.

What output tells you

  • Whether the expected Azure resource exists and whether Integration runtime is configured at the intended scope.
  • Which names, IDs, locations, states, tiers, policies, identities, and dependent resources are active right now.
  • Whether live Azure state differs from the design document, deployment template, release ticket, or support runbook.
  • Which metric, log query, portal page, or application test should be checked before closing the issue.

Mapped Azure CLI commands

Integration runtime operational checks

direct
az datafactory integration-runtime list --factory-name <factory-name> --resource-group <resource-group>
az datafactory integration-runtimediscoverAnalytics
az datafactory integration-runtime show --factory-name <factory-name> --resource-group <resource-group> --name <runtime-name>
az datafactory integration-runtimediscoverAnalytics
az datafactory integration-runtime get-status --factory-name <factory-name> --resource-group <resource-group> --name <runtime-name>
az datafactory integration-runtimediscoverAnalytics
az datafactory integration-runtime start --factory-name <factory-name> --resource-group <resource-group> --name <runtime-name>
az datafactory integration-runtimeoperateAnalytics
az datafactory integration-runtime stop --factory-name <factory-name> --resource-group <resource-group> --name <runtime-name>
az datafactory integration-runtimeoperateAnalytics

Architecture context

Technically, Integration runtime sits in Data Factory integration runtime blade, Synapse pipelines, copy activities, linked services. Key fields include runtime type, region, managed virtual network, node count. Operators verify it with integration runtime status, node health, activity run details, copy throughput. In production reviews, connect the term to resource scope, identity, network path, diagnostics, cost ownership, and rollback. Confirm subscription, resource group, service tier, dependent workload, and current Azure evidence before changing it.

Security

Security for Integration runtime starts with managed identities, linked-service credentials, Key Vault references, self-hosted node hardening, outbound firewall rules. Review who can read, create, update, delete, restore, deploy, or invoke the related resource, and verify that privileged changes create audit evidence. Prefer Microsoft Entra ID, managed identities, private endpoints, key rotation, customer-managed keys, and policy controls where the service supports them. Keep secrets, credentials, personal data, and regulated content out of scripts and examples unless the data-handling design explicitly allows it. During approval, check tenant boundaries, network exposure, diagnostic logs, and break-glass procedures so a configuration mistake does not become an incident.

Cost

Cost for Integration runtime is driven by Azure IR activity usage, data flow clusters, SSIS IR runtime hours, self-hosted VM costs, idle time. The common mistake is treating the term as free because it is a setting, schema choice, job, or child resource instead of a cost influence. Check whether charges come from storage, requests, tokens, replicas, retention, backups, training, data transfer, diagnostics, or engineer time spent recovering from bad configuration. Use tags, budgets, Azure Cost Management, and owner reviews to connect usage to a workload. When reducing cost, confirm the change will not remove recovery evidence, security controls, or needed performance headroom.

Reliability

Reliability for Integration runtime depends on self-hosted node high availability, queue duration, regional routing, managed VNet health, credential synchronization. A resource can exist and still fail the business workflow when permissions, network paths, limits, schema settings, or downstream services are wrong. Define the health signal before production use, then test the expected failure mode with a controlled change. Monitor platform metrics, application traces, deployment history, and user symptoms in the same time window during incidents. Recovery plans should include owner contact, safe rollback, validation queries, and customer-impact checks, not just proof that the Azure resource exists. Confirm this behavior is tested before the workload depends on it.

Performance

Performance for Integration runtime depends on copy throughput, source and sink limits, parallelism, data flow cluster size, region choice. Measure the real workload instead of assuming the default configuration is enough. Look at latency, throughput, concurrency, request size, metadata operations, query complexity, token counts, or recovery duration depending on the service. Compare production metrics with load tests and with the limits of the selected tier or model. Tuning should be incremental and reversible, because a change that improves one path can hurt another. Always verify user-facing behavior after configuration, schema, deployment, or data-layout changes. Capture before-and-after metrics so tuning is based on evidence rather than assumptions.

Operations

Operations for Integration runtime require runtime inventory, node upgrade checks, pipeline activity monitoring, key rotation, linked service reviews. Treat the term as something support teams must inspect quickly, not only as a design-time concept. Keep a runbook with portal locations, CLI commands, expected output, known dependencies, approval rules, and rollback steps. Review it during releases, migrations, incidents, access changes, and cost investigations. Good operations practice also means tagging owners, enabling diagnostics, storing evidence from read-only checks, and documenting exceptions. When the term changes, update handoff notes so future operators know what normal looks like. Keep the same evidence available to the next on-call engineer.

Common mistakes

  • Treating Integration runtime as a harmless label instead of checking the live resource, scope, owner, and dependencies.
  • Running a mutating command in the wrong subscription, resource group, account, service, index, share, or deployment.
  • Assuming a successful deployment proves the feature works without checking logs, metrics, access, and rollback evidence.
  • Ignoring cost, retention, quotas, network exposure, or data classification until an incident forces emergency cleanup.