Data Factory

Hybrid data integration, at global scale

Customers using Azure Data Factory:

Eliminate data silos

Azure Data Factory is a hybrid data integration service offering a code-free experience. Extract data from heterogenous data sources, transform it at cloud scale with the Mapping Data Flow feature (now in preview), publish it to any analytics engine or business intelligence tool and monitor and manage your data pipelines. Work with data wherever it lives, in the cloud or on-premises, with enterprise-grade security.

Accelerate your data integration projects by taking advantage of more than 80 available data source connectors. Use the graphical user interface to build, monitor and manage your data pipelines. Transform raw data into finished, shaped data ready for consumption by business intelligence tools or custom applications. Easily lift your SQL Server Integration Services (SSIS) packages to Azure and let Data Factory manage your resources to help you increase productivity and lower your costs.

Productive

Build automated data integration solutions with a visual drag-and-drop UI. Move data seamlessly from over 80 sources without writing code.

Hybrid

Build data integration pipelines which span on-premises and cloud. Easily lift your SQL Server Integration Services (SSIS) packages to Azure.

Trusted

Data movement using Azure Data Factory has been certified by HIPAA/HITECH, ISO/IEC 27001, ISO/IEC 27018 and CSA STAR.

Scalable

Build serverless, cloud-based data integration with no infrastructure to manage. Take advantage of elastic capabilities to scale out with your customer growth.

Service capabilities

Step 1: Access and ingest data with built-in connectors

Move data from on-premises and cloud sources to a centralised data store in the cloud for further analysis by using the Copy Data activity in a data pipeline.

Step 2: Build scalable data flow with codeless UI or write your own code

Build data integration and easily transform and integrate big data processing and machine learning with the visual interface.

Step 3: Schedule, run and monitor your pipelines

Invoke pipelines with on-demand and trigger-based scheduling. Visually monitor pipeline activity with logging and pipeline history and track error sources.

Data integration with Azure Data Factory

Visual drag-and-drop UI

Embrace simplicity. Get data pipelines up and running quickly. Use the visual drag-and-drop interface to build, deploy, transform and manage your data.

SSIS migration to cloud

Easily lift your SSIS packages to Azure while retaining the investments made in your on-premises SSIS. Get high availability and scalability, and reduce your costs using fully managed Azure services.

Comprehensive orchestration

Data Factory is much more than a way to move data from one place to another. Visually construct workflows to orchestrate data integration and data transformation processes at scale.

Multiple language support

Work the way you like. Use the visual interface or write your own code in Python, .NET or ARM to build pipelines. Choose from a wide range of processing services and put them into managed data pipelines to use the best tool for the job or insert custom code as a processing step in any pipeline.

Hybrid data movement and transformation

Data Factory offers more than 80 natively supported connectors, including Azure data services, on-premises data sources, Amazon S3 and Redshift, and Google BigQuery. The code-free cloud environment lets you focus on building business logic and data transforms, scaling for you as needed.

What can you do with Azure Data Factory?

Modernise your data warehouse

Integrate structured and unstructured data from on-premises and cloud data sources, transform data in big data and data warehouse engines, then load your data marts into Azure SQL Data Warehouse for business analytics.

Modern data-driven applications

Build custom data-driven cloud applications that embed a data integration experience with global scale.

SSIS migration to cloud

Easily lift your SSIS packages to Azure while retaining the investments made in your on-premises SSIS. Get high availability and scalability, and reduce your costs using fully managed Azure services.

Get up and running on Azure Data Factory with a hands-on lab

You will learn how to:

  • Lift SSIS packages to Azure.
  • Modernize your data warehouse.
  • Schedule and monitor your Data Factory pipelines.

Open lab

Read this e-book to learn how to lift your SQL Server Integration Services packages to Azure with Data Factory.

Read the e-book

Read this Data Factory whitepaper and learn how to build Data Factory pipelines in order to:

  • Modernize your data warehouse.
  • Build intelligent data-driven applications.
  • Lift your SQL Server Integration Services packages to Azure.
Read the Azure Data Factory whitepaper

Related products and services

SQL Data Warehouse

Elastic data warehouse as a service with enterprise-class features

Azure Databricks

Fast, easy and collaborative Apache Spark-based analytics platform

Azure Cosmos DB

Globally distributed, multi-model database for any scale

Discover what you can do with Data Factory today

Get started