AWS Lake Formation vs Oracle Database Appliance comparison

Amazon Web Services (AWS) and Oracle are both solutions in the Cloud Data Warehouse category. Additionally, 72% of Amazon Web Services (AWS) users are willing to recommend the solution, compared to 86% of Oracle users who would recommend it.

AWS Lake Formation

Read 11 AWS Lake Formation reviews

1,711 Views
1,660 Comparison Views

72% willing to recommend

Oracle Database Appliance

Read 45 Oracle Database Appliance reviews

1,606 Views
1,381 Comparison Views

86% willing to recommend

AWS Lake Formation

Oracle Database Appliance

Comparison Buyer's Guide

Download the report

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: July 2025).

Buyer's Guide

AWS Lake Formation vs. Oracle Database Appliance

July 2025

Download the complete report

Helped 865,384 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

AWS Lake Formation

Average Rating

7.8

Reviews Sentiment

5.7

Number of Reviews

Ranking in other categories

Cloud Data Warehouse (13th)

Oracle Database Appliance

Average Rating

8.0

Reviews Sentiment

6.6

Number of Reviews

Ranking in other categories

Data Warehouse (5th)

Featured Reviews

Ramesh Raghavan

US South Lead, Accenture AWS Business Group at Accenture

Centralized repository, offers various cataloging mechanisms for quick data retrieval but data governance capabilities could be better

There are a couple of areas for improvement with Lake Formation. One of the main challenges, especially when dealing with rich media content, like in MarTech (Marketing Technology) or ad agencies, is its versatility. Some clients feel that Lake Formation doesn’t meet their needs and they tend to prefer competitor products for those specific use cases. The second area for improvement is in data governance. Specifically, Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance. This includes managing the entire data lineage—where the data originated, how it moves, and where it’s currently stored. The visibility of the data as it evolves is crucial, and that’s where more advanced governance capabilities would be beneficial.

Read full review

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

Quotes from Members

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

Pros

"There is no doubt that this place exceeded my expectations with its incredible ambiance, attentive service, and mouthwatering menu."

"We use AWS Lake Formation typically for the data warehouse."

"It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services."

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

"The solution has many features that are applicable to events such as audits."

"I can easily move data from cold storage to regular storage."

"AWS Lake Formation works hand in hand with other products."

"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."

More AWS Lake Formation pros

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

"The solution is pretty automated, which takes out the possibility of human error."

"Oracle has good technical support."

"The most valuable feature is the performance."

"The product’s valuable feature is its capability to pre-configure and pre-install the settings."

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

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

"The Oracle database is able to get the data, process it, and return it to the company's CEO's and CFO's within a single day, and thus they are able to find out yesterday's P and L by today. It has drastically reduced the amount and time of processing from seven days to one day."

More Oracle Database Appliance pros

Cons

"AWS Lake Formation's pricing could be cheaper."

"Lake Formation could enhance its capabilities in audit logs, real-time monitoring, and advanced data governance."

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

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

"If I could improve AWS Lake Formation, I would add more integrations with SageMaker."

"For the end-users, it's not as user-friendly as it could be."

"You need to have data experience to use the product."

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

"The solution's initial setup is not easy."

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

"The product is quite complex to set up, initially. It would be ideal if it was simpler."

"There is room for improvement in better integration with third-party tools, such as Power BI or Redshift."

"Oracle could improve its capacity for built-in visualization."

"Oracle's product support is an area of concern where improvements are required."

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

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

More Oracle Database Appliance cons

Pricing and Cost Advice

"AWS Lake Formation is a bit expensive."

"The product is costly."

"Oracle’s pricing is ridiculously high."

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

"Oracle Database Appliance is a very expensive solution. If you have opted for the on-premises licenses from Oracle, then you have to pay yearly. If you have opted for the cloud subscriptions offered by Oracle, then you can pay either monthly or yearly."

"The solution's pricing is very high."

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

"I would rate the pricing a four on a scale of one (high price) to ten (low cost)."

"The price should be lower."

More Oracle Database Appliance pricing and cost advice

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

865,384 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

20%

Computer Software Company

12%

Manufacturing Company

Media Company

Financial Services Firm

24%

Computer Software Company

11%

Manufacturing Company

Government

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

Questions from the Community

What do you like most about AWS Lake Formation?

It is seamlessly integrated within the AWS ecosystem, making it straightforward to manage access patterns for AWS-native services.

See all answers

What is your experience regarding pricing and costs for AWS Lake Formation?

The pricing is expensive compared to OpenStack, but cheaper than other cloud environments. It's middle-of-the-road for regular storage yet very cost-effective when using Amazon Glacier for data.

See all answers

What needs improvement with AWS Lake Formation?

If I could improve AWS Lake Formation, I would add more integrations with SageMaker. I would have built-in functions that provide statistics for the data when using the GUI, such as SageMaker Insig...

See all answers

What do you like most about Oracle Database Appliance?

Oracle Database Appliance provides high stability.

See all answers

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

While I'm somewhat familiar with standard licensing, pricing isn't really my area of expertise. However, Oracle is on the higher end of the pricing spectrum, along with SAP.

See all answers

What needs improvement with Oracle Database Appliance?

For the cloud version, there could be better storage options or more storage for lower prices. However, for on-premises, this is not possible because you have physical disks. In the cloud, more opt...

See all answers

Comparisons

Snowflake vs AWS Lake Formation

Compared 29% of the time

Azure Data Factory vs AWS Lake Formation

Compared 21% of the time

Amazon Redshift vs AWS Lake Formation

Compared 20% of the time

BigQuery vs AWS Lake Formation

Compared 11% of the time

Microsoft Azure Synapse Analytics vs AWS Lake Formation

Compared 7% of the time

More AWS Lake Formation Competitors

Oracle Exadata vs Oracle Database Appliance

Compared 47% of the time

VMware Tanzu Data Solutions vs Oracle Database Appliance

Compared 12% of the time

Dell PowerStore vs Oracle Database Appliance

Compared 8% of the time

Actian Ingres vs Oracle Database Appliance

Compared 6% of the time

Teradata vs Oracle Database Appliance

Compared 6% of the time

More Oracle Database Appliance Competitors

Product Reports

Buyer's Guide

AWS Lake Formation

August 2025

Download AWS Lake Formation product report

Buyer's Guide

Oracle Database Appliance

August 2025

Download Oracle Database Appliance product report

Also Known As

No data available

X5-2

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.

Amazon Web Services (AWS)

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

Sample Customers

bp, Cerner, Expedia, Finra, HESS, intuit, Kellog's, Philips, TIME, workday

LifeLock, Incarlopsa, Al Yusur Industrial Contracting

Buyer's Guide

AWS Lake Formation vs. Oracle Database Appliance

July 2025

Free Report: AWS Lake Formation vs. Oracle Database Appliance

Find out what your peers are saying about AWS Lake Formation vs. Oracle Database Appliance and other solutions. Updated: July 2025.

DOWNLOAD NOW

865,384 professionals have used our research since 2012.

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.