Oracle Database Appliance vs SAP BW4HANA comparison

Cancel
You must select at least 2 products to compare!
Oracle Logo
3,045 views|2,195 comparisons
87% willing to recommend
SAP Logo
2,202 views|1,484 comparisons
84% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between Oracle Database Appliance and SAP BW4HANA based on real PeerSpot user reviews.

Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI.
To learn more, read our detailed Oracle Database Appliance vs. SAP BW4HANA Report (Updated: March 2024).
767,995 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
"The solution is pretty automated, which takes out the possibility of human error.""Easy management (it saves a lot of installation and patching time).""The solution is stable. The product is scalable. The technical support is very helpful. The initial setup is straightforward. I consider the product a strong solution for our customers.""Oracle Database Appliance provides high stability.""Oracle Database Appliance is a stable solution. We have clients that have been running it for 10 years.""The product’s valuable feature is its capability to pre-configure and pre-install the settings.""The performance due to the all-flash of ODA is very nice.""The most valuable feature of Oracle Database Appliance is the ease of management."

More Oracle Database Appliance Pros →

"We can get good visualization and less redundant data.""The solution seamlessly integrates with SAP products.""The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements.""SAP BW4HANA aids in managing data from ER to front-end analysis, contributes to ROI, and fosters business growth understanding. I like that the solution breaks down components to a very granular level, allowing for customization and implementation based on specific requirements. The solution is stable. The solution is scalable.""Provides a great analytics engine with all the capabilities.""It is a stable solution...The initial setup was easy.""The solution is easier to maintain than traditional SAP products.""Its direct approach is the most valuable. You get more real time and capabilities than BW."

More SAP BW4HANA Pros →

Cons
"Oracle Database Appliance is stopping support for the standard edition and only continuing support for the RAC One Node. They did not inform us and we are having problems with our customers. We are not having to change our systems from standard to something else.""Virtualization features could also be improved. A web-based GUI would be a good start.""Sometimes, we cannot upgrade or patch it easily. The performance needs to improve.""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.""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. Finally, improvement in the speed and performance would be good.""Oracle's product support is an area of concern where improvements are required.""The setup is a bit complex.""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."

More Oracle Database Appliance Cons →

"We cannot integrate with third-party tools like Python or advanced integration options. You can't fine-tune tables within BW or generate specific views or reports.""The dashboard should be simplified and made easier for exploration and decision making.""If I want to have good reporting, then I have to buy a separate license.""I would like more integration.""Pricing would be a good improvement. A lot of customers think that it's very expensive and especially support is very expensive.""I don't see SAP actively supporting the solution now...a better support from SAP would be appreciated.""BW/4HANA could improve query optimization. For example, there could be an error message that pops up when you hover over it if any query fails. That would make it easier to find out what went gone wrong. Guided SAP help tools would make it easier for us to go forward.""There's one area where the other vendors have an upper edge, which is the data lake. I think SAP is trying to figure out whether to stick with IQ, their own data lake solution, or push customers toward customer-preferred vendors, like Azure Data Lake, AWS, or any other provider."

More SAP BW4HANA Cons →

Pricing and Cost Advice
  • "Get benefit from the capacity-on-demand features. License your cores according to your licenses."
  • "Leverage the Pay-As-You-Grow licensing, and consider using the ODA X6-2 S/M/L models also for SE2/SE."
  • "In regards to licensing, it is cheaper to maintain for Oracle applications, and it's an all-in-one solution."
  • "The price should be lower."
  • "You must pay for the license."
  • "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."
  • "Compared to Oracle Exadata, Oracle Database Appliance is affordable."
  • More Oracle Database Appliance Pricing and Cost Advice →

  • "This is an expensive solution and there are costs in addition to the standard licensing fees."
  • "We started as early birds from the SAP side. We got this entire suite for free. I cannot really talk about the price because we didn't have to pay anything."
  • "As an investment, the solution is very expensive."
  • "In general, it's quite expensive."
  • "SAP BW/4HANA is expensive."
  • "The cost and licensing depends on how the customer is going to use the solution."
  • "The SAP HANA application still hasn't been leveraged to the fullest extent, but it's a five-year enterprise license."
  • "It is an expensive product."
  • More SAP BW4HANA Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
    767,995 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:The product is excellent. It is simple and reliable in terms of installation and maintenance.
    Top Answer:The product is costly. However, it is the price is justifiable for the excellent technology it offers.
    Top Answer:They could incorporate a more secure and internet-centric management system for the platform.
    Top Answer:It is a stable solution...It is a scalable solution.
    Top Answer:For the on-premises version of the product, the solution offers a perpetual-based licensing model to its users. In general, SAP offers a monthly subscription-based licensing model to its users. The… more »
    Top Answer:SAP BW4HANA is a standard product that works as a very applicable system for our company. SAP BW4HANA aims to reduce all the problems and issues related to SAP BW. SAP BW4HANA is helpful in areas… more »
    Ranking
    6th
    out of 34 in Data Warehouse
    Views
    3,045
    Comparisons
    2,195
    Reviews
    13
    Average Words per Review
    354
    Rating
    7.8
    7th
    out of 34 in Data Warehouse
    Views
    2,202
    Comparisons
    1,484
    Reviews
    17
    Average Words per Review
    487
    Rating
    7.2
    Comparisons
    Also Known As
    X5-2
    SAP BW/4HANA
    Learn More
    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.

    SAP BW4HANA is a data warehouse solution developed by SAP for businesses looking to analyze big data in real time. It is designed to run on the SAP HANA database, offering improved performance and optimized processing of large data sets. SAP BW/4HANA provides an array of advanced analytics capabilities, including predictive analytics, text analytics, and spatial data processing. It also offers a modern, intuitive user interface and streamlined data modeling and administration tools, making it easier for businesses to access, manage, and utilize their data.

    SAP BW4HANA Features

    SAP BW4HANA has many valuable key features. Some of the most useful ones include:

    • In-memory data processing: The solution runs on the SAP HANA database, providing fast and efficient data processing.
    • Advanced analytics: SAP BW4HANA includes capabilities for predictive analytics, text analytics, and spatial data processing.
    • Data modeling and administration: The solution provides streamlined data modeling and administration tools for efficient data management.
    • Modern user interface: SAP BW4HAN is designed with a modern, intuitive user interface for easier data access and analysis.
    • Data warehousing optimization: The solution is optimized for big data warehousing, offering improved performance and scalability.
    • Integration with SAP ecosystem: SAP BW4HAN integrates with the SAP ecosystem, including SAP S/4HANA and SAP Cloud Platform, for seamless data exchange.
    • Real-time data processing: It supports real-time data processing and analysis, enabling businesses to make data-driven decisions.
    • Data governance and security: With its robust data governance and security features, SAP BW4HAN can be used for secure data management and compliance.
    • Automated data loading: SAP BW4HAN supports automated data loading from various sources, including SAP and non-SAP systems.
    • Advanced data visualization: With its advanced data visualization capabilities, users can generate better data insights and make more informed business decisions.

    SAP BW4HANA Benefits

    There are many benefits to implementing SAP BW4HANA. Some of the biggest advantages the solution offers include:

    • Improved data processing speed: Running on the SAP HANA database, SAP BW/4HANA provides fast and efficient data processing, resulting in improved performance and reduced downtime.
    • Streamlined data management: The solution's streamlined data modeling and administration tools make it easier for organizations to manage their data, improving overall efficiency and reducing the risk of errors.
    • Improved data governance: SAP BW/4HANA includes robust data governance and security features, helping organizations meet regulatory requirements and protect sensitive data.
    • Cost savings: By optimizing data warehousing processes, SAP BW/4HANA helps organizations reduce costs and improve their bottom line.

    Reviews from Real Users

    SAP BW4HANA is a solution that stands out when compared to many of its competitors. Some of its major advantages are its hierarchical alert slicing, real-time insights, and its ability to transform large amounts of data.

    PeerSpot reviewer, Srivatsav A., SAP BW/4HANA Specialist at a government, is very happy with the solution. He explains, "You can do hierarchical alert slicing and dicing out-of-box, which is not available in other solutions. I haven't come across that in Oracle or any other software provider."

    “It has got wonderful features in terms of analyzing your production data, and it gives you real-time insight into productive maintenance. You can plan your budget, and you can map them against actuals. It gives you good insights on overall performance and processes,” says Amrit J., ERP Application Manager at an energy/utilities company.


    In addition, a Technology Analyst at a tech services company mentions, "The most valuable feature is that we can transform a huge amount of data and apply business logic as per the requirements."

    Sample Customers
    LifeLock, Incarlopsa, Al Yusur Industrial Contracting
    Information Not Available
    Top Industries
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Retailer11%
    Transportation Company5%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company7%
    REVIEWERS
    Manufacturing Company28%
    Computer Software Company17%
    Healthcare Company11%
    Comms Service Provider11%
    VISITORS READING REVIEWS
    Manufacturing Company15%
    Computer Software Company11%
    Energy/Utilities Company8%
    Financial Services Firm7%
    Company Size
    REVIEWERS
    Small Business42%
    Midsize Enterprise21%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    REVIEWERS
    Small Business35%
    Midsize Enterprise10%
    Large Enterprise55%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise11%
    Large Enterprise73%
    Buyer's Guide
    Oracle Database Appliance vs. SAP BW4HANA
    March 2024
    Find out what your peers are saying about Oracle Database Appliance vs. SAP BW4HANA and other solutions. Updated: March 2024.
    767,995 professionals have used our research since 2012.

    Oracle Database Appliance is ranked 6th in Data Warehouse with 39 reviews while SAP BW4HANA is ranked 7th in Data Warehouse with 34 reviews. Oracle Database Appliance is rated 8.0, while SAP BW4HANA is rated 7.4. The top reviewer of Oracle Database Appliance writes "Stable solution with opportunities for performance enhancement". On the other hand, the top reviewer of SAP BW4HANA writes "An easy-to-operate and administer tool that needs to consider revising its existing licensing cost". Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and IBM Db2 Warehouse, whereas SAP BW4HANA is most compared with Microsoft Azure Synapse Analytics, Snowflake, Amazon Redshift and SAP HANA. See our Oracle Database Appliance vs. SAP BW4HANA report.

    See our list of best Data Warehouse vendors.

    We monitor all 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.