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."I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"The most valuable feature is the scalability."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"It's quite quick for querying, even with large datasets, and it's scalable. It's also flexible to use, so it's easy to update and get data quickly without wasting time."
"They are very reliable and cost-effective."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"It is a fantastic product; we are satisfied with its features and performance."
"The solution is quick, has good compression data, and is not expensive."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Its projections and encoding are excellent tools for tuning large volumes."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"Allows us to take volumes and process them at a very high speed."
"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. "
"Eighty percent of the ETL operations have improved since implementing this solution."
"The extensibility and efficiency provided by their C++ SDK."
"The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."
"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."
"The initial setup has a bit of a learning curve."
"I would like to see version control implemented into the data warehouse."
"Its stability is an issue. They have been releasing a version every six months to one year, which means that there are many versions available, and clients are not up to speed on the latest one that they're offering. From a stability point of view, they could do better. They're still upgrading their Synapse Analytics workspace, and it is not that stable. Its scalability can also be better."
"It's a complicated product."
"The product needs a tool that allows for work from a laptop instead of a browser."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"The biggest problem is the cost of cloud deployment."
"The integration of this solution with ODI could be improved."
"It needs integration with multiple clouds."
"It should provide a GUI interface for data management and tuning."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Suboptimal projection design causes queries to not scale linearly."
"Documentation has become much better, but can always use some improvement."
"Fact-to-fact joins on multi-billion record tables perform poorly."
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.