AWS Lake Formation vs Oracle Database Appliance comparison

Cancel
You must select at least 2 products to compare!
Amazon Web Services (AWS) Logo
5,000 views|4,178 comparisons
75% willing to recommend
Oracle Logo
2,939 views|2,126 comparisons
87% willing to recommend
Comparison Buyer's Guide
Executive Summary

We performed a comparison between AWS Lake Formation and Oracle Database Appliance 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 AWS Lake Formation vs. Oracle Database Appliance Report (Updated: March 2024).
770,292 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 has many features that are applicable to events such as audits.""The solution is quite good at handling analytics. It's done a good job at helping us centralize them.""The most important advantage in using AWS Lake Formation is its ability to connect the data lake to the other technologies in AWS. This is what I advise my clients.""It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.""We use AWS Lake Formation typically for the data warehouse."

More AWS Lake Formation Pros →

"The tool is a specific and effective system. I am impressed with its usability.""The performance due to the all-flash of ODA is very nice.""The solution is simple to use and easy to maintain.""The most valuable feature of the solution is the ability to combine all the data without the need for additional devices.""We use the solution for our Java applications.""The main feature is the management and manageability of the tool. We can create a VM on a laptop within a couple of clicks.""The product is very light.""Oracle has good technical support."

More Oracle Database Appliance Pros →

Cons
"It falls short when it comes to more granular access control, such as cell-level or row-level entitlements which is a significant drawback for organizations that require precise control over who can access specific rows of data.""AWS Lake Formation's pricing could be cheaper.""In our experience what could be improved are not the support, performance or monitoring, but at a managerial level, the very expensive professional services of AWS. This could be an area of improvement for them. It's too expensive to acquire their support.""For the end-users, it's not as user-friendly as it could be.""The solution could make improvements around orchestration and doing some automation stuff on AWS front automation. It would be useful if we could use automation to build images and use hardened images which are CIS compliant."

More AWS Lake Formation 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.""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.""Virtualization needs improvement. It's not easy to back up the virtual machines in the Oracle VM architecture. I would also like to see native support for Veeam Backup Software.""Oracle Database Appliance patching comes out two to three months after the regular patching cycle.""Since we don't have the room to scale up, I rate this solution a six out of ten for scalability.""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.""I would be happy to see the Oracle Auto Service Request (ASR) pre-installed in it instead of installing it in a separate machine."

More Oracle Database Appliance Cons →

Pricing and Cost Advice
  • "AWS Lake Formation is a bit expensive."
  • More AWS Lake Formation 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 →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    770,292 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.
    Top Answer:There are significant challenges when dealing with external applications, and vendors, or pursuing a hybrid cloud strategy because AWS Lake Formation is specific to AWS and does not integrate… more »
    Top Answer:Oracle Database Appliance provides high stability.
    Top Answer:On a scale from 1 to 10, where 1 is cheap and 10 is expensive, I rate the solution's pricing 7.5 or 8 out of 10.
    Top Answer:The solution’s pricing could be improved.
    Ranking
    12th
    Views
    5,000
    Comparisons
    4,178
    Reviews
    1
    Average Words per Review
    578
    Rating
    6.0
    6th
    out of 35 in Data Warehouse
    Views
    2,939
    Comparisons
    2,126
    Reviews
    11
    Average Words per Review
    353
    Rating
    7.8
    Comparisons
    Also Known As
    X5-2
    Learn More
    Overview

    AWS Lake Formation is a service that makes it easy to set up a secure data lake in days. A data lake is a centralized, curated, and secured repository that stores all your data, both in its original form and prepared for analysis.

    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.

    Sample Customers
    bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday
    LifeLock, Incarlopsa, Al Yusur Industrial Contracting
    Top Industries
    VISITORS READING REVIEWS
    Financial Services Firm21%
    Computer Software Company13%
    Manufacturing Company8%
    Government5%
    REVIEWERS
    Financial Services Firm32%
    Comms Service Provider21%
    Retailer11%
    Transportation Company5%
    VISITORS READING REVIEWS
    Financial Services Firm29%
    Computer Software Company11%
    Government8%
    Manufacturing Company6%
    Company Size
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise10%
    Large Enterprise73%
    REVIEWERS
    Small Business42%
    Midsize Enterprise21%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business15%
    Midsize Enterprise11%
    Large Enterprise74%
    Buyer's Guide
    AWS Lake Formation vs. Oracle Database Appliance
    March 2024
    Find out what your peers are saying about AWS Lake Formation vs. Oracle Database Appliance and other solutions. Updated: March 2024.
    770,292 professionals have used our research since 2012.

    AWS Lake Formation is ranked 12th in Cloud Data Warehouse with 5 reviews while Oracle Database Appliance is ranked 6th in Data Warehouse with 40 reviews. AWS Lake Formation is rated 7.6, while Oracle Database Appliance is rated 8.0. The top reviewer of AWS Lake Formation writes "Strategically aligning data management in a multi-cloud environment with significant reporting challenges". On the other hand, the top reviewer of Oracle Database Appliance writes "Simplifies database management tasks and provides high availability and disaster recovery". AWS Lake Formation is most compared with Snowflake, Azure Data Factory, Amazon Redshift, Microsoft Azure Synapse Analytics and BigQuery, whereas Oracle Database Appliance is most compared with Oracle Exadata, VMware Tanzu Greenplum, Dremio, Actian Ingres and Vertica. See our AWS Lake Formation vs. Oracle Database Appliance 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.