Oracle Database Appliance vs SAP Business Warehouse comparison

Oracle Database Appliance vs. SAP Business Warehouse

Download the complete report

Helped 881,082 peers since 2012

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 Database Appliance

Average Rating

8.0

Reviews Sentiment

6.5

Number of Reviews

Ranking in other categories

Data Warehouse (6th)

SAP Business Warehouse

Average Rating

7.8

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (14th)

Featured Reviews

Rubens Oliveira

Data & Solution Archtect at Enkel

Automated provisioning simplifies deployment and integration

The Oracle Database Appliance is customizable and has excellent features.I don't have any problems with Oracle Database Appliance because this product is very automated, with scheduler and automatic processes throughout. You can make small inferences and changes for creating all the specific modifications. The automated provisioning feature helps speed up the database deployment process because you can use one command or option to resize all the disks or increase memory, depending on the occasion. The Oracle Database Appliance has integration in OCI Cloud. The same services simplify all the manager work regarding backups, configuration, resizing disks, and other services. Deploying the Oracle Database Appliance both on-premises and in the cloud offers the same simplification. You simply input your database name and specify memory quantity, CPU quantity, and database size. The process is identical for both on-premises and cloud deployments. The flexibility of Oracle Database Appliance has helped grow business needs for many customers. Using the Oracle Database Appliance has positively impacted my organization because I can deliver it much more comfortably. Creating a database involves many processes, but with this solution, you just input the name and configure the network and other parameters. It is very similar to RDS in AWS services, where you specify the name, choose the engine, indicate parameter groups, VPC, subnet groups, and proceed. Both Oracle Database Appliance and RDS have greatly simplified the work.

Read full review

VishnuReddy2

Consulting Enterprise Architect at R2V2.ai

Have encountered complexity with programming language while working on large-scale data integration and have experienced improved governance and reporting

The only complexity I find with the product is the programming language; people find it harder, but once you know the language, it's not that difficult. Regarding the future of SAP Business Warehouse, I would to see added features that simplify the product very well now. They are coming up with a terminology called SAP BDC where they are consolidating their tools, SAP Data Sphere for integration and SAP BW for the ETL and warehousing parts, and SAP Analytics Cloud. They are packaging these three features and calling it Business Data Cloud; they are fully coming on the cloud. We have to wait and watch; they have been speaking about BW/4HANA for quite some time now, but the customers or clients I work with are not finding great interest and it was seen as a candidate for evaluation. I have seen people looking at the latest technologies who are already on cloud who started building from scratch on cloud, such as Snowflake or Databricks, which can process very huge amounts of data and also address unstructured data, where SAP lags behind in cases where there is a need to bring in unstructured data. I have worked with SAP Data Intelligence, which earlier used to be called SAP Data Hub. The unstructured data is not greatly handled in SAP at this point in time.

Read full review

Quotes from Members

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

Pros

"Oracle offers ETL with PL/SQL as a programming language for SQL programming, which is majorly used in data engineering."

"The performance due to the all-flash of ODA is very nice."

"We primarily use it for OLTP, which has improved our costs."

"The most valuable feature of Oracle Database Appliance is the ease of management."

"Oracle Database Appliance provides high stability."

"The product is excellent. It is simple and reliable in terms of installation and maintenance."

"Oracle Database Appliance is user-friendly, and it is easy to understand the query."

"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."

More Oracle Database Appliance pros

"The warehouse is the solution's most valuable feature."

"The most valuable feature of SAP Business Warehouse is its hybrid functionality, allowing users to leverage both SQL-based data warehouse capabilities from HANA and feature-based data warehousing from BW."

"In terms of stability, comparatively, the solution is quite stable."

"What I like most about SAP Business Warehouse is that it's a seamless integration platform. A valuable feature in the tool is the monitoring alert that makes you aware of what process chain has failed. There's no manual monitoring required if you have configured an alert system, so the process chain can run in the background, and you can get alerts about it. The functionalities I find good in SAP Business Warehouse are alerting and monitoring. If you have configured the tool and have integrated it with SAP Solution Manager, then it's a good product to use."

"What I like most about SAP Business Warehouse is its ability to feed data into new, multiple systems in various formats. It can open its data to any system over gateway services or a portal or application that needs to consume and analyze data."

"The solution has functionality that makes it easy for end-users to readily extract data directly from Business Warehouse into Excel and carry on their analysis on their own."

"With the technical support, the response has been pretty good from the SAP side."

"Having the back-end data set with the right information is the best qualification for this solution."

More SAP Business Warehouse pros

Cons

"The solution’s flexibility could be improved."

"We would like the ability to add more storage without having to upgrade to Oracle Exadata."

"I would like it if the scalability could be increased without having to change versions."

"Even though the solution can handle a lot of data, it's just too expensive currently."

"Oracle Database Appliance has not impacted my organization positively."

"They could incorporate a more secure and internet-centric management system for the platform."

"In terms of what can be be improved, I'd say Artificial Intelligence, AI. It would be really helpful if AI was incorporated within the solution."

"Technical support is not so great. It could be much better. The maintenance, for an enterprise system, isn't so great. It's also extremely expensive."

More Oracle Database Appliance cons

"I'm not sure if our issue is related to BW or the Analysis Office. However, we're having performance issues in terms of time. It takes a long time to generate the report."

"You can start quickly but, when you have to get a little more detailed, when you have to change something, when you have to solve problems, it's not that easy. It's easy to start but evolving is not that easy."

"It's a product that is at the end of life so they will not improve it anymore."

"SAP Business Warehouse could improve by having more out-of-the-box use cases to cover more business types or operations."

"I get all the information quickly, but it is one day old."

"What I'd like improved in SAP Business Warehouse is its setup. It could be more flexible, and it could be a configuration-based setup."

"The advanced structuring can be complicated and the interface is not very intuitive."

"The solution could offer better connectivity with other databases."

More SAP Business Warehouse cons

Pricing and Cost Advice

"On a scale from one to ten, where one is cheap and ten is expensive, I rate the solution's pricing seven and a half or eight out of ten."

"The price should be lower."

"The solution's pricing is very high."

"Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."

"The product is costly."

"In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."

"The price of the solution should be less expensive. However, they will increase the price more."

"I don’t know ODA and alternative system prices. But Oracle the database license is quite expensive and a lot of my customers plan to migrate to open source databases like PostgreSQL."

More Oracle Database Appliance pricing and cost advice

"SAP Business Warehouse licensing is a bit expensive compared to other products in the market."

"It's moderately expensive, but definitely has its branding and price value for it."

"Overall, the pricing is not fixed and is expensive."

"It's quite pricey. SAP changed its pricing policy, so they give you one engine and then you have to buy everything next to it, like MSS, the BPC licenses, and everything else."

"I would not recommend it to small-scale companies. The price is too much."

"The solution is quite expensive."

"The licensing cost for SAP Business Warehouse depends on your revenue. Its licensing structure is a little bit complicated. The more your revenue is, the higher the price, but SAP does have different pricing structures for various companies. For small businesses, licensing isn't based on revenue, but for big companies, it's revenue-based. There's some agreement regarding pricing for huge companies, so it's different, and SAP Business Warehouse pricing isn't fixed. On a scale of one to ten, I'm rating the licensing cost for SAP Business Warehouse as five because it's very high. As your revenue grows, your licensing cost also increases, so you have to factor that in when calculating your cost."

"The license for SAP Business Warehouse is paid yearly, and there's no extra cost in addition to the standard licensing fees."

See which vendors are best for you

Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.

See recommendations

881,082 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

22%

Computer Software Company

Government

Manufacturing Company

13%

Retailer

10%

Energy/Utilities Company

Healthcare Company

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	21
Midsize Enterprise	9
Large Enterprise	15

By reviewers
Company Size	Count
Small Business	8
Midsize Enterprise	4
Large Enterprise	15

Questions from the Community

What do you like most about Oracle Database Appliance?

Oracle Database Appliance provides high stability.

What is your experience regarding pricing and costs for Oracle Database Appliance?

I am satisfied with the price for Oracle Database Appliance.

What needs improvement with Oracle Database Appliance?

Currently, Oracle Database Appliance is good with no room for improvement.In future updates of Oracle Database Appliance, I would like to see AI implemented since AI is getting more attention.

What do you like most about SAP Business Warehouse?

Out-of-the-box reports are very useful.

What is your experience regarding pricing and costs for SAP Business Warehouse?

The pricing for SAP Business Warehouse is on the expensive side. I am not sure about the current costing model as such. In my experience on cloud, I did not use BW HANA Cloud. I used the cloud prod...

What needs improvement with SAP Business Warehouse?

Oracle Exadata vs Oracle Database Appliance

Comparisons

Compared 28% of the time

VMware Tanzu Data Solutions vs Oracle Database Appliance

Compared 11% of the time

Databricks vs Oracle Database Appliance

Compared 5% of the time

Actian Ingres vs Oracle Database Appliance

Compared 5% of the time

Dell PowerStore vs Oracle Database Appliance

Compared 5% of the time

More Oracle Database Appliance Competitors

Databricks vs SAP Business Warehouse

Compared 18% of the time

BigQuery vs SAP Business Warehouse

Compared 18% of the time

Microsoft Azure Synapse Analytics vs SAP Business Warehouse

Compared 11% of the time

SAP BW4HANA vs SAP Business Warehouse

Compared 10% of the time

Snowflake vs SAP Business Warehouse

Compared 9% of the time

More SAP Business Warehouse Competitors

Product Reports

Oracle Database Appliance

Download Oracle Database Appliance product report

SAP Business Warehouse

Download SAP Business Warehouse product report

Also Known As

X5-2

No data available

Overview

Oracle Database Appliance is the easiest and most affordable way for small or medium-size organizations to run Oracle databases and applications and is an ideal platform for remote and edge computing environments. Customers reduce Oracle Database deployment times and management workloads using a prebuilt integrated system with management automation. As demonstrated in IDC’s business value study (PDF), Oracle Database Appliance lets customers grow revenue and control costs, delivering up to a 498% return on investment (ROI) over five years.

Oracle

Reporting, analysis and interpretation of business data are crucial to preserve and enhance the competitive edge of companies by optimizing processes and enabling them to react quickly and in line with market needs. SAP Business Warehouse (SAP BW) provides tools and functions that enable companies to attain these goals. In SAP BW, you can integrate, transform, and consolidate relevant business information from productive SAP applications and external data sources. SAP BW provides you with a high-performance infrastructure that helps you evaluate and interpret data. Decision makers can make well-founded decisions and identify target-orientated activities on the basis of the analyzed data.

SAP

Sample Customers

LifeLock, Incarlopsa, Al Yusur Industrial Contracting

Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone

Oracle Database Appliance vs. SAP Business Warehouse