We performed a comparison between IBM Netezza Performance Server, Teradata, and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse."Distribution concurrency control."
"The performance is most important to me, and it helps our ability to make business decisions quickly."
"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."
"IBM Netezza Performance Server is a cost-effective solution."
"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 most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"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 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 initial setup was straightforward."
"Cuts time to process huge amounts of data with efficient analytical queries."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"I enjoy the cybersecurity and backup features."
"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."
"The performance is very good and the aggregate records are fast."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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 enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"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."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"The scalability is not as expected. The capacity in the black box is not enough."
"The only issue is that it's not expandable."
"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."
"LIke Teradata, we can’t add a node/SPU to the existing appliance."
"Concurrency limit needs to be increased somewhat."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"The setup is not straightforward."
"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)."
"The cloud is the new challenge and the new opportunity."
"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."
"Limited interest and success in some areas make us hesitate about upgrading."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Limitations in group by projections is where I would like to see an improvement."
"They could improve on customer service."
"It needs integration with multiple clouds."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Very bad support, I would rate it two out of 10."
"Whatever's out, the core is not always as great as the engine, especially their first version."
More IBM Netezza Performance Server Pricing and Cost Advice →