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 the 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 that 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’ll learn how to:
- Lift SSIS packages to Azure.
- Modernise your data warehouse.
- Schedule and monitor your Data Factory pipelines.
Read this e-book to learn how to lift your SQL Server Integration Services packages to Azure with Data Factory.
Read the e-bookRead this Data Factory whitepaper and learn how to build Data Factory pipelines in order to:
- Modernise your data warehouse.
- Build intelligent data-driven applications.
- Lift your SQL Server Integration Services packages to Azure.
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