AWS Lake Formation vs OpenText Analytics Database (Vertica) comparison

AWS Lake Formation vs. OpenText Analytics Database (Vertica)

Download the complete report

Helped 858,435 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

Ranking in Cloud Data Warehouse

13th

Average Rating

7.6

Reviews Sentiment

6.9

Number of Reviews

Ranking in other categories

No ranking in other categories

OpenText Analytics Database...

Ranking in Cloud Data Warehouse

11th

Average Rating

8.2

Reviews Sentiment

7.0

Number of Reviews

Ranking in other categories

Data Warehouse (8th)

Mindshare comparison

As of June 2025, in the Cloud Data Warehouse category, the mindshare of AWS Lake Formation is 5.5%, up from 5.6% compared to the previous year. The mindshare of OpenText Analytics Database (Vertica) is 5.7%, up from 5.4% compared to the previous year. It is calculated based on PeerSpot user engagement data.

Cloud Data Warehouse

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

T Venkatesh

Deputy Manager at ICICIBANK Ltd

Processes query faster through multiple systems simultaneously, but it could support different data types

We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

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

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

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

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

"AWS Lake Formation lets you see all your data and tables on one screen."

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

"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."

"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"

"Its projections and encoding are excellent tools for tuning large volumes."

"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."

"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."

"Initiate on one node, and the RPM propagates automatically to all other nodes. "

"DBAs don’t need to add a partition every month/quarter like with other DBs."

"It has improved my organization's functionality and performance."

More OpenText Analytics Database (Vertica) pros

Cons

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

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

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

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

"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."

"Limitations in group by projections is where I would like to see an improvement."

"It would be great if this were a managed service in AWS."

"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."

"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."

"In our company, we have faced difficulties in scaling the solution for certain use cases."

"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."

"Pricing could be more competitive."

More OpenText Analytics Database (Vertica) cons

Pricing and Cost Advice

"AWS Lake Formation is a bit expensive."

"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."

"The solution is free and we pay for the storage."

"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."

"From a cost perspective, the software is less than most of its competitors."

"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."

"The pricing for this solution is very reasonable compared to other vendors."

"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October)."

"Vertica is an expensive tool."

More OpenText Analytics Database (Vertica) 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

858,435 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Financial Services Firm

21%

Computer Software Company

13%

Manufacturing Company

Government

Financial Services Firm

19%

Computer Software Company

18%

Manufacturing Company

University

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.

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.

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

What do you like most about Vertica?

Vertica is easy to use and provides really high performance, stability, and scalability.

What is your experience regarding pricing and costs for Vertica?

The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.

What needs improvement with Vertica?

The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.

Snowflake vs AWS Lake Formation

Comparisons

Compared 33% of the time

Azure Data Factory vs AWS Lake Formation

Compared 20% of the time

Amazon Redshift vs AWS Lake Formation

Compared 18% of the time

Microsoft Azure Synapse Analytics vs AWS Lake Formation

Compared 10% of the time

BigQuery vs AWS Lake Formation

Compared 8% of the time

More AWS Lake Formation Competitors

SQL Server vs OpenText Analytics Database (Vertica)

Compared 14% of the time

Teradata vs OpenText Analytics Database (Vertica)

Compared 12% of the time

Snowflake vs OpenText Analytics Database (Vertica)

Compared 9% of the time

BigQuery vs OpenText Analytics Database (Vertica)

Compared 9% of the time

Oracle Exadata vs OpenText Analytics Database (Vertica)

Compared 8% of the time

More OpenText Analytics Database (Vertica) Competitors

Product Reports

AWS Lake Formation

Download AWS Lake Formation product report

OpenText Analytics Database (Vertica)

Download OpenText Analytics Database (Vertica) product report

OpenText Analytics Database (Vertica) report

Also Known As

No data available

Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand

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)

OpenText Analytics Database Vertica is known for its fast data loading and efficient query processing, providing scalability and user-friendliness with a low cost per TB. It supports large data volumes with OLAP, clustering, and parallel ingestion capabilities.

OpenText Analytics Database Vertica is designed to handle substantial data volumes with a focus on speed and efficient storage through its columnar architecture. It offers advanced performance features like workload isolation and compression, ensuring flexibility and high availability. The database is optimized for scalable data management, supporting data scientists and analysts with real-time reporting and analytics. Its architecture is built to facilitate hybrid deployments on-premises or within cloud environments, integrating seamlessly with business intelligence tools like Tableau. However, challenges such as improved transactional capabilities, optimized delete processes, and better real-time loading need addressing.

What features define OpenText Analytics Database Vertica?

Fast Data Loading: Quickly ingests large data volumes.
Columnar Storage: Optimizes storage efficiency and speed.
OLAP Support: Provides robust analytics capabilities.
Advanced Compression: Enhances storage efficiency and performance.
Parallel Data Ingestion: Enables faster data processing.
Fault Tolerance: Ensures high availability and reliability.

What benefits should users expect?

Cost Efficiency: Low cost per TB is advantageous.
Scalability: Accommodates growing data needs seamlessly.
Integration Flexibility: Works well with BI tools like Tableau.
Real-Time Reporting: Delivers immediate insights for decision-making.

OpenText Analytics Database Vertica's implementation spans industries such as finance, healthcare, and telecommunications. It serves as a central data warehouse offering scalable management, high-speed processing, and geospatial functions. Companies benefit from its capacity to integrate machine learning and operational reporting, enhancing analytical capabilities.

OpenText

Sample Customers

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

Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.

AWS Lake Formation vs. OpenText Analytics Database (Vertica)