Jeff Taylor
Principal Data Consultant
Database Consulting, LLC
Azure Data Factory (ADF)
Your New SSIS
Jeff Taylor
Principal Data Consultant
Database Consulting, LLC
Super Hero Suit
Jeff Taylor
Principal Data Consultant
Database Consulting, LLC
Azure Data Factory (ADF)
Your New SSIS
ADF - What is it?
Something Sweet!
Azure Data Factory is a 'code-free' (almost) cloud-based ETL/ELT data-driven integration service AT SCALE!
Extract, Load, Transform
You can still code if you want
ADF - What is it?
Something Sweet!
- Ingest - 100+ Native connectors
- Control flow - Pipelines
- Data Flow - Transformations
- Schedule
- Monitor
ADF - What is it?
Top-level concepts
- Pipelines - managing flow
- Activities - tasks
- Datasets - source and destination data
- Linked services - connection strings
- Data Flows - no-code transformations
- Integrated Runtimes - execution - (on-premise or in cloud)
ADF - Activities
ADF - What is it?
Something Sweet!
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
Something Sweet!
ADF - What is it?
ADF - How?
What is needed...
- A Resource Group - Manage and monitor costs
- Code Repo - To store ADF source code - Azure DevOps
- Data Storage - Azure Data Lake
- Database - Serverless Azure SQL
ADF - SQL
Configuration - Large
ADF - Data
Size - Large
ADF - $
Cost - Large
ADF - SQL
Configuration - Small
ADF - Data
Size - Small
ADF - $
Cost - Small
ADF - Demo
DEMO TIME
Questions
Thank you!
Jeff Taylor
Thank you for attending my session today.
If you have any additional questions, please don't hesitate to reach out.
Evaluate this session at:
ADF the new SSIS
By reviewmydb
