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 solution handles single or complex items within a second."
"One central workspace to manage everything for your data warehouse including visualization."
"The initial setup was really easy and straightforward."
"The main advantage of using this solution is its ability to scale and handle very large amounts of data, in the petabyte range."
"I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch."
"The features we've found most valuable for data warehouses is extracting data, SSIS packages, and the DBs."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"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."
"Allows us to take volumes and process them at a very high speed."
"Eighty percent of the ETL operations have improved since implementing this solution."
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"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."
"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."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. "
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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 macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"While the solution is flexible, sometimes this works against the user."
"The cost of the solution has room for improvement."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"The solution does not support oriented scaling in the synapse."
"Comes with a pretty steep learning curve."
"More integration is needed to improve the product for the future."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"They could improve the integration and some of the features in the cloud version."
"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."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Documentation has become much better, but can always use some improvement."
"I have found that coding support could be simplified."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while Vertica is ranked 6th in Cloud Data Warehouse with 82 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Vertica is rated 8.4. 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 Analytics Platform System, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and MongoDB. 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.