We performed a comparison between IBM Netezza Performance Server and Microsoft Azure Synapse Analytics based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Distribution concurrency control."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"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."
"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."
"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 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 of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"It's feature-rich. It has a wide range of features."
"Synapse Analytics gives you information and reports in real-time."
"It is a highly stable solution and it's easy to use."
"The product is easy to use, and anybody can easily migrate to advanced DB."
"The best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it."
"The most valuable feature is performance gains."
"They are very reliable and cost-effective."
"Concurrency limit needs to be increased somewhat."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"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."
"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."
"The only issue is that it's not expandable."
"The scalability is not as expected. The capacity in the black box is not enough."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"While the solution is flexible, sometimes this works against the user."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"It needs strong support for social media, internet data, and native support for NoSQL."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"We'd like the solution to have more analytics capability."
More IBM Netezza Performance Server Pricing and Cost Advice →
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews. IBM Netezza Performance Server is rated 8.0, while Microsoft Azure Synapse Analytics is rated 7.8. The top reviewer of IBM Netezza Performance Server writes "A cost-effective data warehousing tool, but security features like TDE encryption are missing". On the other hand, the top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Teradata, Snowflake and VMware Tanzu Data Services, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata. See our IBM Netezza Performance Server vs. Microsoft Azure Synapse Analytics report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.