Freedom251 › ETL and ELT Tools
Azure Data Factory

What Azure Data Factory is
Azure Data Factory is a paid service available through the web. Its deployment model is hybrid, supporting workflows that use the environments covered by that model. Transformation mode is mixed, giving the service a combination of transformation approaches rather than one single mode. The listed data capabilities include incremental loading, change data capture, and custom code transforms. Incremental loading supports handling newly available data, while change data capture identifies data changes for processing. Custom code transforms provide a way to apply organization-specific transformation logic. Azure Data Factory has no free plan. The listing associates it with a company founded in 1975 and headquartered in Redmond, Washington, USA. Product information is available at https://azure.microsoft.com/en-us/products/data-factory. Teams considering the service can assess whether web access, hybrid deployment, mixed transformation, incremental loading, change data capture, and custom code transforms match their workflows. Its paid model and lack of a free plan are central planning considerations when selecting the service.
Who it suits
Azure Data Factory offers web-based access with hybrid deployment and mixed transformation. It is relevant for workflows requiring incremental loading, change data capture, or custom code transforms.
What it does well
- Available through the web
- Uses hybrid deployment
- Provides mixed transformation mode
- Supports incremental loading
- Includes change data capture
- Allows custom code transforms
What to know first
- Paid pricing model
- No free plan
- Hybrid deployment may not fit single-environment workflows
Limits
There is no free plan. Azure Data Factory uses a paid pricing model.
Plans
| Plan | Billed and limits | Price |
|---|---|---|
| Data movement (self-hosted IR) | per hour · Self-hosted data movement | $0.10 a month |
| Data movement (Azure or managed VNET IR) | per DIU-hour · Cloud data movement activity | $0.25 a month |
| Pipeline orchestration (Azure integration runtime) | per 1,000 runs · Azure IR orchestration · managed VNET same rate | $1 a month |
| Pipeline orchestration (self-hosted integration runtime) | per 1,000 runs · Self-hosted IR orchestration | $1.50 a month |
As azure.microsoft.com lists them, read 21 Oct 2026. The maker's own page has the final word.
Getting started
- Open the Azure Data Factory website
- Access the service through the web
- Set up a hybrid deployment
- Choose the mixed transformation approach
- Configure incremental loading or change data capture
- Add custom code transforms where needed
Verdict
Pick Azure Data Factory when hybrid deployment and mixed transformation are priorities. Its incremental loading, change data capture, and custom code transforms cover several listed workflow needs. Look elsewhere if you require a free plan or a deployment model other than hybrid.
Questions
Does Azure Data Factory offer a free plan?
No. Azure Data Factory has a paid pricing model and no free plan.
Which platforms does Azure Data Factory support?
It is available through the web.
What deployment model does it use?
Azure Data Factory uses a hybrid deployment model.
What transformation mode is listed?
The listed transformation mode is mixed.
Does it support incremental loading?
Yes. Incremental loading is listed.
Can it use custom code transforms?
Yes. Custom code transforms are supported.
Facts from Azure Data Factory's own pages
- Browser support
- The Data Factory Studio quickstart identifies Microsoft Edge and Google Chrome as supported browsers. · learn.microsoft.com, 21 Oct 2026
- Built-in connectors
- Microsoft advertises more than 90 maintenance-free connectors, including Azure stores, Amazon Redshift, BigQuery, HDFS, Salesforce, Marketo and ServiceNow. · azure.microsoft.com, 21 Oct 2026
- Code-free data flows
- The service provides visual, code-free ETL and ELT authoring with mapping data flows powered by managed Apache Spark. · azure.microsoft.com, 21 Oct 2026
- Company identity
- Microsoft Corporation is a publicly traded company founded in 1975 and headquartered in Redmond, Washington. · sec.gov, 21 Oct 2026
- Company size
- Microsoft's LinkedIn profile lists 10,001-plus employees and approximately 228,000 employees worldwide. · linkedin.com, 21 Oct 2026
- Compliance
- Microsoft's product page says Azure has more than 100 compliance certifications, including more than 50 regional or country-specific certifications. · azure.microsoft.com, 21 Oct 2026
- Documentation depth
- Microsoft Learn provides conceptual guides, tutorials, quickstarts, REST references, SDK examples, CI/CD guidance, limits and security material. · learn.microsoft.com, 21 Oct 2026
- Encryption and keys
- Factory metadata is encrypted at rest with Microsoft-managed keys by default, with optional customer-managed keys in Azure Key Vault. · learn.microsoft.com, 21 Oct 2026
- Founded
- 1975 · azure.microsoft.com, 23 Sept 2026
- Headquarters
- Redmond, Washington, USA · azure.microsoft.com, 23 Sept 2026
- Identity and secrets
- Security guidance recommends Azure RBAC, managed identities and Azure Key Vault references instead of embedded credentials. · learn.microsoft.com, 21 Oct 2026
- Integration runtime choices
- Data Factory offers Azure, self-hosted and Azure-SSIS integration runtimes; self-hosted runtime supports on-premises connectivity and custom drivers. · learn.microsoft.com, 21 Oct 2026
- License
- Azure Data Factory is proprietary Microsoft Azure software governed by Azure service terms and is not open source. · microsoft.com, 21 Oct 2026
- Limit: CI/CD
- Zoftware reports that deploying an entire factory makes CI/CD cumbersome and that advanced orchestration becomes complicated. · zoftwarehub.com, 21 Oct 2026
- Limit: complex transformations
- TrustRadius reviewers say advanced transformations and modeling often require Databricks or PySpark and that metadata and data-quality tooling is weak. · trustradius.com, 21 Oct 2026
- Limit: cost predictability
- Integrate.io describes consumption pricing as difficult to forecast and reports complaints about accumulating execution and compute charges. · integrate.io, 21 Oct 2026
- Limit: debugging
- G2 and TrustRadius reviewers repeatedly report vague error messages, fragmented logs and difficult troubleshooting in complex pipelines. · trustradius.com, 21 Oct 2026
- Notable product direction
- Microsoft's March 26, 2026 update provides guidance for migrating Azure Data Factory and Synapse pipelines to Microsoft Fabric. · learn.microsoft.com, 21 Oct 2026
- Orchestration and monitoring
- Pipelines support visual activity monitoring, scheduling, triggers, alerts, branching, looping and conditional control flow. · learn.microsoft.com, 21 Oct 2026
- Ownership
- Crunchbase lists Microsoft Corporation as public post-IPO equity, meaning Azure Data Factory is owned by Microsoft shareholders. · crunchbase.com, 21 Oct 2026
- Praise: connectors
- TrustRadius reviewers repeatedly value the breadth of connectors across Azure, non-Azure and on-premises sources. · trustradius.com, 21 Oct 2026
- Praise: visual low-code
- G2 reviewers repeatedly praise drag-and-drop pipeline building and low-code workflows as accessible to technical and business users. · g2.com, 21 Oct 2026
- Pricing mechanics
- Pipeline execution is billed by activity runs and integration-runtime time, with runtime charges prorated by minute and rounded up. · azure.microsoft.com, 21 Oct 2026
- Public API
- Microsoft publishes a Data Factory REST API covering factory, linked-service, dataset, pipeline, run and monitoring operations. · learn.microsoft.com, 21 Oct 2026
Where Azure Data Factory stands on Freedom251
- ETL and ELT Tools#5 of 18
- ETL Software#11 of 28
- Data Orchestration Software#7 of 16
- Data Ingestion Software#9 of 20
- CRM Data Migration Software#21 of 41
