Try our new research platform with insights from 80,000+ expert users

Microsoft Azure Synapse Analytics vs Vertica comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Dec 18, 2024

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 Synapse Ana...
Ranking in Cloud Data Warehouse
2nd
Average Rating
8.0
Reviews Sentiment
7.0
Number of Reviews
92
Ranking in other categories
No ranking in other categories
Vertica
Ranking in Cloud Data Warehouse
11th
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th)
 

Mindshare comparison

As of April 2025, in the Cloud Data Warehouse category, the mindshare of Microsoft Azure Synapse Analytics is 6.5%, down from 10.2% compared to the previous year. The mindshare of Vertica is 5.6%, up from 5.2% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Cloud Data Warehouse
 

Featured Reviews

Renee Hoon - PeerSpot reviewer
Scalable performance tuning and optimization for finance and supply chain jobs
We run our finance and supply chain jobs using SQL BW, and we visualize our data loads on Power BI. We are using SQL Data Warehouse for data warehousing In terms of cost savings, we don't need specialization in skills as advanced as Teradata. We used to pay extensive licensing fees for Teradata,…
T Venkatesh - PeerSpot reviewer
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…

Quotes from Members

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

Pros

"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"It's user-friendly and has a good dashboard."
"The most important feature for me is the integration with PolyBase."
"The best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it."
"One of the most valuable features of this solution is its ability to integrate well with other services offered by Azure."
"It's feature-rich. It has a wide range of features."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"-"
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Speed and resiliency are probably the best parts of this product."
"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 performance is very good and the aggregate records are fast."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Eighty percent of the ETL operations have improved since implementing this solution."
"It has improved my organization's functionality and performance."
 

Cons

"The security performance and cost are the two things that needs improvement."
"Adding more transformations and plugins to the solution is very important."
"While the solution is flexible, sometimes this works against the user."
"If Microsoft Azure Synapse Analytics could run on a laptop as a Docker image, it would allow for work without needing an online connection."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"Unfortunately, we have had some issues with the dashboard reporting. Sometimes, the data for specific periods would just appear blank on the dashboard. To investigate this, we worked with a Microsoft incident agent and it turned out to be a result of bugs in the platform when dealing with specific types of queries in Azure Data Factory."
"I would like to see more ready-to-use products from Synapse. Right now, everything seems a bit futuristic without much modern use."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"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."
"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"It should provide a GUI interface for data management and tuning."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
 

Pricing and Cost Advice

"This is a cost-effective product."
"It goes by the usage, and there are some limits. Synapse goes by particular pricing, and it is expensive. Both Azure Synapse Analytics and Snowflake are pretty expensive. They don't have standard pricing. They deal with each customer differently."
"I don't know about the price, but I'm trying to get a sense of the cost."
"Our license is very expensive"
"There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
"The computer and storage costs are totally separate which allows you to work independently or manage costs."
"Microsoft's pricing is relatively high, and it varies according to the extent of our usage. The pricing is directly tied to our consumption. This decision is ultimately a business choice."
"The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"The pricing for this solution is very reasonable compared to other vendors."
"The price could be cheaper and it is best to negotiate the price."
"The solution is free and we pay for the storage."
"From a cost perspective, the software is less than most of its competitors."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"It's an expensive product"
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Educational Organization
52%
Computer Software Company
5%
Manufacturing Company
5%
Financial Services Firm
5%
Financial Services Firm
20%
Computer Software Company
18%
Manufacturing Company
8%
Real Estate/Law Firm
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Amazon Redshift compare with Microsoft Azure Synapse Analytics?
Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different dat...
What do you like most about Microsoft Azure Synapse Analytics?
The product is easy to use, and anybody can easily migrate to advanced DB.
What is your experience regarding pricing and costs for Microsoft Azure Synapse Analytics?
We use an enterprise-level subscription for Microsoft Azure Synapse Analytics. I would rate our satisfaction with the price around five, as I have not focused much on cost aspects presently.
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.
 

Also Known As

Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Vertica and other solutions. Updated: February 2025.
844,944 professionals have used our research since 2012.