We performed a comparison between Microsoft Azure Synapse Analytics 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."The most important feature for me is the integration with PolyBase."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"Technical support is okay in terms of the help they provide."
"Fills the gap between big data and classic data warehouses."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"The architecture, including compute and storage, is good."
"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."
"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 loading speed is very good."
"The most valuable feature for us is horizontal scaling."
"It works very well with large database queries."
"A very good, open-source platform."
"The parallel load features mean that Greenplum is capable of high-volume data loading in parallel to all of the cluster segments, which is really valuable."
"Pivotal Greenplum's shared-nothing architecture."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"I'd like to see part of the service de-coupled."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization."
"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."
"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."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"It will be very useful if we could communicate with other database types from Greenplum (using a database link)."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while VMware Tanzu Greenplum is rated 7.8. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". 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 Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, SAP BW4HANA, Amazon Redshift and Teradata, whereas VMware Tanzu Greenplum is most compared with Oracle Exadata, Vertica, Oracle Database Appliance, Apache Hadoop and Snowflake. See our Microsoft Azure Synapse Analytics vs. VMware Tanzu Greenplum report.
See our list of best Data Warehouse vendors and best Cloud 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.