What is Azure Data Factory?
- A managed, cloud-based, code free “ETL-as-a-Service” and 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
- 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