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."We've had good experiences with technical support."
"It's very convenient and very innovative."
"The most valuable feature of SAP HANA is its performance and integration."
"The best feature of SAP HANA is column computing. The computing speed of the solution is also very high, so developers can easily develop programs through SAP HANA."
"The feature that I like the most is that we can transport the data to our web data application. SAP HANA's performance is really perfect. We're working on big data, and SAP HANA is really working on high performance. We are happy working with it."
"We like that the product is both vertically and horizontally scalable, allowing us to do around 86 percent compression of documentation from 50 to seven terabytes."
"The UX experience is very good."
"The most valuable feature of SAP HANA is the modeling of the databases."
"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."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"Columnar storage allows high compression, high load rates and high query performance."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The documentation can be improved in the future."
"The product is very demanding on memory requirements."
"Needs graphical programming without coding."
"The pricing could be better."
"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 SAP HANA interface has room for improvement because it takes more work to manage than the Microsoft SQL Server interface."
"In my limited experience using SAP, the process of granting access to different modules is difficult. Specifically, the requirement to assign roles and key codes to users rather than being able to assign them individually made the process more complex. It would be beneficial if there was a way to assign key codes separately, rather than having to create multiple roles. This would make managing access easier."
"The initial setup was very, very complex, tedious, and costly and required someone with great expertise to complete it."
"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."
"Concurrency and functional error messaging."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"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."
SAP HANA is ranked 3rd in Relational Databases Tools with 79 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, 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.