Skip to main content Explore View all products (200+) Microsoft Foundry Azure Copilot GitHub Copilot Azure Kubernetes Service (AKS) Azure Cosmos DB Azure Database for PostgreSQL Azure Arc Microsoft Fabric Linux virtual machines in Azure Foundry Models Foundry Agent Service Foundry IQ Foundry Tools Foundry Control Plane Observability in Foundry Control Plane Azure OpenAI in Foundry Models Azure Speech in Foundry Tools Azure Machine Learning View all databases Azure Cosmos DB Azure DocumentDB Azure SQL Azure Database for PostgreSQL Azure Managed Redis Microsoft Fabric Azure Databricks Linux virtual machines in Azure Windows Server on Azure Azure Functions Azure Virtual Machine Scale Sets Azure API Management Azure Container Apps Azure Kubernetes Service (AKS) Azure Kubernetes Fleet Manager Azure Container Registry Azure Red Hat OpenShift Azure Container Instances Azure Container Storage Azure Arc Azure Local Microsoft Defender for Cloud Azure Monitor Microsoft Sentinel Azure Migrate View all solutions (40+) Cloud solutions for small and medium businesses Cloud migration and modernization center Data analytics for AI Azure Databases AI apps and agents Microsoft Marketplace Microsoft Sovereign Cloud AI apps and agents Responsible AI with Azure AI Infrastructure Data analytics for AI Machine learning operations (MLOps) Low-code application development on Azure Integration Services Serverless computing DevOps Migration and modernization center .NET apps migration Databases on Azure Linux on Azure Oracle on Azure SAP on the Microsoft Cloud Adaptive cloud High-performance computing (HPC) Infrastructure as a service (IaaS) Resiliency Azure Essentials Azure Accelerate FinOps on Azure Microsoft Marketplace Azure pricing overview Create an Azure account Free Azure services Flexible purchase options Pricing calculator FinOps on Azure Maximize ROI from AI Azure savings plans Azure reservations Azure Hybrid Benefit Virtual Machines Azure SQL Microsoft Foundry Microsoft Fabric Azure Kubernetes Service (AKS) Microsoft Defender for Cloud Software Development Companies Microsoft Marketplace Find a partner Get started with Azure Customer stories Analyst reports, white papers, and e-books Videos Learn more about cloud computing Documentation Explore Azure portal Developer resources Quickstart templates Resources for startups Developer community Students Azure for partners Blog Events and Webinars Learn Support Contact Sales Get started with Azure Sign in
  • 2 min read

Azure Analytics: Clarity in an instant

Today, we're pleased to announce the preview of Azure Synapse Link, a cloud-native implementation of HTAP.

What 2020 is teaching us is that the world can change in an instant. In the span of a few months, we have witnessed massive disruptions across every industry around the globe. Factories are idle, hotels are empty, and the transportation backbone that connects us all is quiet. Navigating these unprecedented times is challenging and requires a new level of agility for businesses to deal with abrupt changes in our world.

Core to achieving this agility is the ability to gain fresh, continuous insights from data. Our commitment to customers is to make analytics in Azure the most performant and secure experience it can be, and when we debuted Azure Synapse Analytics in November 2019, we effectively removed the barriers between enterprise data warehousing and big data analytics to enable data professionals to collaborate, build, and manage their analytics solutions with ease. Azure Synapse Analytics is a game-changer in the industry, and it has been exciting to see the strong customer interest since its debut.

But we didn’t stop there. Another barrier that has long existed is the one that separates operational data from analytical systems. Historically, supporting hybrid transactional analytical processing (HTAP) workloads has been complex, costly, and has forced customers to make tradeoffs between transactional and analytical processing needs. They either had to over-provision expensive resources such as memory to support both analytics and transactions in a single system or maintain distinct systems. Most customers opted for the latter, which means that they are forced to manage complex extract, load, and transform (ETL) pipelines to connect their analytical and operational systems, adding lag to their time to insights.

There has never been a simple, low cost, cloud-native HTAP implementation that enables immediate, in-the-moment insights on a business—until today.

Today, we’re pleased to announce the preview of Azure Synapse Link, a cloud-native implementation of HTAP. A capability that removes the barriers between Azure operational database services and Azure Synapse Analytics, Azure Synapse Link enables customers to get insights from their real-time transactional data stored in their operational databases with a single click, without managing data movement or placing a burden on their operational systems. Azure Synapse Link is now available in Azure Cosmos DB and will be available in our other operational database services such as Azure SQL, Azure Database for PostgreSQL, Azure Database for MySQL, and others in the future.

Animation showing that with Azure Synapse Link, complex ETL processes are no longer needed. Azure Synapse Link establishes a link between operational data stored in Azure Cosmos DB and Azure Synapse Analytics, providing clarity in an instant.

How does it work? Fundamental to Azure Synapse Link is our cloud-native architecture. To enable it, customers simply click a button in their favorite Azure database service, and a direct link to the data is established with Azure Synapse Analytics. The operational data is then automatically and continuously made available to Azure Synapse Analytics in an optimized columnar structure, similar to a covering index. No complex ETL pipelines or additional database compute resources are required and customers can run their analytics workloads on real-time data through Azure Synapse Analytics immediately and cost-effectively.

To learn more about Azure Synapse Link, check out my Mechanics video:

Get started today

English (United States)
Your Privacy Choices Opt-Out Icon Your Privacy Choices
Consumer Health Privacy Sitemap Contact Microsoft Privacy Manage cookies Terms of use Trademarks Safety & eco Recycling About our ads