We performed a comparison between Microsoft Parallel Data Warehouse and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I am very satisfied with the customer service/technical support."
"It is a very stable database."
"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."
"Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time."
"The data transmissions between the data models is the most valuable feature."
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."
"The solution's integration is good."
"Microsoft Parallel Data Warehouse integrates beautifully with other Microsoft ecosystem products."
"Very fast for query processing."
"Pivotal Greenplum's shared-nothing architecture."
"A very good, open-source platform."
"The loading speed is very good."
"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."
"The most valuable feature for us is horizontal scaling."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"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."
"Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution."
"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."
"Some compatibility issues occur during deployment, so we need to build the product from scratch for some features."
"More tools to help designers should be included."
"If the database is large with a lot of columns then it is difficult to clean the data."
"The query is slow if we don't optimize it."
"I would like to see better visualization features."
"The feature updates on the on-premise solution come very slowly, and it would be great if they came faster."
"Lacks sufficient inbuilt machine-learning functions for complex use cases."
"VMware Tanzu Greenplum needs improvement in the memory area and improved methods for quick access to the disc. So, one of the quick goals of Greenplum must work on enhancing access to the disc by adding hints in the database."
"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."
"Initial setup is a little complex. It took around two weeks to deploy."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"Maintenance is time-consuming."
More Microsoft Parallel Data Warehouse Pricing and Cost Advice →
Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 32 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Microsoft Parallel Data Warehouse is rated 7.6, while VMware Tanzu Greenplum is rated 7.8. The top reviewer of Microsoft Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". On the other hand, the top reviewer of VMware Tanzu Greenplum writes "Very efficient at large scale analytics; lacks inbuilt machine-learning functions for complex use cases". Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA and Snowflake, whereas VMware Tanzu Greenplum is most compared with Oracle Exadata, Vertica, Oracle Database Appliance and Apache Hadoop. See our Microsoft Parallel Data Warehouse vs. VMware Tanzu Greenplum report.
See our list of best Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.