Azure Data Factory

azure.microsoft.com/en-us/services/data-factory
Data Integration
Weekend Project

Simplify hybrid data integration at enterprise scale

How to Replace Azure Data Factory

Overview

Azure Data Factory is a fully managed, serverless data integration service that consolidates data from multiple sources using 90+ built-in connectors. It enables users to construct ETL and ELT processes code-free in an intuitive visual environment or with custom code, then deliver integrated data to Azure Synapse Analytics for business insights.

Features

18 features across 14 categories

Automation(1)

Intelligent Intent-Driven MappingAI

Automates copy activities and transforms data faster with intelligent mapping capabilities

Also in: monday.com, Notion, Airtable

Data Integration(1)

Hybrid Data Integration

Ingest data from on-premises, hybrid, and multicloud sources and transform with powerful data flows

Data Processing(2)

Code-free ETL/ELT Pipeline Creation

Easily construct extract, transform, and load (ETL) and extract, load, and transform (ELT) processes without writing code in an intuitive environment

Data Flows

Code-free data transformation with managed Apache Spark service that takes care of code generation and maintenance

DevOps(1)

Git Integration and CI/CD Support

Built-in Git support and continuous integration and continuous delivery (CI/CD) capabilities for pipeline development

Also in: MuleSoft, Jira, Jira

Infrastructure(3)

Fully Managed Serverless Service

Pay-as-you-go, fully managed serverless cloud service that scales on demand with no upfront cost

Integration Runtime

Compute infrastructure that provides data integration capabilities across network environments, moves data between source and destination, executes Data Flow on Spark compute, and natively executes SSIS packages

Multi-Region Availability

Data Factory is available in more than 25 regions globally

Integrations(2)

Azure Synapse Analytics Integration

Ingest, integrate, and transform data within Azure Synapse Analytics powered by Data Factory using familiar Data Factory experience

Built-in Connectors

More than 90 built-in, maintenance-free connectors for integrating data from on-premises, SaaS, and cloud sources including Amazon Redshift, Google BigQuery, Salesforce, Marketo, ServiceNow, Oracle Exadata, and Teradata

Also in: ReadMe, Hugging Face, Setmore

Migration(1)

SSIS Migration and Rehosting

Fully compatible data integration service that makes it easy to move all SQL Server Integration Services (SSIS) packages to the cloud with deployment wizard, achieving up to 88% cost savings with Azure Hybrid Benefit

Also in: Keeper, MongoDB Atlas, Bitwarden

Monitoring(1)

Pipeline Orchestration and Monitoring

Monitor all activity runs visually and set up alerts proactively to monitor pipelines, with notifications through Azure alert groups to prevent downstream or upstream problems

Performance(1)

High-Throughput Data Transfer

Utilize full capacity of underlying network bandwidth up to 5 Gbps throughput for data ingestion

Reliability(1)

Service Level Agreement (SLA)

99.9% uptime guarantee for processing requests and 99.9% guarantee that activity runs will initiate within four minutes of scheduled execution times

SaaS Integration(1)

SaaS App Enrichment

Help independent software vendors (ISVs) enrich their SaaS apps with integrated hybrid data to deliver data-driven user experiences

Security(1)

Embedded Security and Compliance

Built-in security with 34,000 full-time equivalent engineers dedicated to security initiatives, 15,000 partners with specialized security expertise, and over 100 compliance certifications including 50+ specific to global regions

Usability(1)

Citizen Integrator Support

Autonomous ETL capabilities to gain operational efficiencies and support citizen integrators without requiring deep technical expertise

User Interface(1)

Visual Authoring

Use Azure Data Factory Studio or Azure portal UI to visually author and deploy resources without writing code

Cost Calculator

Pricing data not available for Azure Data Factory. Check their website for current pricing.

Build vs Buy

Should you build a Azure Data Factory alternative or buy the subscription? Estimate based on 18 features.

Buy Azure Data Factory

Better Value
Monthly costContact Sales
3-year totalVaries
Time to deployDays

Build Your Own

Development cost$12,000
Maintenance$180/mo
3-year total$18,480
Dev time~1 months

Buying Azure Data Factory saves ~$18,480 over 3 years vs building.

Estimates based on 18 features and a BuildScore of 5/5. Actual costs vary.

Integrations

12 known integrations

Amazon RedshiftAzure Data ShareAzure Synapse AnalyticsGoogle BigQueryHadoop Distributed File System (HDFS)MarketoMicrosoft FabricOracle ExadataPower BISalesforceServiceNowTeradata