IBM Netezza Performance Server vs Microsoft Parallel Data Warehouse comparison

Cancel
You must select at least 2 products to compare!
Comparison Buyer's Guide
Executive Summary

We performed a comparison between IBM Netezza Performance Server and Microsoft Parallel Data Warehouse 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.
To learn more, read our detailed IBM Netezza Performance Server vs. Microsoft Parallel Data Warehouse Report (Updated: May 2024).
771,740 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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.""Distribution concurrency control.""The most valuable feature would be the fact that it has been running for awhile in an appliance format.""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.""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 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 most valuable features of the IBM Netezza Performance Server are the NPS server because of the reduced maintenance and overall good performance."

More IBM Netezza Performance Server Pros →

"One of the most important features is the ease of using MS SQL.""We have complete control over our data.""We can store the data in a data lake for a very low cost.""The most valuable feature of this solution is performance.""The solution's integration is good.""It is a stable solution...It is a scalable solution.""It is a very stable database.""The UI is very simple and functional for my clients, most of the clients that use the solution are not experts."

More Microsoft Parallel Data Warehouse Pros →

Cons
"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.""Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.""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.""LIke Teradata, we can’t add a node/SPU to the existing appliance.""Concurrency limit needs to be increased somewhat.""The only issue is that it's not expandable.""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."

More IBM Netezza Performance Server Cons →

"I think that the error messages need to be made more specific.""I would like to see better visualization features.""SQL installation is pretty tricky. The scalability and customer support also should be improved.""​Concurrent queries are limited to 32, making it more of a data storage mechanism instead of an active DWH solution.""The query is slow if we don't optimize it.""It needs more compatibility with common BI tools.""Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.""This solution would be improved with an option for in-memory data analysis."

More Microsoft Parallel Data Warehouse Cons →

Pricing and Cost Advice
  • "Netezza is a costly solution. It does serve a specific purpose but it's costlier than what's available in the market, if you go to the cloud."
  • "The pricing is very expensive. It has a lot CPUs with a lot of components in it. It also has built-in redundancy for resiliency reasons."
  • "The solution has a yearly licensing fee, and users have to pay extra for support."
  • More IBM Netezza Performance Server Pricing and Cost Advice →

  • "I think the program is well-priced compared to the other offerings that are out in the market."
  • "Microsoft has an agreement with the government in our country, so our customers get their licensing costs from the Ministry. Whenever we work with any government, company, or government institute, which is mainly what we are doing, that license comes directly from the Ministry of Technology and Information."
  • "All the features that we use do not require any additional subscription or yearly fees."
  • "Technical support is an additional fee and is expensive."
  • "The solution's pricing is fairly decent for organizations with huge data sizes."
  • "The tool could be expensive if we need to manage a lot of data."
  • "They offer an annual subscription. The pricing depends on the size of the environments."
  • More Microsoft Parallel Data Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    771,740 professionals have used our research since 2012.
    Comparison Review
    Anonymous User
    Questions from the Community
    Top Answer:IBM Netezza Performance Server is a cost-effective solution.
    Top Answer:The solution has a yearly licensing fee, and users have to pay extra for support.
    Top Answer:Oracle Exadata's security features, like TDE encryption, are missing in IBM Netezza Performance Server.
    Top Answer:Microsoft Parallel Data Warehouse provides good firewall processing in terms of response time.
    Top Answer:They offer an annual subscription. The pricing depends on the size of the environments.
    Top Answer:Sometimes, the product requires rolling back to its previous version during a software update. This particular area could be enhanced.
    Ranking
    10th
    out of 35 in Data Warehouse
    Views
    2,543
    Comparisons
    1,441
    Reviews
    2
    Average Words per Review
    334
    Rating
    7.0
    9th
    out of 35 in Data Warehouse
    Views
    564
    Comparisons
    446
    Reviews
    12
    Average Words per Review
    379
    Rating
    8.0
    Comparisons
    Also Known As
    Netezza Performance Server, Netezza
    Microsoft PDW, SQL Server Data Warehouse, Microsoft SQL Server Parallel Data Warehouse, MS Parallel Data Warehouse
    Learn More
    Overview
    IBM Netezza appliances are now part of IBM PureSystems - expert integrated systems with built in expertise, integration by design and a simplified user experience. Part of the PureData family, the Netezza appliance is now known as the PureData System for Analytics. It has the same key design tenets of simplicity, speed, scalability and analytics power that was fundamental to Netezza appliances.

    The traditional structured relational data warehouse was never designed to handle the volume of exponential data growth, the variety of semi-structured and unstructured data types, or the velocity of real time data processing. Microsoft's SQL Server data warehouse solution integrates your traditional data warehouse with non-relational data and it can handle data of all sizes and types, with real-time performance.

    Sample Customers
    Seattle Childrens Hospital, Carphone Warehouse, Vanderbilt University School of Medicine, Battelle, Start Today Co. Ltd., Kelley Blue Book, Trident Marketing, Elisa Corporation, Catalina Marketing, iBasis, Barnes & Noble, Qualcomm, MediaMath, Acxiom, iBasis, Foxwoods
    Auckland Transport, Erste Bank Group, Urban Software Institute, NJVC, Sheraton Hotels and Resorts, Tata Steel Europe
    Top Industries
    REVIEWERS
    Financial Services Firm37%
    Retailer16%
    Comms Service Provider11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Educational Organization66%
    Financial Services Firm8%
    Computer Software Company5%
    Insurance Company3%
    REVIEWERS
    Computer Software Company18%
    Healthcare Company18%
    Pharma/Biotech Company12%
    Hospitality Company12%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Financial Services Firm17%
    Insurance Company7%
    University6%
    Company Size
    REVIEWERS
    Small Business18%
    Midsize Enterprise9%
    Large Enterprise74%
    VISITORS READING REVIEWS
    Small Business5%
    Midsize Enterprise70%
    Large Enterprise25%
    REVIEWERS
    Small Business36%
    Midsize Enterprise14%
    Large Enterprise50%
    VISITORS READING REVIEWS
    Small Business21%
    Midsize Enterprise18%
    Large Enterprise61%
    Buyer's Guide
    IBM Netezza Performance Server vs. Microsoft Parallel Data Warehouse
    May 2024
    Find out what your peers are saying about IBM Netezza Performance Server vs. Microsoft Parallel Data Warehouse and other solutions. Updated: May 2024.
    771,740 professionals have used our research since 2012.

    IBM Netezza Performance Server is ranked 10th in Data Warehouse with 33 reviews while Microsoft Parallel Data Warehouse is ranked 9th in Data Warehouse with 32 reviews. IBM Netezza Performance Server is rated 8.0, while Microsoft Parallel Data Warehouse is rated 7.6. 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 Parallel Data Warehouse writes "An easy to setup tool that allows its users to write stored procedure, making it a scalable product". IBM Netezza Performance Server is most compared with Oracle Exadata, Oracle Database, Snowflake, Teradata and SQL Server, whereas Microsoft Parallel Data Warehouse is most compared with Microsoft Azure Synapse Analytics, Oracle Exadata, SAP BW4HANA, Snowflake and VMware Tanzu Data Services. See our IBM Netezza Performance Server vs. Microsoft Parallel Data Warehouse report.

    See our list of best 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.