What is Azure Data Factory?

• A cloud based data integration service that ochestrate data movement and transformation at scale
• A managed, cloud-based, code free “ETL-as-a-Service” and Data Integration Service
• Built for complex hybrid ETL and data integration projects
• Allows to create data-driven workflows for orchestrating data movement and transforming data at scale
• Creates and schedules data-driven workflows
• Publishes transformed data to target data store i.e. Azure SQL, Azure Synapse (data warehouse) etc.
• A serviceless ELT service

Use Cases

• Data migration for cloud migration projects
• Moving on-premise data to cloud database with new scheme
• Data migration for advanced analytics projects
• Lift and shift existing SSIS packages to cloud
• Hybrid (on-premise to cloud VNet) data integration