Try our new research platform with insights from 80,000+ expert users
Microsoft Parallel Data Warehouse Logo

Microsoft Parallel Data Warehouse pros and cons

Vendor: Microsoft
3.9 out of 5
1,421 followers
Start review

Pros & Cons summary

Microsoft Parallel Data Warehouse efficiently manages high data volumes with fast daily loads and real-time analysis. Valued for its performance, usability, and business intelligence capabilities, it integrates seamlessly with Microsoft products. Despite being cost-effective, it faces limitations in BI tool compatibility and concurrent queries. It provides robust data integrity and collection through SSIS packages but requires better reporting tools and technical support. SQL installation needs simplification for enhanced scalability.

Buyer's Guide

Get pricing advice, tips, use cases and valuable features from real users of this product.
Get the report

Prominent pros & cons

PROS

Microsoft Parallel Data Warehouse handles high volumes of data efficiently and supports fast data loads and real-time analysis.
Customer service and technical support are highly satisfactory.
The performance and usability of Microsoft Parallel Data Warehouse are highly valued, making it reliable and scalable.
Data collection and integration with business intelligence tools like BI and SAS are powerful features.
It integrates well with other Microsoft products and offers good firewall processing and data integrity features.

CONS

Microsoft Parallel Data Warehouse has limited compatibility with common BI tools and solutions.
Concurrent queries are restricted to 32, which limits its functionality as an active data warehouse.
More frequent feature updates are needed, as updates on the on-premise version are slow.
The tool is expensive, with high costs posing issues for users and businesses seeking cost-effective solutions.
Large datasets cause performance lags, leading to inefficiency during large query operations.
 

Microsoft Parallel Data Warehouse Pros review quotes

MS
May 4, 2020
Collecting the data through SSIS packages from different sources and putting them all in one data repository is the most powerful thing. While others have this feature, they don't have the simplicity or ease of use when getting a resource and knowing everything about it.
Read full review
it_user1352403 - PeerSpot reviewer
Aug 27, 2020
It is not a pricey product compared to other data warehouse solutions.
Read full review
reviewer1212726 - PeerSpot reviewer
Nov 20, 2019
I am very satisfied with the customer service/technical support.
Read full review
Buyer's Guide
Microsoft Parallel Data Warehouse
June 2025
Free Report: Microsoft Parallel Data Warehouse Reviews and More
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
DOWNLOAD NOW
860,592 professionals have used our research since 2012.
Albert Lacerda - PeerSpot reviewer
Mar 9, 2023
The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.
Read full review
Ashok Bhadra - PeerSpot reviewer
Jun 20, 2025
I'm very pro Microsoft because I think Microsoft products are highly intuitive and are widely used.
Read full review
MJ
Dec 9, 2019
One of the most important features is the ease of using MS SQL.
Read full review
PALAK SURI - PeerSpot reviewer
Aug 1, 2023
It is a stable solution...It is a scalable solution.
Read full review
reviewer2255670 - PeerSpot reviewer
Aug 11, 2023
We can store the data in a data lake for a very low cost.
Read full review
AN
Dec 15, 2019
The most valuable feature is the business intelligence (BI) part of it.
Read full review
SG
Aug 15, 2022
The solution has been reliable.
Read full review
Show 10 more reviews (out of 30)
 

Microsoft Parallel Data Warehouse Cons review quotes

MS
May 4, 2020
I would like the tool to support different operating systems.
Read full review
it_user1352403 - PeerSpot reviewer
Aug 27, 2020
It could be made more user-friendly for business users which would increase the user base.
Read full review
reviewer1212726 - PeerSpot reviewer
Nov 20, 2019
In the future I would love to see a slightly better automation engine, just for the data integration layer, to make it slightly easier for end-users or junior developers to get involved in incremental updating.
Read full review
Buyer's Guide
Microsoft Parallel Data Warehouse
June 2025
Free Report: Microsoft Parallel Data Warehouse Reviews and More
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: June 2025.
DOWNLOAD NOW
860,592 professionals have used our research since 2012.
Albert Lacerda - PeerSpot reviewer
Mar 9, 2023
The solution is expensive and has room for improvement.
Read full review
Ashok Bhadra - PeerSpot reviewer
Jun 20, 2025
The patch releases are a concern. For a customer with tons of servers, frequent patches lead to required reboots, which interrupts business.
Read full review
MJ
Dec 9, 2019
I think that the error messages need to be made more specific.
Read full review
PALAK SURI - PeerSpot reviewer
Aug 1, 2023
The only issue with the product is that the process is very slow when we have a huge amount of data.
Read full review
reviewer2255670 - PeerSpot reviewer
Aug 11, 2023
The product does not have all of the features that the native products have.
Read full review
AN
Dec 15, 2019
This solution would be improved with an option for in-memory data analysis.
Read full review
SG
Aug 15, 2022
We'd like to see it be a bit more compatible with other solutions.
Read full review
Show 10 more reviews (out of 30)

Product Categories

Product Categories
Data Warehouse

Popular Comparisons

Popular Comparisons
Teradata vs Microsoft Parallel Data Warehouse Logo
Teradata vs Microsoft Parallel Data Warehouse
Snowflake vs Microsoft Parallel Data Warehouse Logo
Snowflake vs Microsoft Parallel Data Warehouse
Oracle Exadata vs Microsoft Parallel Data Warehouse Logo
Oracle Exadata vs Microsoft Parallel Data Warehouse
SAP BW4HANA vs Microsoft Parallel Data Warehouse Logo
SAP BW4HANA vs Microsoft Parallel Data Warehouse
See all alternatives

Product Categories

Product Categories
Data Warehouse

Popular Comparisons

Popular Comparisons
Teradata vs Microsoft Parallel Data Warehouse Logo
Teradata vs Microsoft Parallel Data Warehouse
Snowflake vs Microsoft Parallel Data Warehouse Logo
Snowflake vs Microsoft Parallel Data Warehouse
Oracle Exadata vs Microsoft Parallel Data Warehouse Logo
Oracle Exadata vs Microsoft Parallel Data Warehouse
SAP BW4HANA vs Microsoft Parallel Data Warehouse Logo
SAP BW4HANA vs Microsoft Parallel Data Warehouse
See all alternatives
Related questions
  • 6
Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
  • 113
Oracle Exadata vs. HPE Vertica vs. EMC GreenPlum vs. IBM Netezza
  • 16
When evaluating Data Warehouse solutions, what aspect do you think is the most important to look for?
  • 19
At what point does a business typically invest in building a data warehouse?
  • 29
Is a data warehouse the best option to consolidate data into one location?
  • 138
What are the main differences between Data Lake and Data Warehouse?
  • 6
Infobright vs. Exadata vs. Teradata vs. SQL Server Data Warehouse- which is most compatible with front end tools?
  • 13
What is the best data warehouse tool?
  • 51
Which Data Strategy solution have you used?
  • 5
Why is Data Warehouse important for companies?