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 Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The performance is most important to me, and it helps our ability to make business decisions quickly."
"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."
"IBM Netezza Performance Server is a cost-effective solution."
"The most valuable feature would be the fact that it has been running for awhile in an appliance format."
"Distribution concurrency control."
"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 feature is performance gains."
"The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"The useability, the user interface, is very user-friendly."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"Overall deployment and integration is pretty fast."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"The initial setup is very simple."
"The only issue is that it's not expandable."
"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 scalability is not as expected. The capacity in the black box is not enough."
"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."
"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."
"IBM Netezza Performance Server could improve its interface, support for big data, and APA-based connectivity should be available."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"The need to improve a little bit in terms of user-friendliness."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"More integration is needed to improve the product for the future."
"The filing can be improved."
"There may be some challenges in terms of connecting with Virtual Networks (VNETs) to Microsoft Azure Synapse Analytics."
"Non-structured data is unavailable with this product."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
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, Snowflake, Teradata and Vertica, whereas Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake and Oracle Autonomous Data Warehouse. See our IBM Netezza Performance Server vs. Microsoft Azure Synapse Analytics report.
See our list of best Cloud Data Warehouse vendors and best Data Warehouse vendors.
We monitor all Cloud 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.