Microsoft Parallel Data Warehouse vs VMware Tanzu Greenplum comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed Microsoft Parallel Data Warehouse vs. VMware Tanzu Greenplum Report (Updated: March 2024).
763,955 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"The UI is very simple and functional for my clients, most of the clients that use the solution are not experts.""We can store the data in a data lake for a very low cost.""We are able to monitor daily jobs, so if there is anything that needs to be done then we can do it.""The solution's integration is good.""Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.""It handles high volumes of data very well.""I like Data Warehouse's data integrity features. Data integrity is what databases are made for as opposed to spreadsheets.""It is a very stable database."

More Microsoft Parallel Data Warehouse Pros →

"It's super easy to deploy and it also supports different languages and analytics.""The loading speed is very good.""Scalable (Massive) Parallel Processing (MPP) – The ability to bring to bear large amounts of compute against large data sets with Greenplum and the EMC DCA has proven itself to be very effective.""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.""It works very well with large database queries.""Very fast for query processing.""Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform.""With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."

More VMware Tanzu Greenplum Pros →

Cons
"​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""I would like the ability to do more real-time type updates instead of batch-oriented updates.""It needs more compatibility with common BI tools.""The query is slow if we don't optimize it.""This solution would be improved with an option for in-memory data analysis.""More tools to help designers should be included.""I would like the tool to support different operating systems.""The reporting for certain types of data needs to be improved."

More Microsoft Parallel Data Warehouse Cons →

"Implementation takes a long time.""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.""If you have a user consuming a huge load of resources, it takes down the entire system.""they need to interact more with customers. They need to explain the features, especially when there are new releases of Greenplum. I know just from information I've found that it has other features, it can be used to for analytics, for integration with Big Data, Hadoop. They need to focus on this part with the customer.""Maintenance is time-consuming.""It will be very useful if we could communicate with other database types from Greenplum (using a database link).""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."

More VMware Tanzu Greenplum Cons →

Pricing and Cost Advice
  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "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."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse Pricing and Cost Advice →

  • "It is the best product with best fit for price/performance customer objectives."
  • "Pricing is good compared to other products. It's fine."
  • "We are using the open-source version of this solution."
  • "Tanzu Greenplum's pricing is really competitive and gives excellent value for money."
  • "It’s an open-source solution."
  • More VMware Tanzu Greenplum Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    763,955 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    Top Answer:It’s an open-source solution. There are no expenses for using it.
    Top Answer:Maintenance is time-consuming. It takes time to VACUUM and ANALYZE the tables to remove the fragmentations.
    Ranking
    8th
    out of 33 in Data Warehouse
    Views
    638
    Comparisons
    516
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    9th
    out of 33 in Data Warehouse
    Views
    2,186
    Comparisons
    1,771
    Reviews
    6
    Average Words per Review
    370
    Rating
    7.3
    Comparisons
    Also Known As
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Greenplum, Pivotal Greenplum
    Learn More
    Overview

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    VMware Tanzu Greenplum is a massively parallel processing (MPP) data platform that enables organizations to store, manage, and analyze large volumes of data. It provides a unified analytics platform that supports various data types and sources, including structured, semi-structured, and unstructured data. 

    The solution is highly scalable and can be deployed on-premises, in the cloud, or hybrid environments. It includes advanced security features, high availability, and disaster recovery capabilities to minimize downtime and ensure business continuity. Tanzu Greenplum provides a comprehensive set of tools and services for building, deploying, and managing modern applications.

    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
    Top Industries
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Financial Services Firm18%
    Insurance Company7%
    University6%
    REVIEWERS
    Financial Services Firm52%
    Marketing Services Firm12%
    Comms Service Provider12%
    Retailer8%
    VISITORS READING REVIEWS
    Financial Services Firm28%
    Computer Software Company13%
    Manufacturing Company6%
    Insurance Company5%
    Company Size
    REVIEWERS
    Small Business34%
    Midsize Enterprise14%
    Large Enterprise51%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise18%
    Large Enterprise66%
    REVIEWERS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise10%
    Large Enterprise71%
    Buyer's Guide
    Microsoft Parallel Data Warehouse vs. VMware Tanzu Greenplum
    March 2024
    Find out what your peers are saying about Microsoft Parallel Data Warehouse vs. VMware Tanzu Greenplum and other solutions. Updated: March 2024.
    763,955 professionals have used our research since 2012.

    Microsoft Parallel Data Warehouse is ranked 8th in Data Warehouse with 12 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 6 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 "User-friendly UI and good support". 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, Oracle Database Appliance, Vertica 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.