Microsoft Parallel Data Warehouse and IBM Netezza Performance Server are competing data warehousing solutions. IBM Netezza Performance Server is considered superior due to its advanced features and robust performance, which justifies its higher price.
Features: Microsoft Parallel Data Warehouse is known for its powerful data integration, rapid data loading, and ease of use within the SQL Server ecosystem. It supports scalable MPP processing and integrates seamlessly with Power BI. IBM Netezza Performance Server is distinguished by its extreme query speed, easy deployment, and built-in redundancy, alongside efficient SQL execution and advanced analytics capabilities.
Room for Improvement: Microsoft requires enhanced real-time data analysis and improved error messaging, along with better data protection features. Its cost structure and scalability can be improved. IBM Netezza should focus on enhancing cloud compatibility, optimizing query performance tuning, and reassessing its expensive pricing model while also improving concurrent query handling.
Ease of Deployment and Customer Service: Microsoft supports both on-premises and public cloud deployments, providing versatile options. Its customer service offers satisfactory direct support. IBM Netezza is primarily focused on on-premises and hybrid cloud solutions, with a stable reputation but needs better cloud integration support.
Pricing and ROI: Microsoft offers competitive pricing, especially for existing infrastructures or governmental agreements, although still perceived as costly. Its ROI is viewed positively due to integration with Microsoft tools. IBM Netezza, despite its high cost, provides significant ROI for handling large data sets through its robust performance, justifying its premium pricing for its advantages in performance and capabilities.
Technical support is very costly for me, accounting for twenty-five to thirty percent of the product cost.
I would rate my experience with technical support around six on a scale of 1 to 10 because I have not had a particular experience with technical support.
It is provided as a pre-configured box, and scaling is not an option.
I give the scalability an eight out of ten, indicating it scales well for our needs.
As a consultant, we hire additional programmers when we need to scale up certain major projects.
Microsoft Parallel Data Warehouse is stable for us because it is built on SQL Server.
The cloud version is only available in AWS, and in the Middle East, it is not well-developed in the Azure environment.
Addressing the cost would be the number one area for improvement.
It would be better to release patches less frequently, maybe once a month or once every two months.
The ETL designing process could be optimized for better efficiency.
Microsoft Parallel Data Warehouse is very expensive.
It operates as a high-speed data warehouse, which is essential for handling big data.
The columnstore index enhances data query performance by using less space and achieving faster performance than general indexing.
The biggest advantage of Microsoft Parallel Data Warehouse is the possibility to stop or pause the service because it can be very expensive.
There's a feature that allows users to set alerts on triggers within reports, enabling timely actions on pending applications and effectively reducing waiting time.
| Product | Market Share (%) |
|---|---|
| Microsoft Parallel Data Warehouse | 1.7% |
| IBM Netezza Performance Server | 4.2% |
| Other | 94.1% |
| Company Size | Count |
|---|---|
| Small Business | 9 |
| Midsize Enterprise | 5 |
| Large Enterprise | 33 |
| Company Size | Count |
|---|---|
| Small Business | 16 |
| Midsize Enterprise | 6 |
| Large Enterprise | 21 |
IBM Netezza Performance Server offers high performance, scalability, and minimal maintenance. It seamlessly integrates SQL for efficient data processing, making it ideal for enterprise data warehousing needs.
IBM Netezza Performance Server is known for its outstanding data processing capabilities. Its integration of FPGA technology, compression techniques, and partitioning optimizes query execution and scalability. Users appreciate its appliance-like architecture for straightforward deployment, distributed querying, and high availability, significantly boosting operations and analytics capabilities. However, there are areas for improvement, particularly in handling high concurrency, real-time integration, and specific big data functionalities. Enhancements in database management tools, XML integration, and cloud options are commonly desired, along with better marketing and community engagement.
What are the key features of IBM Netezza Performance Server?Industries rely on IBM Netezza Performance Server for robust data warehousing solutions, particularly in sectors requiring intensive data analysis such as finance, retail, and telecommunications. Organizations use it to power business intelligence tools like Business Objects and MicroStrategy for customer analytics, establishing data marts and staging tables to efficiently manage and update enterprise data. With the capacity to handle large volumes of compressed and uncompressed data, it finds numerous applications in on-premises setups, powering data mining and reporting with high reliability and efficiency.
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.
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.
