We performed a comparison between SAP HANA and SAP IQ based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Provides us with predictive capabilities for asset maintenance, and real-time forecasts."
"All features are valuable."
"We can save data very easily."
"It's user-friendly so long as you use it frequently."
"The in-memory computing and the efficient response time are very good features."
"It's stable and reliable."
"What's most valuable in SAP HANA is that it covers the business process systems of my company. The solution also helps because it makes almost everything automated. Another valuable feature of SAP HANA is that it can be integrated with third parties and other enhancements needed by the company."
"The solution is easy to scale."
"The initial setup is easy."
"The product is easy to learn."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"Columnar storage allows high compression, high load rates and high query performance."
"The primary benefit of SAP IQ is its ability to limit the expansion of the costly SAP HANA database, which has limited storage capacity. This necessitates a form of data management that involves moving data from SAP HANA to SAP NLS, which is essentially archiving. This allows us to retain access to the data via a link whenever it is required."
"Unbeatable speed and compression with a colummn-structured relational database."
"The performance and integration with other products are areas in need of improvement."
"You cannot apply mulit-join inside the calculation views, for example, when you are joining tables."
"There's an issue in the partition. When you record more than two million records, partitioning does not work well. In Oracle it's easy. SAP must resolve this issue in order to be more competitive with Oracle."
"What needs improvement in SAP HANA is its automation, in particular, it needs more enhancements in that area."
"The relationship with a partner that sells SAP could be better. We depend much more on our own development, and the partner is for selling us the solutions, so we need them to be able to supply help and answers. The partner isn't very helpful, and we have to rely on our own knowledge and research."
"It would be nice to know when SAP plans to stop its maintenance of a previous version of SAP ECC ERP because, at this point, anyone utilizing SAP will have no choice but to go on S/4HANA Database."
"SAP HANA is not strong like Oracle when it comes to finance. They are only strong with the logistic business project."
"The solution needs to work on its performance and make it faster."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"The tool gets stuck sometimes."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"There is very little documentation available."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"I think the universe should be part of the Sybase IQ tool set."
"Multiplex is very problematic. There are consistency problems in the metadata, meaning it is possible to lose metadata consistency. You should make sure you have healthy backups."
SAP HANA is ranked 3rd in Relational Databases Tools with 81 reviews while SAP IQ is ranked 21st in Relational Databases Tools with 19 reviews. SAP HANA is rated 8.4, while SAP IQ is rated 7.8. The top reviewer of SAP HANA writes "Excellent compatibility between modules and the control". On the other hand, the top reviewer of SAP IQ writes "Easy to use, highly stable, but integration could improve". SAP HANA is most compared with Oracle Database, SQL Server, MySQL, IBM Db2 Database and MariaDB, whereas SAP IQ is most compared with Snowflake, SQL Server, SAP BW4HANA, Apache Hadoop and SAP Adaptive Server Enterprise. See our SAP HANA vs. SAP IQ report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.