No more typing reviews! Try our Samantha, our new voice AI agent.
Microsoft Parallel Data Warehouse Logo

Microsoft Parallel Data Warehouse pros and cons

Vendor: Microsoft
3.9 out of 5

Pros & Cons summary

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 excels in handling high volumes of data efficiently, supporting fast daily loads and near real-time analysis.
The integration within Microsoft's ecosystem is seamless, enabling powerful data collection and reporting capabilities.
Customers appreciate its scalability, from a few users to many, while managing large data amounts smoothly.
The ability to control costs by pausing the service when not in use is a significant advantage.
It offers reliable performance and strong data integrity features, crucial for effective database management.

CONS

Microsoft Parallel Data Warehouse lacks compatibility with various Business Intelligence tools and has limited concurrent queries, positioning it more as a data storage option rather than a dynamic data warehouse.
Microsoft Parallel Data Warehouse would benefit from better automation for the data integration process, which would make incremental updating easier for users and developers.
Error messages in the Microsoft Parallel Data Warehouse need greater specificity to improve troubleshooting.
There is a need for improved data visualization and reporting features in Microsoft Parallel Data Warehouse.
The expense of Microsoft Parallel Data Warehouse remains a concern for many customers, particularly given its high cost compared to other solutions.
 

Microsoft Parallel Data Warehouse Pros review quotes

it_user4014 - PeerSpot reviewer
Developer at a tech consulting company with 51-200 employees
Sep 15, 2014
Microsoft SQL Server Parallel Data Warehouse provides significant performance boost from 10-100 X times faster for data loading operation.
it_user6414 - PeerSpot reviewer
CEO at a tech company with 51-200 employees
May 6, 2013
SQL Data Warehouse provides our organization with a way to access all corporate data in a uniform way.
it_user347586 - PeerSpot reviewer
Solution Architect at a comms service provider with 11-50 employees
Nov 30, 2015
This is a great product for big data analytics as it can challenge other MPPs quite well.
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
892,287 professionals have used our research since 2012.
it_user694689 - PeerSpot reviewer
Business Intelligence evangelist at a hospitality company with 10,001+ employees
Jun 30, 2017
MPP processing gives us the ability to distribute large data sets across nodes.
it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees
Feb 27, 2018
It handles high volumes of data very well.
it_user400518 - PeerSpot reviewer
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 10,001+ employees
Mar 6, 2018
We are using PDW as an EDW solution.
reviewer1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
Nov 20, 2019
I am very satisfied with the customer service/technical support.
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees
Dec 5, 2019
The most valuable features are the performance and usability.
MJ
BI Developer at a healthcare company with 51-200 employees
Dec 9, 2019
One of the most important features is the ease of using MS SQL.
CC
Product Director at a insurance company with 10,001+ employees
Dec 9, 2019
The most valuable feature for me is querying.
 

Microsoft Parallel Data Warehouse Cons review quotes

it_user4014 - PeerSpot reviewer
Developer at a tech consulting company with 51-200 employees
Sep 15, 2014
It requires significant infrastructure expertise to implement.
it_user6414 - PeerSpot reviewer
CEO at a tech company with 51-200 employees
May 6, 2013
It is expensive. SQL Data Warehouse is not supported by all versions of SQL Server such as the Express version and therefore becomes unavailable to many limiting its acquisition and use.
it_user347586 - PeerSpot reviewer
Solution Architect at a comms service provider with 11-50 employees
Nov 30, 2015
Unlike other MPPs, such as Netezza, this requires excellent expertise in SQL to reap the benefits of using it.
Learn what your peers think about Microsoft Parallel Data Warehouse. Get advice and tips from experienced pros sharing their opinions. Updated: April 2026.
892,287 professionals have used our research since 2012.
it_user694689 - PeerSpot reviewer
Business Intelligence evangelist at a hospitality company with 10,001+ employees
Jun 30, 2017
There were scalability issues in that there is a limit to 32 concurrent queries.
it_user222813 - PeerSpot reviewer
BI Business Analyst at a transportation company with 1,001-5,000 employees
Feb 27, 2018
It needs more compatibility with common BI tools.
it_user400518 - PeerSpot reviewer
Teradata DBA / Parallel datawarehouse DBA at a tech services company with 10,001+ employees
Mar 6, 2018
​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.
reviewer1212726 - PeerSpot reviewer
Microsoft Dynamics Specialist at a computer software company with 51-200 employees
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.
EG
Senior System Analyst at a tech services company with 1,001-5,000 employees
Dec 5, 2019
More tools to help designers should be included.
MJ
BI Developer at a healthcare company with 51-200 employees
Dec 9, 2019
I think that the error messages need to be made more specific.
CC
Product Director at a insurance company with 10,001+ employees
Dec 9, 2019
I would like to see better visualization features.