Microsoft Azure Synapse

What is Azure Synapse?

Azure Synapse Analytics is a limitless analytics service that brings together data integration, enterprise data warehousing, and big data analytics. It gives you the freedom to query data on your terms, using either serverless or dedicated resources—at scale. Azure Synapse brings these worlds together with a unified experience to ingest, explore, prepare, manage, and serve data for immediate BI and machine learning needs.

  • Limitless scale

Deliver insights from all your data, across data warehouses and big data Analytics systems, with blazing speed.

  • Powerful insights

Expand discovery of insights from all your data and apply machine learning models to all your intelligent apps.

  • Unified experience

Significantly reduce project development time with a unified experience for developing end-to-end analytics solutions.

  • Instant clarity

Gain instant clarity on your business with the freshest data possible from your operational systems, in every moment, with Azure Synapse Link.

  • Unmatched security

Secure data with the most advanced security and privacy features in the market, such as column- and row-level security and dynamic data masking.


Key Service Capabilities

  • Unified analytics platform

Perform data integration, data exploration, data warehousing, big data analytics, and machine learning tasks from a single, unified environment.

  • Serverless and dedicated options

Support both data lake and data warehouse use cases and choose the most cost-effective pricing option for each workload.

  • Enterprise data warehousing

Build your mission-critical data warehouse on the proven foundation of the industry’s top-performing SQL engine.

  • Data lake exploration

Bring together relational and nonrelational data and easily query files in the data lake with the same service you use to build data warehousing solutions.

  • Code-free hybrid data integration

Build ETL/ELT processes in a code-free visual environment to easily ingest data from more than 95 native connectors.

  • Deeply integrated Apache Spark and SQL engines

Enhance collaboration among data professionals working on advanced analytics solutions. Easily use T-SQL queries on both your data warehouse and Spark engines.

  • Cloud-native HTAP

Get insights from real-time transactional data stored in operational databases, such as Azure Cosmos DB, with a single click.

  • Choice of language

Use your preferred language, including T-SQL, Python, Scala, Spark SQL, and .Net—whether you use serverless or dedicated resources.

  • Integrated AI and BI

Complete your end-to-end analytics solution with deep integration of Azure Machine Learning, Azure Cognitive Services, and Power BI.

  • End-to-end management and monitoring

Simplify the monotonous, but necessary, data tasks that each team must do—secure your Synapse workspace and we’ll take care of the rest.