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 platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"Data can be stored any way you want in the data warehouse."
"They are available on the Cloud, and the platform is very intuitive."
"I like the keynotes and their simplicity. Like other Microsoft products, Microsoft Azure Synapse Analytics is simple to understand and use."
"The solution has been working well overall."
"It's feature-rich. It has a wide range of features."
"Technical support is okay in terms of the help they provide."
"The extensibility and efficiency provided by their C++ SDK."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"The solution is quick, has good compression data, and is not expensive."
"Partition and join back to node are easy and simple for DBAs."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
 

Cons

"Integration with other products is an area that can be improved."
"One area that could be improved is the schema management."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"The performance needs to improve in future releases."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"Synapse Analytics needs to develop an automation framework because now you have to build a cache yourself. You have to build a pipeline in WhereScape, which does end-to-end pipeline automation well. Microsoft should come up with a framework to save people time. If they developed a tool like WhereScape, it would dramatically reduce development time."
"It needs strong support for social media, internet data, and native support for NoSQL."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"Very bad support, I would rate it two out of 10."
"Documentation has become much better, but can always use some improvement."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"It needs integration with multiple clouds."
"The integration with AI has room for improvement."
"They could improve on customer service."
"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."
"The geospatial functionality could be designed better."
 

Pricing and Cost Advice

"The solution is subscription-based. You can also pay to use the product as you go."
"The licensing fees for this solution are on a pay-per-use basis, and not very expensive."
"This solution starts at €1000.00 a month for just the basics and can go up to €300,000.00 per month for the fastest version."
"Microsoft Azure Synapse Analytics is a moderately priced solution."
"The price of Microsoft Azure Synapse Analytics can vary. Other solutions are typically fixed prices and a fixed cost regardless of usage, but this solution is based on usage or consumption."
"They are cost aggressive, and it integrates well with other Microsoft tools."
"This is a cost-effective product."
"We chose the serverless option for the database which has saved us a lot of money. Our costs are approximately £600 per month."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"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."
"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."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The solution is free and we pay for the storage."
"It's an expensive product"
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
report
Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
845,040 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.
845,040 professionals have used our research since 2012.