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 the user experience because it is easy to make analyses, load different databases, and different resources. Our end users can do the analysis by themselves without IT supervising. This is a great aspect of the solution, it's better for our environment."
"They are very reliable and cost-effective."
"The solution's best feature is its predictive analytics."
"Synapse Analytics gives you information and reports in real-time."
"The solution offers strong scalability opportunities."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"The extensibility and efficiency provided by their C++ SDK."
"I enjoy the cybersecurity and backup features."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Allows us to take volumes and process them at a very high speed."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica's most outstanding features are the compression rates achieved and the speed of access of high volume data."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"One area that could be improved is the schema management."
"The filing can be improved."
"The initial setup is complex."
"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."
"The need to improve a little bit in terms of user-friendliness."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated."
"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."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Suboptimal projection design causes queries to not scale linearly."
"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."
"Documentation has become much better, but can always use some improvement."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"I have found that coding support could be simplified."
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 Amazon EMR, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and IBM Netezza Performance Server. 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.