Omitir navegación

SQL Data Warehouse

Fast, flexible, and secure cloud data warehouse for enterprises

Announcement

  • AB InBev
  • Adobe
  • LG CNS
  • Reckitt Benckiser
  • ThyssenKrupp
  • Thomson Reuters

Turbocharge your analytics with SQL Data Warehouse

Unlock new insights from your data with Azure SQL Data Warehouse, a fully managed cloud data warehouse for enterprises of any size that combines lightning-fast query performance with industry-leading data security. Optimize workloads by elastically scaling your resources in minutes. Get unlimited storage, automated administration, and built-in auditing and threat detection. Integrate seamlessly with Azure Active Directory, Azure Data Factory, Azure Data Lake Storage, Azure Databricks, and Microsoft Power BI to provide a single holistic modern data warehouse solution for all your analytical workloads.

SQL Data Warehouse is supported by a broad ecosystem of partners, including data preparation, ingestion service, and visualization tool providers. Enjoy guaranteed 99.9 percent availability in 40 Azure regions worldwide.

*Based on query execution performance testing of 66 queries conducted by Gigaom in July 2018; testing commissioned by Microsoft.

Built on the Microsoft SQL engine, SQL Data Warehouse provides breakthrough query performance in the cloud for the most complex and critical workloads.

Lighting-fast performance

Built on the Microsoft SQL engine, SQL Data Warehouse provides breakthrough query performance in the cloud for the most complex and critical workloads.

Our separated compute and storage optimizes compute provisioning to suit your workload demands and saves money on your highly variable workloads.

Highly elastic compute

Our separated compute and storage optimizes compute provisioning to suit your workload demands and saves money on your highly variable workloads.

Get end-to-end security and compliance features including Azure Active Directory virtual networks, auditing, threat detection, and data encryption.

Industry-leading security

Get end-to-end security and compliance features including Azure Active Directory virtual networks, auditing, threat detection, and data encryption.

Get end-to-end security and compliance features including Azure Active Directory virtual networks, auditing, threat detection, and data encryption.

Integración perfecta

Consolidate data silos and unify structured, unstructured, and streaming data with our cloud data warehouse solution.

Red de asociados de confianza

Accelerate your time to value with an enterprise data warehouse backed by one of our trusted partners.

  • Datometry
  • Qlik
  • MicroStrategy
  • Informatica Cloud
  • Talend
  • Tableau

Características del servicio

Democratize data across your enterprise.

Massive query concurrency

Democratize data across your enterprise.

Ingest and query from multiple data types and sources within a single solution.

Integrated data processing

Ingest and query from multiple data types and sources within a single solution.

Provision thousands of compute cores in less than five minutes, and scale to a petabyte in hours.

Quick and easy provisioning

Provision thousands of compute cores in less than five minutes, and scale to a petabyte in hours.

Independently scale for performance or memory with separate compute and storage.

Elastic design

Independently scale for performance or memory with separate compute and storage.

Help protect your data with virtual network service endpoints, advanced threat detection, always-on encryption, auditing, and simplified secure access.

Seguridad avanzada

Help protect your data with virtual network service endpoints, advanced threat detection, always-on encryption, auditing, and simplified secure access.

Automate infrastructure allocation and workload optimization to focus on data analysis, and use the built-in advisor to optimize your cloud data warehouse.

Infraestructura completamente administrada

Automate infrastructure allocation and workload optimization to focus on data analysis, and use the built-in advisor to optimize your cloud data warehouse.

Integrate with leading data preparation and visualization vendors and get support from our partners to accelerate time to value.

Un ecosistema muy sólido

Integrate with leading data preparation and visualization vendors and get support from our partners to accelerate time to value.

Take advantage of Microsoft SQL Server, the industry’s top-performing SQL engine, offering comprehensive support for SQL language.

Powerful SQL engine

Take advantage of Microsoft SQL Server, the industry’s top-performing SQL engine, offering comprehensive support for SQL language.

Help ensure peace of mind with more than 50 government and industry compliance certifications, including HIPAA.

Cumplimiento normativo líder del sector

Help ensure peace of mind with more than 50 government and industry compliance certifications, including HIPAA.

Benefit from availability in 40 Azure regions, the most among all cloud-based data warehouse providers.

Disponibilidad global

Benefit from availability in 40 Azure regions, the most among all cloud-based data warehouse providers.

¿Qué se puede crear con Azure SQL Data Warehouse?

Modern data warehouse

Use SQL Data Warehouse with Azure Analysis Services to achieve the scale you want at the price and performance level you choose. This architecture also provides resource isolation and advanced security features.

Advanced analytics for big data

Easily integrate your on-premises and cloud data applications to your enterprise data warehouse using Azure Data Factory. Choose from the leading open source solutions, including Azure Databricks for Apache Spark and Azure HDInsight for Apache Hadoop, Spark, and Kafka. Process unstructured data and load terabytes of results to SQL Data Warehouse using PolyBase. Use Azure Machine Learning to write algorithms easily and run them on-premises, in the cloud, or at the edge.

Real-time analytics

Capture data continuously from any IoT device or from website clickstream logs using Apache Kafka for HDInsight or Azure IoT Hub. Process data in real time using the leading open source solutions, including Azure Databricks for Apache Spark and Azure HDInsight for Apache Hadoop, Spark, and Kafka. Easily adjust the frequency of your microbatching with Azure Event Grid, which sends an event to SQL Data Warehouse to load processed data using PolyBase.

Arquitectura en estrecha tipo hub-and-spoke

Use hub-and-spoke architecture to achieve the scale you want at the price and performance level you choose. This architecture also provides resource isolation and advanced security features.

Consolidación de data marts

Bring together multiple databases into an enterprise data warehouse to eliminate data silos and make the right insights accessible across your organization.

On-premises data warehouse migration

Migrate your traditional workloads to SQL Data Warehouse to optimize your data. Maintain legacy applications and create new use cases by bringing in unstructured data.

Productos y servicios relacionados

Data Factory

Integración fácil de datos híbridos a escala empresarial

Azure Data Lake Store

Almacenamiento de lago de datos escalable de forma masiva

Azure Databricks

Plataforma de análisis rápida, sencilla y de colaboración basada en Apache Spark

HDInsight

Aprovisione clústeres de Hadoop, Spark, R Server, HBase y Storm en la nube

Azure Analysis Services

Motor de análisis de nivel empresarial como servicio

Power BI

Mejorar el análisis de negocios

Pruebe SQL Data Warehouse con una cuenta de Azure gratuita