SAP IQ and IBM Netezza Performance Server are contenders in high-performing data warehousing solutions. While SAP IQ shines with query speeds and data compression, IBM Netezza stands out for parallel processing, requiring less administrative effort.
Features: SAP IQ is recognized for its columnar storage, enhancing data compression and enabling rapid queries in BI contexts. It features patented indices and integrates well with SAP BusinessObjects. IBM Netezza offers swift parallel processing, supports large datasets effortlessly, and simplifies management with its appliance design. Its integration with distributed computing platforms and automated table compression further simplify operations.
Room for Improvement: SAP IQ could improve in recovery capabilities, user error messaging, and pricing structure, needing better integration and advertisement. IBM Netezza should enhance scalability, concurrency support, and big data integration. Its non-expandable nature and limited cloud capabilities also present challenges.
Ease of Deployment and Customer Service: Both solutions focus on on-premises deployment, with IBM Netezza also supporting hybrid cloud setups for flexibility. SAP IQ faces criticism for reduced technical support access, impacting assistance timeliness. Conversely, IBM Netezza gains praise for 24/7 technical support, indicating a more proactive customer service approach.
Pricing and ROI: SAP IQ is competitively priced for various organization sizes, though some add-ons increase costs. IBM Netezza, despite its higher cost, justifies its appliance nature with simplicity and performance, seen as worthwhile for large-scale data needs.
Technical support is very costly for me, accounting for twenty-five to thirty percent of the product cost.
It seems very difficult to get proper advanced assistance on advanced or complicated problems.
The quality of support from SAP is very good; if it's a known problem, they will have a knowledge base, so we will get immediate assistance.
It is provided as a pre-configured box, and scaling is not an option.
We can span the read and write load into multiple nodes, and that scalability is there.
If we wanted to add more servers into this entire setup, that would be fairly easy, so it's rather good when it comes to scalability.
It's usually something external, such as lack of disk space or problems arising from the integration to other systems.
The cloud version is only available in AWS, and in the Middle East, it is not well-developed in the Azure environment.
If the CPU utilization is very high, there is no direct way we can find out which query is taking the most CPU.
When there is an issue, the error messaging we get is not always sufficient to do a fast and solid fix.
It operates as a high-speed data warehouse, which is essential for handling big data.
We can get historical data quickly, and you can fetch information very quickly because every column is indexed.
The most valuable feature of SAP IQ for us is that it works very effectively with the SAP BusinessObjects which we use it with.
| Product | Mindshare (%) |
|---|---|
| IBM Netezza Performance Server | 4.4% |
| SAP IQ | 2.9% |
| Other | 92.7% |
| Company Size | Count |
|---|---|
| Small Business | 9 |
| Midsize Enterprise | 5 |
| Large Enterprise | 33 |
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 2 |
| Large Enterprise | 16 |
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.
SAP® IQ software delivers speed and power for extreme-scale enterprise data warehousing and analytics. Its column-oriented, grid-based massively parallel processing (MPP) architecture and patented data compression and indexing technologies enable companies to exploit the value of huge amounts of data at the speed of business.
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.
