How to connect Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) to MicroStrategy

Discover how to connect Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) to MicroStrategy and how to integrate Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) with other data sources to build an organization-wide data model.

WITH DATA VIRTUALITY PIPES
Replicate your data sources into Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) and analyze it with MicroStrategy.
How to connect Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) to MicroStrategy with Pipes


About Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse)

Microsoft Azure is a leading cloud computing infrastructure and platform created by Microsoft for building, managing, and deploying services and applications through Microsoft-managed global data centers. Azure Synapse is an analytics service bringing together enterprise data warehousing and Big Data analytics. Synapse offers a unified experience to ingest, prepare, manage and serve data for immediate BI and machine learning needs.

About MicroStrategy

MicroStrategy is a enterprise analytics and mobility platform. It supports interactive dashboards, scorecards, highly formatted reports, ad hoc query, thresholds and alerts, and automated report distribution. Interfaces include web, desktop (for developers) and Microsoft Office integration. MicroStrategy Mobile also supports mobile BI.

MOVE YOUR DATA WITH PIPES

Pipes allows you to connect to Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse), MicroStrategy and more than 200 other cloud services and databases. Automate your data workflows with data pipelines.

DATA VIRTUALITY OFFERS TWO PIPES SOLUTIONS

depending on your needs.

Pipes

Easy and reliable data replication in the cloud

Pipes enables you to move data from any data source to your target storage or data warehouse on schedule. Integrate your data with just a few clicks and without any coding.

Pipes Professional

Advanced data replication hosted in the cloud or on-premises

Pipes Professional enables you to transform and model your data with SQL before replication. Customize your data pipelines and build data models across sources in 80% less time.

Pipes Professional features include:

  • SQL Modelling Layer
  • Complex Replication Types
  • Advanced Jobs & Schedules
  • Metadata Repositories
  • Custom Extraction Definitions
  • Job Dependencies
  • Multiple Target Storages
  • Data Federation Features
  • Custom Job Triggers
Your future with automated data workflows is only a few clicks away.