Compare SAP HANA vs. SAP IQ

Cancel
You must select at least 2 products to compare!
SAP HANA Logo
10,619 views|8,672 comparisons
SAP IQ Logo
3,090 views|2,127 comparisons
Most Helpful Review
Find out what your peers are saying about Microsoft, Oracle, IBM and others in Relational Databases. Updated: August 2020.
437,064 professionals have used our research since 2012.
Quotes From Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros
We've had good experiences with technical support.The performance is very, very good. It's one of the best aspects of the solution.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.The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution is quite fast.The user interface is very good. You can do any kind of reporting analytics from the platform.The data storage requirement is reduced from the original database to the HANA database.The functionality is of the solution is very good.One feature I find very valuable, is the response time of the application on the database memory.

More SAP HANA Pros »

Unbeatable speed and compression with a colummn-structured relational database.

More SAP IQ Pros »

Cons
The solution is very expensive for us.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.The user experience should be better. Its user interface is not good. I also don't like the transition concept.Unlike other databases, it lacks management features that legacy databases like Oracle or SQL servers have. They need to make the solution easier to manage and offer tools that make management more effective. A lot of things you have on traditional databases you have to develop into HANA.When you do a report on a non-SAP platform, you face some compatibility problems.I think that the pricing is high and it needs improvement.The challenge right now is all databases are on S4 HANA architecture. You're running it for HANA, but not all the functionalities are available. If they can speed up getting all the databases on S4 HANA that would help.If the developers were to enhance or improve the application logic while processing the transactions, that would be great.

More SAP HANA Cons »

The organization who owns the product does not support it well and appears not to be doing significant development for the future.

More SAP IQ Cons »

Pricing and Cost Advice
It is expensive, which isn't a problem for us because SAP HANA is processing the data so fast.People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or not. People often ask, how will I profit when the cost is so high?

More SAP HANA Pricing and Cost Advice »

The only costs after standard licensing fees are for add-ons and upgrades.

More SAP IQ Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Relational Databases solutions are best for your needs.
437,064 professionals have used our research since 2012.
Questions from the Community
Top Answer: The memory is the solution's most valuable feature. It's the main feature of HANA. Others are still the regular IT databases that are on storage and are therefore much slower than HANA. The solution… more »
Top Answer: The pricing is expensive and it should be broken into two products. People who are technical will accept the cost, but financially they will assess whether this solution will bring them revenue or… more »
Top Answer: Unlike other databases, it lacks management features that legacy databases like Oracle or SQL servers have. They need to make the solution easier to manage and offer tools that make management more… more »
Ask a question

Earn 20 points

Ranking
4th
Views
10,619
Comparisons
8,672
Reviews
10
Average Words per Review
439
Avg. Rating
8.1
11th
Views
3,090
Comparisons
2,127
Reviews
1
Average Words per Review
1,235
Avg. Rating
8.0
Popular Comparisons
Compared 38% of the time.
Compared 13% of the time.
Compared 8% of the time.
Compared 8% of the time.
Compared 2% of the time.
Compared 20% of the time.
Compared 10% of the time.
Compared 8% of the time.
Compared 8% of the time.
Also Known As
SAP High-Performance Analytic Appliance, HANASybase IQ
Learn
SAP
SAP
Overview

The SAP HANA® platform helps you reimagine business by combining a robust database with services for creating innovative applications. It enables real-time business by converging trans-actions and analytics on one in-memory platform. Running on premise or in the cloud, SAP HANA untangles IT complexity, bringing huge savings in data management and empowering decision makers everywhere with new insight and predictive power.

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.

Offer
Learn more about SAP HANA
Learn more about SAP IQ
Sample Customers
Unilever, NHS 24, adidas Group, CHIO Aachen, Hamburg Port Authority (HPA), Bangkok Airways Public Company LimitedASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Top Industries
REVIEWERS
Energy/Utilities Company20%
Construction Company10%
Consumer Goods Company10%
Government10%
VISITORS READING REVIEWS
Computer Software Company51%
Comms Service Provider11%
Media Company8%
Government4%
REVIEWERS
Financial Services Firm67%
Healthcare Company11%
Insurance Company11%
Marketing Services Firm11%
VISITORS READING REVIEWS
Computer Software Company50%
Comms Service Provider14%
Government9%
Retailer6%
Find out what your peers are saying about Microsoft, Oracle, IBM and others in Relational Databases. Updated: August 2020.
437,064 professionals have used our research since 2012.
SAP HANA is ranked 4th in Relational Databases with 13 reviews while SAP IQ is ranked 11th in Relational Databases with 1 review. SAP HANA is rated 8.2, while SAP IQ is rated 8.0. The top reviewer of SAP HANA writes "We can get more tenders because of the lower cost while providing a better product or service". On the other hand, the top reviewer of SAP IQ writes "An excellent column-based, enterprise relational database solution with good speed and compression". SAP HANA is most compared with SQL Server, Oracle Database, MySQL, Apache Spark and Vertica, whereas SAP IQ is most compared with Apache Hadoop, SAP Adaptive Server Enterprise, Oracle Database, SQL Server and Oracle Exadata.

See our list of best Relational Databases vendors.

We monitor all Relational Databases 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.