No more typing reviews! Try our Samantha, our new voice AI agent.

Microsoft Azure DocumentDB vs OpenText Analytics Database (Vertica) comparison

Why PeerSpot?
 

Comparison Buyer's Guide

Executive Summary

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

Microsoft Azure DocumentDB
Average Rating
8.8
Reviews Sentiment
5.4
Number of Reviews
6
Ranking in other categories
Database as a Service (DBaaS) (13th), NoSQL Databases (15th)
OpenText Analytics Database...
Average Rating
8.2
Reviews Sentiment
6.9
Number of Reviews
90
Ranking in other categories
Data Warehouse (6th), Cloud Data Warehouse (11th)
 

Featured Reviews

Anish-Anand - PeerSpot reviewer
Performance Test Professional at Happiest Minds
Reporting for global banking stakeholders has become seamless and supports diverse visual formats
All Microsoft applications, whether database or analytics, are a little costlier compared to Google products, and this is a barrier that needs to be crossed so that all its applications become more affordable. For example, startups typically go for free tools. Microsoft should offer these products for free to startups or perhaps free for the first year or two years, so that startups can use these applications, and once they grow bigger and have larger revenue, they can purchase it at a reasonable cost. All Microsoft tools need to cut down on their price and have a better strategy around pricing for the masses. If you sell only to ten customers, your revenue is lesser, but if you give something for free to some customers, two years down the line they will purchase it. Microsoft Azure DocumentDB still needs the ability to connect to other analytics easily without any additional integrator. For example, if I can connect to Google Analytics or other analytics that are not Microsoft tools using this database, that would be a good source of revenue. If I have already purchased Google Analytics in my company and I need a database, and Microsoft Azure DocumentDB can very easily connect or integrate to my Google Analytics, I would not have to think twice. Cross-company application connectivity is something that needs to be worked on.
JN
consultant at tcs
Data warehousing has transformed reporting performance and now delivers near real-time insights
OpenText Analytics Database (Vertica) is a very powerful analytic database, but like any platform, there are areas where it can improve to make daily work even smoother. Better cloud-native experience is one area for improvement. OpenText Analytics Database (Vertica) was originally designed as an on-premises analytic database and later moved to cloud. Improvement opportunities include more seamless cloud-native features such as auto-scaling, serverless options, and easier cluster management. Competitors such as Snowflake and BigQuery provide more fully managed experiences. Easier UI is another area for improvement. Most administration is currently done by SQL and command line tools. An improvement opportunity would be a more modern web UI for monitoring, workload management, and troubleshooting. Faster ecosystem and community growth is needed. In short, OpenText Analytics Database (Vertica) could improve in areas such as cloud-native capability, modern UI for administration, stronger real-time streaming integration, and growing its ecosystem and community. These enhancements would make it easier to manage and adopt compared to newer cloud-first analytic platforms. From a day-to-day operational perspective, there are a few areas where OpenText Analytics Database (Vertica) could improve to make our work smoother. Smarter automatic projection management is needed with more intelligence, auto projection creation, automatic optimization, and reduced manual testing with better workload management. Right now, monitoring queries often requires system tables and manual analysis. Troubleshooting slow queries takes time. A modern real-time dashboard showing query bottlenecks and resource users would enable quick detection. The impact could be faster issue resolution and less time spent debugging performance. Storage native interaction with modern data tools is also important. In short, from a day-to-day perspective, improvements in automatic projection optimization, better workload monitoring dashboard, easier schema evolution, and stronger modern tool integration would significantly reduce manual tuning effort and improve developer productivity. While OpenText Analytics Database (Vertica) is very powerful, these enhancements would make it more efficient for the analytics team.

Quotes from Members

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

Pros

"We have immeasurable benefits mainly in reduced operational effort and the time saved on routine database administration."
"Microsoft Azure DocumentDB is never down because of its scalability feature."
"One of the most appreciated aspects of Microsoft Azure DocumentDB is the elastic scaling feature which has significantly helped manage business growth for two customers who have employed it, experiencing a dramatic rise in improvement."
"The most beneficial features of Microsoft Azure DocumentDB that I noticed is that it appeared to be straightforward, it was ease of use, it was not complicated compared to some of the other tools that are out there, the teams were familiar with it, and it integrated well with other Microsoft products."
"Microsoft Azure DocumentDB has positively impacted my organization by allowing us to reduce database costs by 30%."
"The most valuable feature of Microsoft Azure DocumentDB in my daily work is the speed."
"The extensibility and efficiency provided by their C++ SDK."
"OpenText Analytics Database (Vertica) has improved our reporting performance by nearly 90 percent, reduced ETL processing time by more than half, and saved around 70 percent in storage through compression."
"It has improved my organization's functionality and performance."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"I enjoy the cybersecurity and backup features."
"We are using Vertica because it is a fast and reliable data warehousing tool and provides us a very good data compression ratio."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
 

Cons

"Microsoft Azure DocumentDB could be improved with more straightforward cost and performance optimization guidance, especially for understanding resource usage and selecting the right configuration for different workloads."
"All Microsoft applications, whether database or analytics, are a little costlier compared to Google products, and this is a barrier that needs to be crossed so that all its applications become more affordable."
"Maybe in the future, I would like to see relationships between one document set and another document set."
"It is a bit expensive, especially concerning the elastic scale."
"Microsoft gives you the base functionality which you can grow from, but some tools perhaps go a bit further because that is their only focus or niche."
"Very bad support, I would rate it two out of 10."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Stability, scalability (3 node Community Edition) and backup/restore all need to be worked on."
"I'm concerned that HP Enterprise has sold their software business, and worry about future investment to enhance predictive/machine-learning capabilities."
"Customer Service: It was a green field solution, and getting quick customer service was a challenge."
"The product could be less expensive and could benefit from a better marketing strategy."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"Machine learning implementations."
 

Pricing and Cost Advice

Information not available
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The solution is free and we pay for the storage."
"I am aware that we have licensed it, but I have no knowledge of its cost."
"The price could be cheaper and it is best to negotiate the price."
"It is fast to purchase through the AWS Marketplace."
"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."
"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."
"From a cost perspective, the software is less than most of its competitors."
report
Use our free recommendation engine to learn which NoSQL Databases solutions are best for your needs.
915,341 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
14%
Outsourcing Company
14%
Manufacturing Company
10%
Comms Service Provider
8%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise43
 

Questions from the Community

What needs improvement with Microsoft Azure DocumentDB?
I think perhaps in some aspects the documentation could be better, as well as the integration with Azure Backup to improve Microsoft Azure DocumentDB.
What is your primary use case for Microsoft Azure DocumentDB?
My main use case for Microsoft Azure DocumentDB is when we modernize applications that use MongoDB on-premise and move them to Azure using DocumentDB. By doing this migration to Microsoft Azure Doc...
What is your experience regarding pricing and costs for Vertica?
My experience with pricing, setup cost, and licensing is limited because the organization handled the licensing and pricing as well as the cost setup.
What needs improvement with Vertica?
OpenText Analytics Database (Vertica) is already doing great. There could be a community which could have been much more advanced and more people can be engaged so that any kind of questions, queri...
What is your primary use case for Vertica?
The main use case for OpenText Analytics Database (Vertica) is that we have the Hive and a Hadoop layer for data availability, and Vertica serves as a big data solution. Within a Hive table, OpenTe...
 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Information Not Available
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft, MongoDB, Redis and others in NoSQL Databases. Updated: September 2026.
915,341 professionals have used our research since 2012.