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."The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"The solution's best feature is its predictive analytics."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"The architecture, including compute and storage, is good."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"We can have the dedicated SQL up and running within 15 minutes."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"It maximizes cloud economics with Eon Mode by scaling cluster size to meet variable workload demands."
"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."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"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."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The most valuable feature of Vertica is the unmatchable database performance."
"The filing can be improved."
"The performance and data consistency need to be improved."
"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."
"I'm not entirely happy with the billing model. I'm not entirely happy with how the enterprise services are pretty expensive, but that's about it."
"The initial setup is complex."
"I am very sure that there are areas in need of improvement, but I can't recall what they are off the top of my head."
"We'd like the solution to have more analytics capability."
"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."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The integration of this solution with ODI could be improved."
"Support is an area where it could get better."
"We faced some challenges when trying to use the temporary tables feature."
"Suboptimal projection design causes queries to not scale linearly."
"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."
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.