Gartner Research

Architecting Data and Analytics Pipelines in Azure

Published: 17 June 2019

ID: G00377900

Analyst(s): Sanjeev Mohan


Microsoft Azure continues to innovate, evolve and expand as cloud deployments accelerate. Data and analytics technical professionals must assess the data storage, transformation and management capabilities of Azure to build highly performant end-to-end analytics pipelines and architectures.

Table Of Contents


  • Ingestion
    • Azure Data Factory (ADF)
    • Azure Event Hubs
    • Third-Party Ingestion Options
    • Azure Stream Analytics
  • Data Integration and Transformation
    • Azure Data Factory (ADF)
    • Azure Databricks
    • Azure HDInsight
    • Third-Party Integration and Transformation Options
  • Data Persistence
    • Azure Data Lake Store (ADLS) Gen2
    • Common Data Model (CDM)
    • Azure SQL Database (SQL DB)
    • Azure Database for MySQL, PostgreSQL and MariaDB
    • Why Clients Should Consider Azure Database
    • Azure SQL Data Warehouse (SQL Data Warehouse)
    • Azure Cosmos DB
    • Azure Cache for Redis
  • Analytics
    • Power BI
    • Azure Analysis Services (AAS)
    • Azure Data Explorer (ADX)
  • Advanced Analytics
  • Data Governance
  • Strengths
  • Weaknesses


The Details

  • Modern Data Warehouse
    • Current State
    • Future State
  • Real-Time Analytics
  • Azure IoT Architecture

Gartner Recommended Reading

©2021 Gartner, Inc. and/or its affiliates. All rights reserved. Gartner is a registered trademark of Gartner, Inc. and its affiliates. This publication may not be reproduced or distributed in any form without Gartner’s prior written permission. It consists of the opinions of Gartner’s research organization, which should not be construed as statements of fact. While the information contained in this publication has been obtained from sources believed to be reliable, Gartner disclaims all warranties as to the accuracy, completeness or adequacy of such information. Although Gartner research may address legal and financial issues, Gartner does not provide legal or investment advice and its research should not be construed or used as such. Your access and use of this publication are governed by Gartner’s Usage Policy. Gartner prides itself on its reputation for independence and objectivity. Its research is produced independently by its research organization without input or influence from any third party. For further information, see Guiding Principles on Independence and Objectivity.

Already have a Gartner Account?

Become a client

Learn how to access this content as a Gartner client.