IBM Netezza Performance Server vs Snowflake comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

IBM Netezza Performance Server
Ranking in Data Warehouse
10th
Average Rating
8.0
Number of Reviews
33
Ranking in other categories
No ranking in other categories
Snowflake
Ranking in Data Warehouse
1st
Average Rating
8.4
Number of Reviews
95
Ranking in other categories
Cloud Data Warehouse (1st)
 

Mindshare comparison

As of July 2024, in the Data Warehouse category, the mindshare of IBM Netezza Performance Server is 4.9%, up from 4.1% compared to the previous year. The mindshare of Snowflake is 15.2%, down from 18.8% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
Unique Categories:
No other categories found
Cloud Data Warehouse
30.4%
 

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…
Rahul Saxena - PeerSpot reviewer
Jan 23, 2024
The product is fast and easy to use, but it is expensive compared to other products in the market
People who want to buy the product must initially use the free trial version. It can be installed on a desktop. The user can do a lot of R&D. We have a good playground. We can play with the components and learn them easily. We can learn how each component talks to each other, how the performance is, and how to create tables. There are a ton of tasks we can do. After ingesting the data, we can perform advanced analytics and make models. The end users can do many things on the tool. It is quite an easy tool. I will advise any new user to install a free version. They will be able to learn about the product and get good insights when they work on their pilot project. Overall, I rate the tool a seven out of ten.

Quotes from Members

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

Pros

"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."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"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 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."
"IBM Netezza Performance Server is a cost-effective solution."
"The pricing is reasonable and matches the rest of the market."
"It requires no maintenance on our part. They handle all that. The speed is phenomenal. The pricing isn't really anything more than what you would be paying for a SQL server license or another tool to execute the same thing. We have zero maintenance on our side to do anything and the speed at which it performs queries and loads the data is amazing. It handles unstructured data extremely well, too. So, if the data is in a JSON array or an XML, it handles that super well."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"The most valuable features are sharing data, Time Travel, Zero Copy Cloning, performance, and speed."
"It was relatively easy to use, and it was easy for people to convert to it."
"The speed of data loading and being able to quickly create the environment are most valuable."
"Great scalability and near zero maintenance."
 

Cons

"The only issue is that it's not expandable."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"The scalability is not as expected. The capacity in the black box is not enough."
"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."
"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."
"Concurrency limit needs to be increased somewhat."
"In future releases, it can also support full unstructured data."
"We would like to have an on-premises deployment option that has the same features, including scalability."
"Snowflake has support for stored procedures, but it is not that powerful."
"The data sharing capabilities across business units within the organization should be better."
"They don't have any SLAs in place. It would be better if they did."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"More data governance and access control features would be a welcome addition."
 

Pricing and Cost Advice

"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 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."
"The solution has a yearly licensing fee, and users have to pay extra for support."
"There is a license needed to use this solution. There are a few licensing options available. They have a pay-as-you-go option, but it is recommended to pay upfront."
"Snowflake is cost-effective."
"It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee. We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data."
"Snowflake is cost-effective. However, the cost can depend on how it's being used and how efficiently the code is written. If engineers don't write efficient code and usage is billed based on processing, it can become costly. If they write optimal code and choose the best solution, it can reduce costs in comparison to other options, such as Oracle."
"Users have to pay a licensing fee for the solution, which is expensive."
"Snowflake licensing is more flexible and it is cheaper than other solutions. I can use it for only 10 days for MVP, or three years, and for flexible models. I can scale up, or down, and the pricing is based on the volume and duration. There are many licensing permutation combinations available."
"On average, with the number of queries that we run, we pay approximately $200 USD per month."
"The price of Snowflake is quite reasonable."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
792,694 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
69%
Financial Services Firm
8%
Computer Software Company
4%
Insurance Company
3%
Educational Organization
29%
Financial Services Firm
13%
Computer Software Company
10%
Manufacturing Company
6%
 

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 Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
The product's price range falls between average to a bit expensive range. I think the tool is worth the money if you use it properly. It is difficult for me to speak about the number of users who u...
What needs improvement with Snowflake?
I don't think that the AI tools in Snowflake are good. AI tools in Snowflake can be improved. Even if the AI tools in Snowflake are good, I feel that it would be expensive. The cost of the AI part ...
 

Also Known As

Netezza Performance Server, Netezza
Snowflake Computing
 

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
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about IBM Netezza Performance Server vs. Snowflake and other solutions. Updated: July 2024.
792,694 professionals have used our research since 2012.