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."IBM Netezza Performance Server is a cost-effective solution."
"Distribution concurrency control."
"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 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 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 performance is most important to me, and it helps our ability to make business decisions quickly."
"The most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"They are available on the Cloud, and the platform is very intuitive."
"The stability is pretty good."
"Synapse Analytics' best feature is its ability to process large files."
"The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage."
"The most valuable features of Microsoft Azure Synapse Analytics are its serverless flexibility and complete power have allowed me to explore various different use cases. While I am not an expert in the product, my experience in programming in Databricks has shown me that Microsoft's investments in Synapse could potentially lead to it becoming a complete replacement for Databricks in the future."
"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."
"One central workspace to manage everything for your data warehouse including visualization."
"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."
"The scalability is not as expected. The capacity in the black box is not enough."
"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."
"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."
"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."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"Documentation could be improved."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"The security performance and cost are the two things that needs improvement."
"The product could be more feature-rich."
"It needs strong support for social media, internet data, and native support for NoSQL."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
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.