SAP IQ and Apache Hadoop compete in the data management solutions category. SAP IQ has an advantage in query speed and customer support evaluation, while Apache Hadoop is preferred for its scalability and feature set.
Features: SAP IQ offers rapid query speed, high data compression, and a column-oriented database for efficient storage and performance. Apache Hadoop stands out with robust scalability, extensive data processing capabilities, and integration with tools like Apache Spark, suitable for big data environments.
Room for Improvement: SAP IQ faces challenges with marketing, technical support, and limited integration with Hadoop, urging enhancements in documentation and training. Apache Hadoop requires improvements in real-time processing, user-friendliness, and better integration and support structures.
Ease of Deployment and Customer Service: SAP IQ is primarily on-premises and criticized for technical support. Apache Hadoop offers versatile on-premises and cloud deployments, receiving positive feedback for customer support and 24/7 assistance.
Pricing and ROI: SAP IQ is seen as reasonably priced with various licensing models, though additional features might incur costs. Apache Hadoop, being open-source, generally provides cost advantages, but vendor licensing can increase expenses. Hadoop is valued for large-scale applications, while SAP IQ aligns with efficient transaction capabilities.
It's not structured support, which is why we don't use purely open-source projects without additional structured support.
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 a distributed file system and scales reasonably well as long as it is given sufficient resources.
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.
Continuous management in the way of upgrades and technical management is necessary to ensure that it remains effective.
It's usually something external, such as lack of disk space or problems arising from the integration to other systems.
The problem with Apache Hadoop arose when the guys that originally set it up left the firm, and the group that later owned it didn't have enough technical resources to properly maintain it.
It is easy to deploy SAP IQ; the implementation and installation are easy.
When there is an issue, the error messaging we get is not always sufficient to do a fast and solid fix.
I assess Apache Hadoop's fault tolerance during hardware failures positively since we have hardware failover, which works without problems.
Hadoop is a distributed file system, and it scales reasonably well provided you give it sufficient resources.
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 | Market Share (%) |
|---|---|
| Apache Hadoop | 3.8% |
| SAP IQ | 2.5% |
| Other | 93.7% |
| Company Size | Count |
|---|---|
| Small Business | 14 |
| Midsize Enterprise | 8 |
| Large Enterprise | 21 |
| Company Size | Count |
|---|---|
| Small Business | 6 |
| Midsize Enterprise | 2 |
| Large Enterprise | 16 |
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.
