Oracle Autonomous Data Warehouse vs SAP Business Warehouse comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
3,362 views|2,210 comparisons
100% willing to recommend
SAP Logo
1,249 views|773 comparisons
89% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Autonomous Data Warehouse and SAP Business Warehouse based on real PeerSpot user reviews.

Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Oracle Autonomous Data Warehouse vs. SAP Business Warehouse Report (Updated: March 2024).
769,789 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"It is a stable and scalable solution.""It is an extremely scalable solution since you can dynamically change the resources as some other cloud solutions.""The performance and scalability are awesome.""A very good integration feature that restricts access to unauthorized people.""It provides Transparent Data Encryption (TDE) capabilities by default to address data security issues.""The solution integrates well with Power BI.""The solution is self-securing. All data is encrypted and security updates and patches are applied automatically both periodically and off-cycle.""One advantage is that if you already have an Oracle Database, it easily integrates with that."

More Oracle Autonomous Data Warehouse Pros →

"The key element in this solution is its rapid response. If you have a question about prices, buyers, customers, providers, or services, you need the answer in a minute or two. That's the key benefit for us that a solution like BW gives us.""The warehouse is the solution's most valuable feature.""The most useful feature has been he ability to feed data into multiple systems in various formats.""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.""The most useful feature is definitely the speed.""The most valuable feature of this solution is the advanced structuring of data capabilities. You can get different structures of data to suit your needs.""The product is very stable.""The most valuable aspect of the solution is the integration with SAP ERP."

More SAP Business Warehouse Pros →

Cons
"I would like to see an on-premise solution in the future.""I would like to see Application Express and Oracle R Enterprise fully supported, and I would like to see Oracle Data Mining supported as a front end.""An improvement for us would be the inclusion of support for an internal IP, so we could use it directly with the VCN in Oracle Cloud.""My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on top of a JSON file with multiple array columns or superset columns, those column values create some difficulty in Oracle.""The solution lacks visibility options.""They should make the solution more user-friendly.""The installation process is complex. Oracle can make the installation process better.""A lot of the tools that were previously there have now been taken away."

More Oracle Autonomous Data Warehouse Cons →

"I would like to see a different end solution in order to read the data and attract internal users.""A few things which are missing include the visualization of reports. That's where your costs and licensing become heavy. When it comes to this database compared Microsoft Warehouse, it's an expensive solution.""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.""SAP Business Warehouse could integrate better with other ETL tools.""The advanced structuring can be complicated and the interface is not very intuitive.""I get all the information quickly, but it is one day old.""More integration with Microsoft Office products (not just Excel) would be helpful.""It's a product that is at the end of life so they will not improve it anymore."

More SAP Business Warehouse Cons →

Pricing and Cost Advice
  • "The cost is perfect with Oracle Universal credit."
  • "ROI is high."
  • "You pay as you go, and you don't pay for services that you don't use."
  • "Cloud solutions are cheaper, but in the long run, they may not be much cheaper. They certainly have a lower initial cost. The licensing is yearly, and it is based on the size of the hardware and the number of users."
  • "The solution's cost is reasonable."
  • "On a scale from one to ten, where one is a low price and ten is a high price, I rate the pricing an eight."
  • "The licensing cost of the product can vary since you can integrate it very easily with other products or other cloud products...You pay as you use it, so it is not yearly or monthly payments to be made toward Oracle."
  • "The price depends on the configuration we choose."
  • More Oracle Autonomous Data Warehouse Pricing and Cost Advice →

  • "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 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."
  • "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."
  • "The solution is quite expensive."
  • More SAP Business Warehouse Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    769,789 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:With Oracle Autonomous Data Warehouse, things are much simpler. Creating a structure, initializing the servers, extending the servers, those are all things that are very, very easy. That's the main… more »
    Top Answer:Cost-wise, it's a solid seven out of ten. A bit costly, but it is a good tool.
    Top Answer:My main suggestion for Oracle is the configuration and key values that come for JSON files. When we create a table, especially if you see in our RedShift or some other stuff, if I create a table on… more »
    Top Answer:The solution is quite expensive. We paid a yearly subscription fee.
    Top Answer:Over a period, we realized that the license and maintenance costs were quite expensive. Every day, we had to run the background job ODS. Eventually, we moved away from SAP Business Warehouse and… more »
    Ranking
    10th
    Views
    3,362
    Comparisons
    2,210
    Reviews
    7
    Average Words per Review
    556
    Rating
    8.1
    9th
    Views
    1,249
    Comparisons
    773
    Reviews
    11
    Average Words per Review
    650
    Rating
    7.6
    Comparisons
    Learn More
    Overview

    Oracle Autonomous Data Warehouse is the world’s first and only autonomous database optimized for analytic workloads, including data marts, data warehouses, data lakes, and data lakehouses. With Autonomous Data Warehouse, data scientists, business analysts, and nonexperts can rapidly, easily, and cost-effectively discover business insights using data of any size and type. Built for the cloud and optimized using Oracle Exadata, Autonomous Data Warehouse benefits from faster performance and, according to an IDC report (PDF), lowers operational costs by an average of 63%.


    Autonomous Database provides the foundation for a data lakehouse—a modern, open architecture that enables you to store, analyze, and understand all your data. The data lakehouse combines the power and richness of data warehouses with the breadth, flexibility, and low cost of popular open source data lake technologies. Access your data lakehouse through Autonomous Database using the world's most powerful and open SQL processing engine.

    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.

    Sample Customers
    Hertz, TaylorMade Golf, Outront Media, Kingold, FSmart, Drop-Tank
    Medtronic, Cirque du Soleil, Antarc, B&G Manufacturing, EarlySense, eBay, Ferrero, James Austin Company, Lenovo, Sagem, RAK Ceramics, Vodafone
    Top Industries
    REVIEWERS
    Computer Software Company27%
    Manufacturing Company18%
    Financial Services Firm18%
    Individual & Family Service9%
    VISITORS READING REVIEWS
    Educational Organization43%
    Financial Services Firm9%
    Computer Software Company8%
    Manufacturing Company4%
    REVIEWERS
    Insurance Company19%
    Non Tech Company13%
    Manufacturing Company13%
    Energy/Utilities Company13%
    VISITORS READING REVIEWS
    Computer Software Company13%
    Manufacturing Company11%
    Financial Services Firm9%
    Energy/Utilities Company8%
    Company Size
    REVIEWERS
    Small Business38%
    Midsize Enterprise6%
    Large Enterprise56%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise48%
    Large Enterprise39%
    REVIEWERS
    Small Business24%
    Midsize Enterprise16%
    Large Enterprise60%
    VISITORS READING REVIEWS
    Small Business20%
    Midsize Enterprise14%
    Large Enterprise66%
    Buyer's Guide
    Oracle Autonomous Data Warehouse vs. SAP Business Warehouse
    March 2024
    Find out what your peers are saying about Oracle Autonomous Data Warehouse vs. SAP Business Warehouse and other solutions. Updated: March 2024.
    769,789 professionals have used our research since 2012.

    Oracle Autonomous Data Warehouse is ranked 10th in Cloud Data Warehouse with 16 reviews while SAP Business Warehouse is ranked 9th in Cloud Data Warehouse with 25 reviews. Oracle Autonomous Data Warehouse is rated 8.6, while SAP Business Warehouse is rated 7.8. The top reviewer of Oracle Autonomous Data Warehouse writes "A tool for data warehousing that offers scalability, stability, and ease of setup". On the other hand, the top reviewer of SAP Business Warehouse writes "Offers powerful analytics and integration capabilities but requires improved upgrade processes". Oracle Autonomous Data Warehouse is most compared with Oracle Exadata, Snowflake, Microsoft Azure Synapse Analytics, BigQuery and Amazon Redshift, whereas SAP Business Warehouse is most compared with Microsoft Azure Synapse Analytics, Snowflake, BigQuery, SAP BW4HANA and SAP NetWeaver Business Warehouse. See our Oracle Autonomous Data Warehouse vs. SAP Business Warehouse report.

    See our list of best Cloud Data Warehouse vendors.

    We monitor all Cloud Data Warehouse reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.