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."We use AWS Lake Formation typically for the data warehouse."
"The solution has many features that are applicable to events such as audits."
"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."
"The solution is quite good at handling analytics. It's done a good job at helping us centralize them."
"We value the appliance architecture with its “everything-in-a-box” highly standardized setup."
"The database is solid."
"The most valuable feature is the performance."
"The product is good value for money. It is a secure solution."
"The solution is simple to use and easy to maintain."
"We use the solution for our Java applications."
"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."
"For the end-users, it's not as user-friendly as it could be."
"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."
"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."
"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."
"We would like the ability to add more storage without having to upgrade to Oracle Exadata."
"It would be beneficial to have dedicated RAM included in the Oracle Database Appliance."
"The license cost could be cheaper, especially for long-term contracts."
"I would rate the scalability a seven out of ten. It has some problems. Databases are huge. This leads to needing more and more RAM and capacity resources, making it hard to scale. Because of this, we use Exadata. That's definitely a point for improvement."
"Oracle could improve its capacity for built-in visualization."
"Oracle Database Appliance could improve by having better integration."
"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."
"The setup is a bit complex."
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.
