About Data Factory

Accelerate data integration

Integrate data silos with Azure Data Factory, a service built for all data integration needs and skill levels. Easily construct ETL and ELT processes code-free within the intuitive visual environment or write your own code. Visually integrate data sources using more than 90+ natively built and maintenance-free connectors at no added cost. Focus on your data—the serverless integration service does the rest.

Improve productivity with shorter time to market

Develop simple and comprehensive ETL and ELT processes without coding or maintenance. Ingest, move, prepare, transform and process your data in a few clicks and complete your data modeling within the accessible visual environment. The managed Apache Spark™ service takes care of code generation and maintenance.

Reduce overhead costs

When migrating your SQL Server DB to the cloud, preserve your ETL processes and reduce operational complexity with a fully managed experience in Azure Data Factory. Rehost on-premises SSIS packages in the cloud with minimal effort using Azure SSIS integration runtime. ETL in Azure Data Factory provides you with the familiar SSIS tools you know.

Transfer data using prebuilt connectors

Access the ever-expanding portfolio of more than 90+ prebuilt connectors—including Azure data services, on-premises data sources, Amazon S3 and Redshift and Google BigQuery—at no additional cost. Data Factory provides efficient and resilient data transfer by using the full capacity of underlying network bandwidth, delivering up to 4 GB/s throughput.

Integrate data cost-effectively

Integrate your data using a serverless tool with no infrastructure to manage. Pay only for what you use and scale out with elastic capabilities as your data grows. Transform data with speed and scalability using the Apache Spark engine in Azure Databricks. Integrate expanded datasets from external organisations. Use Azure Data Share to accept new datasets into your Azure analytics environment, then use Data Factory to integrate them into your pipelines to prepare, transform and enrich your data to generate insights.