We changed our name from IT Central Station: Here's why

Microsoft Azure Synapse Analytics vs Vertica comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Vertica and other solutions. Updated: January 2022.
564,643 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on.""The solution has been working well overall.""I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works.""The most valuable feature is the level of processing power, and being able to complete tasks in parallel.""Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution.""The ability to scale out services on-demand and scale them down when they are not required is most valuable. You are in control of your expenditures, and you are also in control of the horsepower that you need. That's a major advantage.""Fills the gap between big data and classic data warehouses.""The architecture, including compute and storage, is good."

More Microsoft Azure Synapse Analytics Pros →

"Speed and resiliency are probably the best parts of this product.""Allows us to take volumes and process them at a very high speed.""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.""I have found the solution to be scalable.""For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments.""It has improved my organization's functionality and performance.""The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale.""It's the fastest database I have ever tested. That's the most important feature of Vertica."

More Vertica Pros →

Cons
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud.""When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options.""I would like to see them provide the ingestion of images.""Could have more connectors and better integration for Hadoop.""If I'm looking for something good in the cloud, I would want it to have better standard connectors.""I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head.""Integration with other products is an area that can be improved.""It's a complicated product."

More Microsoft Azure Synapse Analytics Cons →

"They could improve the integration and some of the features in the cloud version.""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.""The geospatial functionality could be designed better.""Support is an area where it could get better.""Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint.""When it is about to reach the maximum storage capacity, it becomes slow.""They could improve on customer service.""I have found that coding support could be simplified."

More Vertica Cons →

Pricing and Cost Advice
  • "All of the prices are available online."
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "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."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

  • "From a cost perspective, the software is less than most of its competitors."
  • "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 price could be cheaper and it is best to negotiate the price."
  • "The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
  • "The pricing could improve, it is a little expensive."
  • "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."
  • More Vertica Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    564,643 professionals have used our research since 2012.
    Questions from the Community
    Top Answer: 
    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… more »
    Top Answer: 
    Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer: 
    Fills the gap between big data and classic data warehouses.
    Top Answer: 
    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… more »
    Top Answer: 
    The pricing could improve, it is a little expensive.
    Top Answer: 
    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. I know that's… more »
    Ranking
    2nd
    Views
    26,962
    Comparisons
    19,760
    Reviews
    31
    Average Words per Review
    530
    Rating
    8.0
    5th
    Views
    9,414
    Comparisons
    6,807
    Reviews
    7
    Average Words per Review
    501
    Rating
    9.4
    Comparisons
    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
    Learn More
    Overview

    Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.

    Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.

    To learn more about Micro Focus Vertica Advanced Analytics, visit our website.

    Offer
    Learn more about Microsoft Azure Synapse Analytics
    Learn more about Vertica
    Sample Customers
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
    Top Industries
    REVIEWERS
    Computer Software Company21%
    Comms Service Provider16%
    Manufacturing Company11%
    Insurance Company11%
    VISITORS READING REVIEWS
    Computer Software Company27%
    Comms Service Provider18%
    Financial Services Firm6%
    Energy/Utilities Company6%
    REVIEWERS
    Computer Software Company21%
    Media Company18%
    Marketing Services Firm15%
    Comms Service Provider12%
    VISITORS READING REVIEWS
    Computer Software Company31%
    Comms Service Provider21%
    Financial Services Firm7%
    Manufacturing Company4%
    Company Size
    REVIEWERS
    Small Business33%
    Midsize Enterprise21%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business16%
    Midsize Enterprise13%
    Large Enterprise71%
    REVIEWERS
    Small Business31%
    Midsize Enterprise26%
    Large Enterprise44%
    Find out what your peers are saying about Microsoft Azure Synapse Analytics vs. Vertica and other solutions. Updated: January 2022.
    564,643 professionals have used our research since 2012.

    Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while Vertica is ranked 5th in Cloud Data Warehouse with 11 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Vertica is rated 9.2. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop and IBM Netezza Performance Server, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Apache Hadoop. See our Microsoft Azure Synapse Analytics vs. Vertica 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.