Try our new research platform with insights from 80,000+ expert users

IBM Netezza Performance Server vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Netezza Performance Server
Ranking in Data Warehouse
12th
Average Rating
8.0
Number of Reviews
33
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Data Warehouse
4th
Average Rating
8.2
Reviews Sentiment
7.6
Number of Reviews
86
Ranking in other categories
Cloud Data Warehouse (7th)
 

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of IBM Netezza Performance Server is 4.0%, up from 4.0% compared to the previous year. The mindshare of Vertica is 9.3%, up from 9.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Shemal Gandhi - PeerSpot reviewer
A cost-effective data warehousing tool, but security features like TDE encryption are missing
The solution's maintenance is quite easy. One person is enough to maintain the solution. If you are using PostgreSQL as a database solution, then using IBM Netezza Performance Server is the logical choice since it is based on open-source Postgres. However, if you are using Oracle, data conversion can be tricky. So, in that case, you want to go ahead with Exadata. Overall, I rate IBM Netezza Performance Server a seven out of ten.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The benefit is really because of the additional speed that we have and, truth be told, the more updated ETL processes and the revamped scheduler in general."
"The data governance prospect... from what I've seen, that is a really powerful tool as well, to help with data lineage and keeping track of that."
"The underlying hardware that IBM provides with this appliance is made for a specific purpose, to serve performance on a large amount of data, and to do analytics as well. It is faster, when you compare it to any other product."
"We are able to execute very complex queries. Over 90 percent of our query executions are one second or less. We do millions of queries everyday."
"IBM Netezza Performance Server is a cost-effective solution."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"Distribution concurrency control."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"I like the projection feature, which increases query performance."
"I have found the solution to be scalable."
"The extensibility and efficiency provided by their C++ SDK."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Partition and join back to node are easy and simple for DBAs."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
 

Cons

"Concurrency limit needs to be increased somewhat."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"The only issue is that it's not expandable."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"Our main problem with it is concurrency. When there are too many users running Netezza at the same time, this is when we have the most complaints."
"We are not able to scale. The only way to scale is to get another appliance, but we have a customers who would need us to hydrate the data between the two appliances, and Netezza does not do that."
"In terms of features that I would like to see, one is the ability to actually scale out an architecture. Right now, if you buy one, it's fixed. There is no scale-up availability at all."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"It needs integration with multiple clouds."
"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."
"The geospatial functionality could be designed better."
"They could improve on customer service."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Fact-to-fact joins on multi-billion record tables perform poorly."
 

Pricing and Cost Advice

"The pricing is very expensive. It has a lot CPUs with a lot of components in it. It also has built-in redundancy for resiliency reasons."
"Netezza is a costly solution. It does serve a specific purpose but it's costlier than what's available in the market, if you go to the cloud."
"The solution has a yearly licensing fee, and users have to pay extra for support."
"It's an expensive product"
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The solution is free and we pay for the storage."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"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 price could be cheaper and it is best to negotiate the price."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"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."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Comparison Review

it_user232068 - PeerSpot reviewer
Aug 5, 2015
Netezza vs. Teradata
Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…
 

Top Industries

By visitors reading reviews
Educational Organization
73%
Financial Services Firm
7%
Computer Software Company
3%
Insurance Company
2%
Computer Software Company
18%
Financial Services Firm
18%
Manufacturing Company
8%
University
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about IBM Netezza Performance Server?
IBM Netezza Performance Server is a cost-effective solution.
What is your experience regarding pricing and costs for IBM Netezza Performance Server?
The solution has a yearly licensing fee, and users have to pay extra for support.
What needs improvement with IBM Netezza Performance Server?
Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Also Known As

Netezza Performance Server, Netezza
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Learn More

 

Overview

 

Sample Customers

Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about IBM Netezza Performance Server vs. Vertica and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.