Amazon Redshift vs VMware Tanzu Greenplum comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
8,203 views|6,066 comparisons
87% willing to recommend
VMware Logo
2,089 views|1,712 comparisons
81% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Amazon Redshift 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 Amazon Redshift vs. VMware Tanzu Greenplum Report (Updated: March 2024).
767,667 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
"Though Amazon Redshift is good, it depends on what kind of business you're trying to do, what type of analytics you need, and how much data you have.""In terms of valuable features, I like the columnar storage that Redshift provides. The storage is one of the key features that we're looking for. Also, the data updates and the latency between the data-refreshes.""We have found Machine Learning use cases are very nice.""Redshift Spectrum is the most valuable feature.""The most valuable feature is the scalability, as it grows according to our needs.""The solution is scalable. It handles different loads very well.""Amazon Redshift offers a relatively flexible structure...I rate the technical support a nine out of ten.""The processing of data is very fast."

More Amazon Redshift Pros →

"Helps us to achieve large-scale analytics.""A very good, open-source platform.""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.""Very fast for query processing.""Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP 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.""It works very well with large database queries.""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."

More VMware Tanzu Greenplum Pros →

Cons
"It would be nice if we could turn off an instance. However, it would retain the instance in history, thus allowing us to restart without beginning from scratch.""Amazon Redshift does not have the capability to dynamically increase the VM file.""Planting is the primary key enforcement that should be improved.""The technical support should be better in terms of their knowledge, and they should be more customer-friendly.""The product must become a bit more serverless.""In our experiments, the handling of unstructured data was not very smooth.""In terms of improvement, I believe Amazon Redshift could work on reducing its costs, as they tend to increase significantly. Additionally, there are occasional issues with nodes going down, which can be problematic.""AWS Snowflake has a very good feature for cloning databases. It makes it easy to clone a data warehouse, which is useful. I would like to see this feature in Redshift."

More Amazon Redshift Cons →

"The initial setup is somewhat complex and the out-of-the-box configuration requires optimization.""Extra filters would be helpful.""If you have a user consuming a huge load of resources, it takes down the entire system.""I saw some limitation with respect to the column store, and removing this would be an improvement.""Some integration with other platforms like design tools, and ETL development tools, that will enable some advanced functionality, like fully down processing, etc.""They need to enhance integration with other Big Data products... to integrate with Big Data platforms, and to open a bi-directional connection between Greenplum and Big Data.""Tanzu Greenplum's compression for GPText could be made more efficient.""It will be very useful if we could communicate with other database types from Greenplum (using a database link)."

More VMware Tanzu Greenplum Cons →

Pricing and Cost Advice
  • "Redshift is very cost effective for a cloud based solution if you need to scale it a lot. For smaller data sizes, I would think about using other products."
  • "If you want a fixed price, an to not worry about every query, but you need to manage your nodes personally, use Redshift."
  • "BI is sold to our customer base as a part of the initial sales bundle. A customer may elect to opt for a white labeled site for an up-charge."
  • "One of my customers went with Google Big Query over Redshift because it was significantly cheaper for their project."
  • "Per hour pricing is helpful to keep the costs of a pilot down, but long-term retention is expensive."
  • "It's around $200 US dollars. There are some data transfer costs but it's minimal, around $20."
  • "The best part about this solution is the cost."
  • "The part that I like best is that you only pay for what you are using."
  • More Amazon Redshift 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.
    767,667 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer:Redshift Spectrum is the most valuable feature.
    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
    4th
    Views
    8,203
    Comparisons
    6,066
    Reviews
    23
    Average Words per Review
    480
    Rating
    7.7
    9th
    out of 34 in Data Warehouse
    Views
    2,089
    Comparisons
    1,712
    Reviews
    6
    Average Words per Review
    370
    Rating
    7.3
    Comparisons
    Also Known As
    Greenplum, Pivotal Greenplum
    Learn More
    Overview

    What is Amazon Redshift?

    Amazon Redshift is a fully administered, petabyte-scale cloud-based data warehouse service. Users are able to begin with a minimal amount of gigabytes of data and can easily scale up to a petabyte or more as needed. This will enable them to utilize their own data to develop new intuitions on how to improve business processes and client relations.

    Initially, users start to develop a data warehouse by initiating what is called an Amazon Redshift cluster or a set of nodes. Once the cluster has been provisioned, users can seamlessly upload data sets, and then begin to perform data analysis queries. Amazon Redshift delivers super-fast query performance, regardless of size, utilizing the exact SQL-based tools and BI applications that most users are already working with today.

    The Amazon Redshift service performs all of the work of setting up, operating, and scaling a data warehouse. These tasks include provisioning capacity, monitoring and backing up the cluster, and applying patches and upgrades to the Amazon Redshift engine.

    Amazon Redshift Functionalities

    Amazon Redshift has many valuable key functionalities. Some of its most useful functionalities include:

    • Cluster administration: The Amazon Redshift cluster is a group of nodes that contains a leader node and one (or more) compute node(s). The compute nodes needed are dependent on the data size, amount of queries needed, and the query execution functionality desired.
    • Cluster snapshots: Snapshots are backups of a cluster from an exact point in time. Amazon Redshift offers two types of snapshots: manual and automated. Amazon will store these snapshots internally in the Amazon Simple Storage Service (Amazon S3) utilizing an SSL connection. Whenever a Snapshot restore is needed, Amazon Redshift will create a new cluster and will import data from the snapshot as directed. 
    • Cluster access: Amazon Redshift provides several intuitive features to help define connectivity rules, encrypt data and connections, and control the overall access of your cluster.
    • IAM credentials and AWS accounts: The Amazon Redshift cluster is only accessible by the AWS account that created the cluster. This automatically secures the cluster and keeps it safe. Inside the AWS account, users access the AWS Identity and IAM protocol to create additional user accounts and manage permissions, granting specified users the desired access needed to control cluster performance.
    • Encryption: Users have the option to choose to encrypt the clusters for additional added security once the cluster is provisioned. When encryption is enabled, Amazon Redshift will store all the data in user-created tables in a secure encrypted format. To manage Amazon Redshift encryption keys, users will access AWS Key Management Service (AWS KMS).

    Reviews from Real Users

    Redshift's versioning and data security are the two most critical features. When migrating into the cloud, it's vital to secure the data. The encryption and security are there.” - Kundan A., Senior Consultant at Dynamic Elements AS

    “With the cloud version whenever you want to deploy, you can scale up, and down, and it has a data warehousing capability. Redshift has many features. They have enriched and elaborate documentation that is helpful.”- Aishwarya K., Solution Architect at Capgemini

    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
    Liberty Mutual Insurance, 4Cite Marketing, BrandVerity, DNA Plc, Sirocco Systems, Gainsight, Blue 449
    General Electric, Conversant, China CITIC Bank, Aridhia, Purdue University
    Top Industries
    REVIEWERS
    Computer Software Company32%
    Comms Service Provider14%
    Manufacturing Company11%
    Retailer11%
    VISITORS READING REVIEWS
    Educational Organization50%
    Financial Services Firm9%
    Computer Software Company7%
    Manufacturing Company4%
    REVIEWERS
    Financial Services Firm52%
    Comms Service Provider12%
    Marketing Services Firm12%
    Retailer8%
    VISITORS READING REVIEWS
    Financial Services Firm30%
    Computer Software Company13%
    Manufacturing Company6%
    Insurance Company5%
    Company Size
    REVIEWERS
    Small Business40%
    Midsize Enterprise24%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business10%
    Midsize Enterprise54%
    Large Enterprise36%
    REVIEWERS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    VISITORS READING REVIEWS
    Small Business18%
    Midsize Enterprise12%
    Large Enterprise70%
    Buyer's Guide
    Amazon Redshift vs. VMware Tanzu Greenplum
    March 2024
    Find out what your peers are saying about Amazon Redshift vs. VMware Tanzu Greenplum and other solutions. Updated: March 2024.
    767,667 professionals have used our research since 2012.

    Amazon Redshift is ranked 4th in Cloud Data Warehouse with 58 reviews while VMware Tanzu Greenplum is ranked 9th in Data Warehouse with 36 reviews. Amazon Redshift is rated 7.8, while VMware Tanzu Greenplum is rated 7.8. The top reviewer of Amazon Redshift writes "Provides one place where we can store data, and allows us to easily connect to other services with AWS". 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". Amazon Redshift is most compared with AWS Lake Formation, Snowflake, Vertica, Teradata and IBM Netezza Performance Server, whereas VMware Tanzu Greenplum is most compared with Oracle Exadata, Vertica, Oracle Database Appliance, Apache Hadoop and Teradata. See our Amazon Redshift 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.