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."What I found most valuable in Microsoft Azure Synapse Analytics is that it's native only for Azure, so you get better performance and there's no issue. To explain further, many different types of data come, in particular, structured and unstructured data. For audit purposes, there's also unstructured data, so the most important aspect is that with Microsoft Azure Synapse Analytics, you have the capability of using both technologies, meaning that you can use or mix structured and unstructured data which is important. This can also be done in Hadoop, and on other platforms, so you have everything in one place. You don't have to worry about how to manage both structured and unstructured data and where to store information. With Microsoft Azure Synapse Analytics, you can take care of everything, particularly in Azure. The solution also provides you with many features apart from analytics, for example, storage which makes it better."
"Scaling this solution is easy and the uptime is okay."
"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 most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"We can have the dedicated SQL up and running within 15 minutes."
"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 performance gains."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"It has improved my organization's functionality and performance."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"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."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"I like the projection feature, which increases query performance."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"The product needs a tool that allows for work from a laptop instead of a browser."
"It's a complicated product."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"One area for improvement could be better integration with Power BI, as well as data integration with BW."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"The only concern for us is the cost part. When it comes to the implementation and the support and maintenance, we see high-cost implications."
"We encountered data processing and transformation issues while working with Apache Spark languages for the product."
"Documentation has become much better, but can always use some improvement."
"The biggest problem is the cost of cloud deployment."
"The geospatial functionality could be designed better."
"It should provide a GUI interface for data management and tuning."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"Very bad support, I would rate it two out of 10."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"We faced some challenges when trying to use the temporary tables feature."
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 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 Dremio, 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.