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

Oracle Exadata vs SAP IQ comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024
 

Categories and Ranking

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

Mindshare comparison

As of December 2024, in the Data Warehouse category, the mindshare of Oracle Exadata is 19.3%, up from 18.6% compared to the previous year. The mindshare of SAP IQ is 2.4%, up from 1.4% 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

"Parallelism is the most valuable feature."
"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."
"It is a highly relevant option with extreme performance."
"The most valuable feature of Oracle Exadata is the integration with other solutions, such as SAN storage and shared VLAN network."
"They just have a lot of products, and they work well together."
"Before using this machine, we took no less than two days to run a report. Now, we can do it within five hours. So, there is a lot of improvement."
"What I like best about Oracle Exadata is its good performance. It's also a very fast solution."
"The most valuable feature of Oracle Exadata is the smart scan. We have large TB sessions of approximately 100 per second for each of our three instances. The smart scan allows us the obtain data in time in the enterprise manager."
"The product is easy to learn."
"The initial setup is easy."
"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."
"Unbeatable speed and compression with a colummn-structured relational database."
"IQ is a very high-performance and high-transaction database."
"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."
 

Cons

"The cost of the solution is high and can be improved."
"The analytics features must be improved."
"License or upgrade management can be difficult and time consuming because it requires login to a separate console."
"The improvement could be made on the hardware level as the habit in the industry is to go better and faster and larger with every iteration."
"We have experienced some issues with processing unstructured data on Exadata. This is an important requirement for our AIML based use case. Reactive analytics data can not be prepared easily in Oracle Exadata."
"Certification should also be improved. Today, Oracle doesn't certify applications with engineered systems."
"The solution could always be more stable and more reliable."
"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."
"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."
"Concurrency and functional error messaging."
"There is very little documentation available."
"The room for improvement would be the marketing of the product, because this product is much better than advertised."
"The only negative aspect of IQ is the cost, which can be challenging for companies in Peru."
"The tool gets stuck sometimes."
"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."
"I think the universe should be part of the Sybase IQ tool set."
 

Pricing and Cost Advice

"The price of the solution has been expensive to implement."
"The solution is expensive."
"I did note that Oracle does tend to internally oversize things especially if they want to fill up a budget, and hence third-party oversight is essential."
"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."
"It is an expensive product and you pay more for certain performance enhancements."
"We pay for an annual license and it is expensive."
"The solution’s cost is a little bit more than the traditional databases."
"Our customers are always looking to reduce the license's cost."
"The only costs after standard licensing fees are for add-ons and upgrades."
"Negotiate based on the features required."
"It's not that costly. So, the pricing is cheap."
"Negotiation is very important."
"Evaluate all options; check to see if you need expensive add-ons."
"The cost of implementation is about $3,000."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
824,053 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
29%
Computer Software Company
13%
Manufacturing Company
6%
Government
5%
Financial Services Firm
43%
Computer Software Company
8%
Manufacturing Company
7%
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?
IQ implementation costs about three thousand dollars. It's less expensive compared to alternatives like Teradata Base in terms of transactional efficiency.
What needs improvement with SAP IQ?
The primary negative aspect is the cost, which can be a challenge due to the economic conditions 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.
824,053 professionals have used our research since 2012.