SQLBits 2024

Choosing between Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory

Learn the pros and cons of Microsoft Fabric, Azure Synapse Analytics and Azure Data Factory, and how to choose the right Data Integration solution for your project.
You're starting a new project where you need to ingest, store, transform and prepare data. Business users have already decided that they want to use Power BI (of course), but you need to decide which service to use for the data integration layer.

Do you choose:
a) Microsoft Fabric?
b) Azure Synapse Analytics?
c) Azure Data Factory?

If you're not sure what the right answer is for your project, then this session is for you!

We will start with an overview of the three services and the most common architectures where they shine. Then, we will compare their capabilities and features, and list the most important factors for deciding which one is right for our project. Finally, because we all know we will be asked "how much will it cost?", we will look at the pricing model for each service.