# Azure Data Factory (ADF)

> A cloud tool from Microsoft. You drag boxes to copy data and run pipelines.

**Field:** Data Engineering  
**Category:** Orchestration  
**Also known as:** ADF, Microsoft Azure Data Factory, Azure Data Factory Pipeline

## Think of it like

It is like a toy train set you build on the floor. You snap the tracks together, then press go.

## Definition

Azure Data Factory is a cloud service from Microsoft that moves data and runs pipelines. You build a pipeline in a browser by dragging boxes and joining them. One kind of box copies data between more than 90 kinds of sources. Other boxes run code, call notebooks or wait. Triggers start pipelines on a schedule or when a file lands. You pay for each run and for the data moved.

## Example

A shop copies its sales from its own SQL Server to Azure each night with ADF. A second step then starts a notebook in Databricks.

## Why it matters

Many Microsoft shops use it as both their loader and their orchestrator. It is often the first data tool an Azure team meets.

## Common mistake

Building hundreds of near copies of one pipeline by hand. Use settings you pass in, so one pipeline serves many tables.

## Three principles

- **Drag and drop.** Pipelines are built from boxes.
- **Copy plus control.** It moves data and runs steps.
- **Triggers.** Start on a schedule or an event.

## Related terms

- [Workflow Orchestration](https://learn.benibix.com/term/data/workflow-orchestration)
- [Data Ingestion](https://learn.benibix.com/term/data/data-ingestion)
- [Microsoft Azure](https://learn.benibix.com/term/infrastructure/microsoft-azure)
- [Extract, Transform, Load (ETL)](https://learn.benibix.com/term/data/etl)
- [AWS Step Functions](https://learn.benibix.com/term/data/aws-step-functions)
- [Azure Synapse Analytics](https://learn.benibix.com/term/data/azure-synapse-analytics)

![Five tasks joined by arrows: extract orders and extract payments both feed a join task, which feeds build report and then email team. The join task is highlighted as failed, with a loop arrow labelled retry 2 of 3.](https://learn.benibix.com/diagrams/orchestration-dag.svg)

---

Source: https://learn.benibix.com/term/data/azure-data-factory
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-17
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
