Design data integration and analysis
Recommending data integration with Data Factory and Fabric, and data analysis with Microsoft Fabric, Databricks and Synapse.
- 12 min
- 2 concepts
- Try it yourself
- 3-question check
Learn
Data integration moves and transforms data from many sources into one place; data analysis turns it into insight. Microsoft Fabric now brings most of these tools together as one SaaS platform built on OneLake.
- 1
Recommend a solution for data integration
Azure Data Factory (and Data Factory in Fabric) orchestrates ETL/ELT pipelines with 90+ connectors, copy activities and mapping data flows; a self-hosted integration runtime reaches on-premises sources. Use Event Hubs and Stream Analytics (or Fabric Real-Time Intelligence) for streaming data. Use mirroring in Fabric to replicate operational databases into OneLake in near real time.
Remember: On-premises source for Data Factory? Self-hosted integration runtime.
- 2
Recommend a solution for data analysis
Microsoft Fabric: one SaaS platform with lakehouses, warehouses, notebooks, real-time analytics and Power BI, all on OneLake. Azure Databricks: Apache Spark platform for data engineering and machine learning. Azure Synapse Analytics: dedicated SQL pools and Spark for existing investments. Azure Data Explorer: fast analysis of large volumes of logs and telemetry with KQL.
Remember: One integrated analytics platform: Microsoft Fabric.
A typical analytics flow
- IngestData Factory pipelines, mirroring or event streams.
- StoreOneLake or Data Lake Storage (bronze, silver, gold).
- TransformSpark notebooks, dataflows or SQL.
- ServeWarehouse or lakehouse SQL endpoint.
- VisualisePower BI reports.
Try it
Which service fits?
This interactive part needs JavaScript.
In the portal
- Data factoriesAzure portal: Data factories > Create
- FabricAzure portal: Microsoft Fabric > Create
Key terms
Click a card to see the definition.
Check your understanding
3 questions. Score 80% or more and these skills are marked as confident in your AZ-305 study plan.
What lets Data Factory reach an on-premises database?
SHIR runs inside your network.
What is OneLake?
All Fabric workloads share OneLake.
Which service is optimised for KQL over huge telemetry volumes?
ADX is built for that.
Sources
- Microsoft Learn: What is Azure Data Factory?
- Microsoft Learn: What is Microsoft Fabric?
- Microsoft Learn: Choose an analytical data store
- Microsoft Learn: Azure Databricks overview
Facts in this lesson are from Microsoft Learn. This site isn't affiliated with Microsoft.