We performed a comparison between IBM Netezza Performance Server, Teradata, and VMware Tanzu Greenplum based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."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 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."
"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."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"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."
"IBM Netezza Performance Server is a cost-effective solution."
"Distribution concurrency control."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"It is a stable program."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"The performance is great, we are able to query our data in one operation."
"I've never had any issues with scalability."
"The key advantages are Performance when processing Terabytes of data and scalability."
"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."
"Very fast for query processing."
"Tanzu Greenplum's most valuable features include the integration of modern data science approaches across an MPP platform."
"Scalability is simple because it's an MPP database. If you need more processing power or you need more storage, you just add a few more nodes in the cluster. It works on common commodity hardware. You can use any type of server. You don't need to have proprietary hardware. It's fairly flexible."
"With VMware Tanzu Greenplum, one can make a huge database table and analyze the queries by adding in the SQL command. Some hint or command for the query goes over the multi-parallel execution."
"It works very well with large database queries."
"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."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"Concurrency limit needs to be increased somewhat."
"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."
"The scalability is not as expected. The capacity in the black box is not enough."
"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."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"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."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"It could use some more advanced analytics relating to structured and semi-structured data."
"The setup is not straightforward."
"Teradata is a bit late for the cloud."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Lacks sufficient inbuilt machine-learning functions for complex use cases."
"We would like to see Greenplum maintain a closer relationship with and parity to features implemented in PostgreSQL."
"I saw some limitation with respect to the column store, and removing this would be an improvement."
"If you have a user consuming a huge load of resources, it takes down the entire system."
"Maintenance is time-consuming."
"Extra filters would be helpful."
"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."
"they need to interact more with customers. They need to explain the features, especially when there are new releases of Greenplum. I know just from information I've found that it has other features, it can be used to for analytics, for integration with Big Data, Hadoop. They need to focus on this part with the customer."
More IBM Netezza Performance Server Pricing and Cost Advice →