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."I like the integration process. Also, the data is trusted by our management, and we use the data from transactions for analysis."
"Some functions have good performance."
"When we upgraded, we received more functions or more features."
"It's sufficed all of our requirements. We primarily needed it to run SAP applications, like NetWeaver or S/4HANA, and it has been really good at that."
"The speed at which it gets the data is great."
"The most valuable features are the flexibility and the integration with other solutions in data quality."
"We appreciate that the current, redesigned version of this solution that is much more straightforward for new users, and has been well thought out with industry best practice standards in mind."
"The feature I found most valuable in SAP HANA is modeling. I also like that the solution has good integration and you can integrate it with any system, even third-party systems."
"Columnar storage allows high compression, high load rates and high query performance."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
"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."
"It is challenging to integrate it with third-party tools."
"When we are using SAP HANA we have some difficulty with the customization. We would like to be able to add and make customized menus."
"The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."
"They can improve their technology for the CRM subsystem. There are other products that are better and more effective for the CRM subsystem. Its price could be better. It is expensive."
"When you do a report on a non-SAP platform, you face some compatibility problems."
"I'd just like to see some more improvements done on the training, both on the functional training and technical training sides as a part of the complete solution."
"I would like more technical documentation. I would like it to be easier to find online help or have a better launch-based service. SAP has a lot of functions, so we need more best practices and more detailed documentation on industry solutions. For example, it would be good to have documentation on why a certain process needs to be set up and which kinds of configurations need to be set up."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"Concurrency and functional error messaging."
"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."
"The organization who owns the product does not support it well and appears not to be doing significant development for the future."
"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 17 reviews. SAP HANA is rated 8.4, while SAP IQ is rated 8.0. 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, SAP BW4HANA, SQL Server, 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.