How to integrate CMD Group in Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse)
Discover how to integrate CMD Group and Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) and instantly get access to your data.
WITH DATA VIRTUALITY PIPES
Replicate CMD Group data into Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) and analyze it with your BI Tool.

About CMD Group
CMD Group, formerly Reed Construction Data and Construction Market Data, is a provider of business information for the North American construction industry. The CMD Group tracks data of different projects per year and provides monthly analysis and data for all aspects of the construction industry in Canada and the US. CMD also provides a detailed view of construction activity, including historical data, current-year projections and a five-year forecast. Their research helps customers to create forecasts and plan tactical marketing strategies.
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.
MOVE YOUR DATA WITH PIPES
Pipes allows you to connect to CMD Group, Microsoft Azure Synapse Analytics (formerly Azure SQL Data Warehouse) 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:
- Cloud/On-Premises Hosting
- Complex Data Transformations
- Advanced Jobs & Schedules
- Multiple Target Storages
- Custom Extraction Definitions
- Job Dependencies
- SQL Modelling Layer
- Complex Replication Types
- Custom Job Triggers