Coming October 25: PeerSpot Awards will be announced! Learn more

Teradata vs Vertica comparison

Cancel
You must select at least 2 products to compare!
Teradata Logo
12,817 views|10,356 comparisons
Micro Focus Logo
9,030 views|7,035 comparisons
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Teradata and Vertica 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 Teradata vs. Vertica report (Updated: August 2022).
633,952 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
"It's very, very fast""I've never had any issues with scalability.""Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again.""The functionality of the solution is excellent.""Teradata's most valuable feature is that it's easy to use.""It's a pre-configured appliance that requires very little in terms of setting-up.""I like this solution's ease of design and the fact that its performance is quite good. It is stable as well.""The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."

More Teradata Pros →

"The most valuable feature is Vertica's performance and the ease of using the database.""The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good.""The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale.""It has improved my organization's functionality and performance.""Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data.""The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money.""Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation.""I have found the solution to be scalable."

More Vertica Pros →

Cons
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle.""I'm not sure about the unstructured data management capabilities. It could be improved.""Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency.""Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives.""Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good.""The setup is not straightforward.""I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement.""Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."

More Teradata Cons →

"The integration of this solution with ODI could be improved.""It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale.""We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well.""Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down.""We faced some challenges when trying to use the temporary tables feature.""Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be.""Support is an area where it could get better.""They could improve the integration and some of the features in the cloud version."

More Vertica Cons →

Pricing and Cost Advice
  • "The solution requires a license."
  • "The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
  • "The price of the solution could be reduced, it is expensive."
  • "Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
  • "The cost of running Teradata is quite high, but you get a good return on investment."
  • "Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
  • "The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
  • "The price of Teradata could be less expensive."
  • More Teradata Pricing and Cost Advice →

  • "It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
  • "The price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
  • "The pricing for this solution is very reasonable compared to other vendors."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    633,952 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Any value this product provides is offset by the high cost and lack of scalability. We're moving to Snowflake because of the scalability and cost differentials. There are better, more flexible… more »
    Top Answer:Our use case is for data warehousing and BI reporting. We are customers of Teradata.
    Top Answer:The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good.
    Top Answer:The pricing for this solution is very reasonable compared to other vendors.
    Top Answer:We faced some challenges when trying to use the temporary tables feature. First, we installed Vertica on the AWS cloud and tried to read the data from Bitbucket to Vertica. We were able to read the… more »
    Ranking
    3rd
    out of 30 in Data Warehouse
    Views
    12,817
    Comparisons
    10,356
    Reviews
    14
    Average Words per Review
    481
    Rating
    8.2
    4th
    out of 30 in Data Warehouse
    Views
    9,030
    Comparisons
    7,035
    Reviews
    10
    Average Words per Review
    496
    Rating
    8.8
    Comparisons
    Also Known As
    Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
    Learn More
    Overview

    Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

    Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

    To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

    Offer
    Learn more about Teradata
    Learn more about Vertica
    Sample Customers
    Netflix
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Comms Service Provider27%
    Computer Software Company20%
    Financial Services Firm13%
    Energy/Utilities Company13%
    VISITORS READING REVIEWS
    Financial Services Firm19%
    Computer Software Company18%
    Comms Service Provider11%
    Energy/Utilities Company6%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company21%
    Comms Service Provider16%
    Financial Services Firm12%
    Manufacturing Company7%
    Company Size
    REVIEWERS
    Small Business35%
    Midsize Enterprise10%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise10%
    Large Enterprise77%
    REVIEWERS
    Small Business32%
    Midsize Enterprise26%
    Large Enterprise42%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise14%
    Large Enterprise70%
    Buyer's Guide
    Teradata vs. Vertica
    August 2022
    Find out what your peers are saying about Teradata vs. Vertica and other solutions. Updated: August 2022.
    633,952 professionals have used our research since 2012.

    Teradata is ranked 3rd in Data Warehouse with 16 reviews while Vertica is ranked 4th in Data Warehouse with 11 reviews. Teradata is rated 8.2, while Vertica is rated 8.8. The top reviewer of Teradata writes "Very fast with good database control and excellent support". On the other hand, the top reviewer of Vertica writes "Enhanced capabilities, good customer service, large data scalability and stable". Teradata is most compared with Snowflake, Oracle Exadata, SQL Server, Microsoft Azure Synapse Analytics and MySQL, whereas Vertica is most compared with Snowflake, Amazon Redshift, Oracle Exadata, SQL Server and Microsoft Azure Synapse Analytics. See our Teradata vs. Vertica 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.