Microsoft Parallel Data Warehouse Review

It has inherent Hadoop integration that can refer HDFS by means of external tables, but there's a bottleneck if there are many partitions in the baseline table.


What is most valuable?

The bulk data-load feature with fast response is one of the most intriguing features. In addition, clustered column store index boosts OLAP query performance significantly.

How has it helped my organization?

For large scale big data analytics, we have been using this product for two years. It has inherent Hadoop integration that can refer HDFS by means of external tables. Thus, large scale historic data retention for business function improvement is quite easy, thus boosting customer confidence.

What needs improvement?

It supports partitioning to improve query performance. However, this has a bottleneck if there are many partitions in the baseline table and the underlying query performance degrades significantly.

For how long have I used the solution?

I've used it for two years.

What do I think about the stability of the solution?

We have not faced any major issues with this product.

What do I think about the scalability of the solution?

Unlike other MPPs, such as Netezza, this requires excellent expertise in SQL to reap the benefits of using it.

How are customer service and technical support?

Customer Service:

7/10

Technical Support:

7/10

Which solution did I use previously and why did I switch?

I have used Netezza as an MPP solution for around eight years, and from my personal experience, I believe Netezza has an edge over PDW due to user friendliness.

How was the initial setup?

The initial setup was straightforward as it is an appliance. The Microsoft support team work closely with us. We always do it in collaboration with the vendor team and thus ensure we get the best out of our investment. The project team is involved during the initial setup process, and thus optimal installation is ensured.

What about the implementation team?

We always do it in collaboration with the vendor team, and thus ensure we get the best out of our investment.

What was our ROI?

We are happy with the ROI. There is significant scope for improvement in this area.

What's my experience with pricing, setup cost, and licensing?

Pricing and licensing is competitive.

Which other solutions did I evaluate?

Any potential customer should explore PDW along with other MPP solutions before making a final decision on defining their OLAP analytics. We evaluated Teradata, as we had more expertise in SQL server, we were intrigued by PDW, and finally it emerged as the winner.

What other advice do I have?

This is a great product for big data analytics as it can challenge other MPPs quite well.

**Disclosure: I am a real user, and this review is based on my own experience and opinions.
More Microsoft Parallel Data Warehouse reviews from users
...who work at a Computer Software Company
...who compared it with Oracle Database Appliance
Add a Comment
Guest