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."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."
"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."
"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."
"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 most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"Overall deployment and integration is pretty fast."
"We've had a good experience with technical support in general."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"I like how Microsoft Azure Synapse Analytics integrates with other Microsoft solutions."
"The most valuable feature is the incremental load because we do not need to refresh the entire data on a daily basis."
"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."
"Concurrency limit needs to be increased somewhat."
"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."
"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."
"Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server."
"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 only issue is that it's not expandable."
"The performance needs to improve in future releases."
"The initial setup process needs improvement. When you're moving to the cloud it takes a bit of time. It would be great if they could implement something that would make it faster."
"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."
"It could be more stable."
"Microsoft Azure Synapse Analytics can improve by increasing the size of the files that we can load on the platform. We have some files that are too large to be loaded and it would be a benefit to us if the limit was increased. Additionally, the way we use the tool for generating reports can be made better. They should add some drag-and-drop rules without the need of programming these rules using some programming language. It would be helpful if we did not need someone that was technically advanced to be able to do it with, such as someone with no IT background. Having a reporting tool without code would be great."
"One area that could be improved is the schema management."
"They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated."
"Microsoft Azure Synapse Analytics's overall integration within the Azure ecosystem could improve. The native Microsoft solution versus another solution, such as Databricks, there are areas where there could be some improvements."
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 85 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, 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.