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
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
Aug 16, 2023
A cost-effective data warehousing tool, but security features like TDE encryption are missing
IBM Netezza Performance Server is a basic data warehousing tool we use for internal reporting IBM Netezza Performance Server is a cost-effective solution. Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server. I have been working with IBM Netezza…
T Venkatesh - PeerSpot reviewer
Aug 15, 2024
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 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 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 most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"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 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."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"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 extensibility and efficiency provided by their C++ SDK."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
"I enjoy the cybersecurity and backup features."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"The most valuable feature of Vertica is the unmatchable database performance."
 

Cons

"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"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."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"The only issue is that it's not expandable."
"The scalability is not as expected. The capacity in the black box is not enough."
"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."
"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."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"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."
"I believe the installation process could be streamlined."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"Documentation has become much better, but can always use some improvement."
"They could improve on customer service."
 

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."
"The solution is free and we pay for the storage."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"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 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 solution is relatively cost-effective."
"The pricing for this solution is very reasonable compared to other vendors."
"Vertica is an expensive tool."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
814,649 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: October 2024.
814,649 professionals have used our research since 2012.