Try our new research platform with insights from 80,000+ expert users

Microsoft Parallel Data Warehouse vs VMware Tanzu Data Solutions comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Microsoft Parallel Data War...
Ranking in Data Warehouse
10th
Average Rating
7.8
Reviews Sentiment
7.4
Number of Reviews
34
Ranking in other categories
No ranking in other categories
VMware Tanzu Data Solutions
Ranking in Data Warehouse
7th
Average Rating
8.0
Reviews Sentiment
7.4
Number of Reviews
82
Ranking in other categories
Database Development and Management (7th), Relational Databases Tools (9th), Message Queue (MQ) Software (5th)
 

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of Microsoft Parallel Data Warehouse is 1.0%, down from 1.3% compared to the previous year. The mindshare of VMware Tanzu Data Solutions is 5.1%, up from 4.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

StevenLai - PeerSpot reviewer
Strong scalable solution with streamlined metadata warehousing
We use it to build our data warehouse and databases, and everything in the back end It helps streamline our metadata warehousing process. As it is our only type of data warehouse and database, it serves as our source, destination, and staging area. This product has many features which are useful…
Derrick Brockel - PeerSpot reviewer
The product improves site reliability, but it is not stable, and the initial deployment was a little difficult
When we had outages, we had timeouts. Sometimes, the nodes would drop out of a cluster. Therefore, the applications would get timeouts. There is a newer version out that we're planning to upgrade to for some stability. It could also be caused by our design. The product must improve its reliability. It'd be nice if nodes could drop out and notify each other in a timely manner so that the applications wouldn't know if there was a problem.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is not a pricey product compared to other data warehouse solutions."
"We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it."
"It is very strong, scalable, and has tons of features."
"One of the most important features is the ease of using MS SQL."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"Tools like the BI and SAS are excellent."
"The initial setup was straightforward."
"It is a stable solution...It is a scalable solution."
"Large amounts of data can be moved pretty fast using the solution."
"The most valuable feature for me is that it is open source. The licensing costs are really low and they are transparent."
"RabbitMQ provides access to SDKs for development and the ability to raise and log tickets if we encounter issues. We can integrate RabbitMQ using various languages like Java or Python using the provided SDKs."
"The product's feature of data transaction works fast."
"We chose Greenplum because of the architecture in terms of clustering databases and being able to have, or at least utilize the resources that are sitting on a database."
"The solution's best feature is its exceptional speed, delivering efficient utilization of resources."
"It's one of the fastest databases in the market. It's easy to use. From a maintenance perspective it's a good product. The segmentation, or architecture of the product is different than other databases such as Oracle. So even in 10 years, the data distribution for such segments will not affect other segments. The query performance of the product, for complex queries, is very good. It has good integration with Hadoop."
"Helps us to achieve large-scale analytics."
 

Cons

"This solution would be improved with an option for in-memory data analysis."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"It could offer more development across the solution."
"The query is slow if we don't optimize it."
"We'd like to see it be a bit more compatible with other solutions."
"​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"I would like the tool to support different operating systems."
"If the database is large with a lot of columns then it is difficult to clean the data."
"The product needs to focus on offering more use case documentation because browsing the internet to find it can be a process filled with struggles."
"If messages pile up until the space of the memory is full, then basically, the cluster goes down, and someone has to log in through the backend and purge all messages."
"The user interface could be improved."
"I would like to see the performance of the administration portal improved and additional messaging protocols."
"VMware RabbitMQ's configuration process could be easier to understand."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"One of the disadvantages, not a disadvantage with the product itself, but overall, is the expertise in the marketplace. It's not easy to find a Greenplum administrator in the market, compared to other products such as Oracle."
"They should add more analytics. Their documentation could also be improved so that I don't have to bother my co-workers and tech support so often."
 

Pricing and Cost Advice

"The tool could be expensive if we need to manage a lot of data."
"Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
"All the features that we use do not require any additional subscription or yearly fees."
"The solution is cost-effective."
"I think the program is well-priced compared to the other offerings that are out in the market."
"The solution's pricing is fairly decent for organizations with huge data sizes."
"Technical support is an additional fee and is expensive."
"They offer an annual subscription. The pricing depends on the size of the environments."
"are using the open-source version, which can be used free of cost."
"We are using the open-source version of this solution."
"Since the tool is an open-source product, there is no need to pay anything."
"This is an open source solution."
"It’s an open-source solution."
"It is the best product with best fit for price/performance customer objectives."
"Tanzu Greenplum's pricing is really competitive and gives excellent value for money."
"The price is pretty good."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
28%
Financial Services Firm
19%
Insurance Company
8%
Government
6%
Financial Services Firm
29%
Computer Software Company
16%
Manufacturing Company
7%
Healthcare Company
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Microsoft Parallel Data Warehouse?
Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
What needs improvement with Microsoft Parallel Data Warehouse?
There are many areas for improvement. A major issue is with table statistics. Sometimes the statistics are not refreshed correctly, which causes issues for us. When we update a table, it should tri...
How does IBM MQ compare with VMware RabbitMQ?
IBM MQ has a great reputation behind it, and this solution is very robust with great stability. It is easy to use, simple to configure and integrates well with our enterprise ecosystem and protocol...
What is your experience regarding pricing and costs for VMware Tanzu Greenplum?
It’s an open-source solution. There are no expenses for using it.
 

Also Known As

Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
Greenplum, Pivotal Greenplum, VMware RabbitMQ, VMware Tanzu GemFire, VMware Postgres
 

Learn More

 

Overview

 

Sample Customers

Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
General Electric, Conversant, China CITIC Bank, Aridhia, Purdue University
Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. VMware Tanzu Data Solutions and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.