Try our new research platform with insights from 80,000+ expert users

Oracle Exadata vs SAP IQ comparison

 

Comparison Buyer's Guide

Executive Summary
 

Categories and Ranking

Oracle Exadata
Ranking in Data Warehouse
2nd
Average Rating
8.6
Reviews Sentiment
7.3
Number of Reviews
126
Ranking in other categories
No ranking in other categories
SAP IQ
Ranking in Data Warehouse
16th
Average Rating
8.0
Number of Reviews
21
Ranking in other categories
Relational Databases Tools (24th)
 

Mindshare comparison

As of November 2024, in the Data Warehouse category, the mindshare of Oracle Exadata is 19.0%, up from 18.4% compared to the previous year. The mindshare of SAP IQ is 2.3%, up from 1.3% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Guruprasad Gonjare - PeerSpot reviewer
Offers a variety of valuable features
The deployment depends on the Exadata options. There are primarily three options which include, Exadata, Exadata Cloud@Customer, and Exadata Cloud Service. Out of these, Cloud Service requires the minimum effort. The deployment takes around two to three weeks to complete. For the deployment purpose, we need information on the user base where the access is going to happen. We would also require around four to five engineers and admins for the solution’s deployment and maintenance. This estimation is based on the workflow.
Tejas Raj - PeerSpot reviewer
Columnar database, so pulling records is easy but there isn't enough documentation for installation
I've seen very few SAP IQ systems in recent years. So people are moving away from SAP IQ In the last three years, I've rarely encountered customers using it. Fewer systems with SAP IQ usage among our customers. Most of them have moved on to HANA. There are parallel products, and there are also viable alternatives from AWS, so many have migrated to those.

Quotes from Members

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

Pros

"The performance on the databases is good."
"The data replication is very good."
"Oracle is easy to use for peripheral things, such as the data vault and the data firewall, data sync, and partitions. These are the features that give an edge to other databases."
"We have used this solution for a long period of time so it has become easy for us to query any kind of data from Oracle Exadata which has been valuable."
"On-premises Exadata is just as stable as the cloud version. It's a very stable platform."
"Parallelism is the most valuable feature."
"The most valuable feature is that you have the same familiar environment of an Oracle database but with the additional performance you get from this architecture."
"It is a highly relevant option with extreme performance."
"Unbeatable speed and compression with a colummn-structured relational database."
"The column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
"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."
"All data is compressed and indexed, allowing for fast execution of transactions."
"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 initial setup is easy."
"It is very robust for ad hoc DW queries and its columnar compression is unique and valuable."
 

Cons

"In a future release, I would like to see some upgrade analysis advisors to help with a clear roadmap on steps that need to be taken and some of the automated processes."
"Oracle Exadata compatibility with the analytics could be better and the OBIEE could improve. Oracle BI to Exadata needs to be improved. Even if the full analytics practice for Oracle should be improved and when compared with other solutions it is weak."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"The solution's pricing is very high."
"Oracle Exadata could improve the monitoring system in the enterprise manager, it could be more user-friendly. In most Oracle tools there is a lot of functionality, and sometimes you need to do five or six clicks to find metrics, and sometimes it's a waste of time."
"The cost of the solution is high and can be improved."
"Tech support sometimes takes some time to identify and rectify issues."
"The analytics features must be improved."
"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."
"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."
"I think the universe should be part of the Sybase IQ tool set."
"There is very little documentation available."
"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."
"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 organization who owns the product does not support it well and appears not to be doing significant development for the future."
 

Pricing and Cost Advice

"The solution takes a lot of time to clone the environment. I would like to see some improvement in the cloning support or the time it takes on the storage side."
"I give the pricing of the solution a five out of ten."
"It is an expensive product and you pay more for certain performance enhancements."
"Oracle Exadata is not a cheap solution. Pricing is a problem for Oracle, and every client, not just my company, would like the vendor to improve on the price, or lower the price. My company paid for several years' worth of Oracle Exadata licenses. You need to pay for the technical support and other features separately, on different contracts. In terms of affordability, my rating for Oracle Exadata is two out of five."
"I would rate the tool's pricing a nine out of ten."
"All things considered, the price of this product is fairly high, as is always the case with Oracle."
"The solution is expensive."
"In the sizing phase, you can also decide whether to license all cores, or reduce the number cores using capacity-on-demand features of Exadata, as well. This has a direct impact on licensing."
"Negotiate based on the features required."
"The cost of implementation is about $3,000."
"It's not that costly. So, the pricing is cheap."
"Evaluate all options; check to see if you need expensive add-ons."
"Negotiation is very important."
"The only costs after standard licensing fees are for add-ons and upgrades."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
816,406 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
30%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
Financial Services Firm
43%
Computer Software Company
9%
Manufacturing Company
8%
Government
5%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about Oracle Exadata?
It is the best solution for OLTP and data warehousing.
What is your experience regarding pricing and costs for Oracle Exadata?
The pricing of Exadata is high. It is more expensive than usual, making it suitable only for big enterprises or businesses that can afford it.
What needs improvement with Oracle Exadata?
I would like to add some features to run applications or microservices-based applications on Exadata.
What do you like most about SAP IQ?
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 mo...
What is your experience regarding pricing and costs for SAP IQ?
The cost of implementation is about $3,000. However, the cost is not much compared to the performance benefits.
What needs improvement with SAP IQ?
The only negative aspect of IQ is the cost, which can be challenging for companies in Peru.
 

Comparisons

 

Also Known As

No data available
Sybase IQ
 

Learn More

Video not available
 

Overview

 

Sample Customers

PayPal, EBS, Organic Food Retailer, Garmin, University of Minnesota, Major Semiconductor Company, Deutsche Bank, Starwood, Ziraat Bank, SK Telecom, and P&G.
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Find out what your peers are saying about Oracle Exadata vs. SAP IQ and other solutions. Updated: November 2024.
816,406 professionals have used our research since 2012.