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

Oracle Big Data Appliance vs SAP IQ comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

Review summaries and opinions

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

Categories and Ranking

Oracle Big Data Appliance
Ranking in Data Warehouse
19th
Average Rating
8.0
Reviews Sentiment
7.5
Number of Reviews
5
Ranking in other categories
No ranking in other categories
SAP IQ
Ranking in Data Warehouse
13th
Average Rating
8.0
Reviews Sentiment
6.7
Number of Reviews
21
Ranking in other categories
Relational Databases Tools (26th)
 

Mindshare comparison

As of April 2025, in the Data Warehouse category, the mindshare of Oracle Big Data Appliance is 1.1%, down from 1.5% compared to the previous year. The mindshare of SAP IQ is 2.6%, up from 1.6% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse
 

Featured Reviews

Mohammed Hamad - PeerSpot reviewer
Provides clean, centralized data
From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera. Oracle could also improve Big Data Appliance by having one technology on their stack and working on it instead of continually changing the name or technologies or features. In addition, they could have a program to enable their partners to use this technology because right now, I have to have an expert to use the AI elements.
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

"This is a comprehensive solution that is easy to deploy."
"The best thing about the product is that the end-user can build the reports by themselves without really knowing anything about databases."
"Because Big Data Appliance allows me to have a single source of truth, it means I have clean data that can be monetized and leveraged to gain more insights with real-time reports from the dashboard."
"The product is easy to learn."
"Valuable features for us include the compression, speed, fast response time, and easy object maintenance."
"The initial setup is easy."
"Unbeatable speed and compression with a colummn-structured relational database."
"IQ is a very high-performance and high-transaction database."
"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 column-based technologies (basically all the database for ITP) are used for SAP IQ. It is used as a column-based solution."
 

Cons

"It seems like the deployment of repositories has become more difficult in later versions of the product rather than easier."
"The product should be simplified for the average user."
"From a technical perspective, Big Data Appliance could be improved with more innovation in the AI and machine-learning parts instead of relying on Cloudera."
"The primary negative aspect is the cost, which can be a challenge due to the economic conditions in Peru."
"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."
"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 tool gets stuck sometimes."
"I think the universe should be part of the Sybase IQ tool set."
"The solution works best when combined with other SAP solutions. If the environment has other systems other options might be better."
"There is very little documentation available."
 

Pricing and Cost Advice

"Oracle's prices are too high compared to others in the market."
"It's not that costly. So, the pricing is cheap."
"The only costs after standard licensing fees are for add-ons and upgrades."
"Negotiation is very important."
"Evaluate all options; check to see if you need expensive add-ons."
"Negotiate based on the features required."
"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.
846,617 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Financial Services Firm
31%
Computer Software Company
15%
Government
10%
University
7%
Financial Services Firm
45%
Computer Software Company
9%
Manufacturing Company
6%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Ask a question
Earn 20 points
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.
What is your primary use case for SAP IQ?
I worked on implementing new databases, migration data in production, and developer environments with SAP IQ.
 

Comparisons

 

Also Known As

No data available
Sybase IQ
 

Overview

 

Sample Customers

Caixa Bank
ASR Group, Citrix, State of Indiana, PocketCard Co. Ltd.
Find out what your peers are saying about Oracle Big Data Appliance vs. SAP IQ and other solutions. Updated: April 2025.
846,617 professionals have used our research since 2012.