Oracle Database Appliance vs SAP Business Warehouse comparison

Oracle Database Appliance vs. SAP Business Warehouse

Download the complete report

Helped 885,311 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 (9th)

SAP Business Warehouse

Average Rating

7.8

Reviews Sentiment

6.1

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (15th)

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

"It has many valuable features, including High Availability and failover, which means you can have an all-ERP solution in one box, so you can use your database with your application server together."

"Oracle Database Appliance provides high stability."

"From the day of installation we did not have any challenges with this product."

"The product is good value for money. It is a secure solution."

"The tool is a specific and effective system. I am impressed with its usability."

"Once received, you can unpack it, rack it, install it in less than one day and having a fully usable machine very quickly."

"When we think about the technology and the features that this machine delivers, the price seems to provide a lot of value."

"The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks."

More Oracle Database Appliance pros

"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 Real-time InfoCube is quite useful in terms of getting information fast when we need it."

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

"The key element in this solution is its rapid response, because if you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two, and that is the key benefit for us that a solution like BW gives us."

"Now, because of the HANA integration, the hard disk and RAM are together, and because of that, the output is very quick and very fast actually."

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

"The most valuable feature of this solution is the advanced structuring of data capabilities, as you can get different structures of data to suit your needs."

"The most valuable feature is the new version of Business Explorer Analyzer, which is a very good version because there are a lot of analytical features of Excel also."

More SAP Business Warehouse pros

Cons

"The main thing would be to make ODA more affordable, to make it a more economical machine. Also, I would like to see virtualization, so you could implement all of your functions on one machine."

"It isn't as popular as AWS, GCP, or Azure as it lacks scalability and cloud-native services like containerization."

"Since we don't have the room to scale up, I rate this solution a six out of ten for scalability."

"It is unable to expand by much, because of the way the ODA configures when you have two nodes and X number of storage."

"If we were able to use Oracle Database to create mobile apps, that would be great. I don't know multiple languages, like Java, etc. I need to learn a separate language, right now in order to do this."

"Oracle Database Appliance patching comes out two to three months after the regular patching cycle."

"The setup is a bit complex."

More Oracle Database Appliance cons

"What I'd like to improve in SAP Business Warehouse is its data structure, that's a little bit rigid. It could be a bit more flexible, so you can design your data structure and improve performance when creating a solution. Currently, the way data is stored in SAP Business Warehouse is rigid."

"We are very unhappy with technical support. First of all, they send their sales agents or pre-sales agents and most of them who don't know the solution as a properly trained tech would. We have an on-site SAP representative who is supposed to help us with our high priority and production issues, and they're not satisfactory to say the least."

"The big minuses are its not being user friendly."

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

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

"They should reduce the product’s installation package size for easier downloading."

"Integration with SAP Business Warehouse's ETL tools is not straightforward."

"The way the data is stored is kind of rigid in SAP BW as a product. It could be more flexible so that when we are designing a solution, we can design our own data structures and try to improve performance."

More SAP Business Warehouse cons

Pricing and Cost Advice

"The solution's pricing is very high."

"The product is costly."

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

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

"Oracle Database Application's support and maintenance are included in the contract."

"Oracle’s pricing is ridiculously high."

"The price should be lower."

"The solution may be expensive, but when we consider the problems it solves, the stability it provides, and the fact that we don't have to buy separate parts and assemble them into a system, it becomes more affordable."

More Oracle Database Appliance pricing and cost advice

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

"Overall, the pricing is not fixed and is 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."

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

"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."

"The solution is quite expensive."

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

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

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

885,311 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

16%

Computer Software Company

Government

Manufacturing Company

12%

Healthcare Company

Retailer

Energy/Utilities 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 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?

What is your primary use case for SAP Business Warehouse?

I am using SAP Business Warehouse in my organization for data warehousing as well as an ETL tool. Integration with SAP Business Warehouse's ETL tools is not straightforward. Integration with SAP ER...

Oracle Exadata vs Oracle Database Appliance

Comparisons

Compared 18% of the time

VMware Tanzu Data Solutions vs Oracle Database Appliance

Compared 9% of the time

Dell PowerStore vs Oracle Database Appliance

Compared 5% of the time

Actian Ingres vs Oracle Database Appliance

Compared 5% of the time

Microsoft Azure Synapse Analytics vs Oracle Database Appliance

Compared 4% of the time

More Oracle Database Appliance Competitors

Databricks vs SAP Business Warehouse

Compared 14% of the time

BigQuery vs SAP Business Warehouse

Compared 13% of the time

Microsoft Azure Synapse Analytics vs SAP Business Warehouse

Compared 11% of the time

Snowflake vs SAP Business Warehouse

Compared 10% of the time

SAP Business Data Cloud vs SAP Business Warehouse

Compared 10% 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