We performed a comparison between Microsoft Azure Synapse Analytics and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."Our primary use case is for gathering data and analytics. We provide insights into vehicle data. We gather millions of records per second and we have various millions of vehicles running across."
"The solution handles single or complex items within a second."
"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."
"The MPP (Massively Parallel Processing) architecture helps to make things a lot faster."
"Technical support is okay in terms of the help they provide."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"Fills the gap between big data and classic data warehouses."
"One central workspace to manage everything for your data warehouse including visualization."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"Partition and join back to node are easy and simple for DBAs."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"I enjoy the cybersecurity and backup features."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"We'd, of course, always like to pay less for the service if we can."
"We'd like the solution to have more analytics capability."
"Non-structured data is unavailable with this product."
"The support and price could improve."
"Comes with a pretty steep learning curve."
"Microsoft Azure Synapse Analytics could improve the section in the solution where you can implement the Python Spark pipelines, it's not the same as in Databricks which would be better."
"Integration with other products is an area that can be improved."
"This is a young product in transition to the cloud and it needs more work before it is both settled as a product and competitive in the market."
"Limitations in group by projections is where I would like to see an improvement."
"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."
"The geospatial functionality could be designed better."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"The integration of this solution with ODI could be improved."
"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."
"They could improve the integration and some of the features in the cloud version."
"Support is an area where it could get better."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Vertica is ranked 7th in Cloud Data Warehouse with 83 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Vertica is rated 8.2. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Microsoft Parallel Data Warehouse, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and SingleStore. See our Microsoft Azure Synapse Analytics vs. Vertica report.
See our list of best Cloud Data Warehouse vendors and best 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.