"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 solution has been working well overall."
"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 the level of processing power, and being able to complete tasks in parallel."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"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."
"Fills the gap between big data and classic data warehouses."
"The architecture, including compute and storage, is good."
"Speed and resiliency are probably the best parts of this product."
"Allows us to take volumes and process them at a very high speed."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"I have found the solution to be scalable."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"It has improved my organization's functionality and performance."
"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."
"It's the fastest database I have ever tested. That's the most important feature of Vertica."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"I would like to see them provide the ingestion of images."
"Could have more connectors and better integration for Hadoop."
"If I'm looking for something good in the cloud, I would want it to have better standard connectors."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"Integration with other products is an area that can be improved."
"It's a complicated product."
"They could improve the integration and some of the features in the cloud version."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"The geospatial functionality could be designed better."
"Support is an area where it could get better."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"When it is about to reach the maximum storage capacity, it becomes slow."
"They could improve on customer service."
"I have found that coding support could be simplified."
Azure SQL Data Warehouse is a Fast, flexible, and secure analytics platform for the enterprise. Azure SQL Data Warehouse lets you independently scale compute and storage, while pausing and resuming your data warehouse within minutes through a massively parallel processing architecture designed for the cloud. Seamlessly create your hub for analytics along with native connectivity with data integration and visualization services, all while using your existing SQL and BI skills.
Micro Focus Vertica is the most advanced SQL database analytics portfolio built from the very first line of code to address the most demanding Big Data analytics initiatives. Micro Focus Vertica delivers speed without compromise, scale without limits, and the broadest range of consumption models. Choose Vertica on premise, on demand, in the cloud, or on Hadoop. With support for all leading BI and visualization tools, open source technologies like Hadoop and R, and built-in analytical functions, Vertica helps you derive more value from your Enterprise Data Warehouse and data lakes and get to market faster with your analytics initiatives.
To learn more about Micro Focus Vertica Advanced Analytics, visit our website.
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 34 reviews while Vertica is ranked 5th in Cloud Data Warehouse with 11 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Vertica is rated 9.2. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Vertica writes "Superior performance in speed and resilience makes this a very good warehousing solution". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, SAP BW4HANA, Apache Hadoop and IBM Netezza Performance Server, whereas Vertica is most compared with Snowflake, Amazon Redshift, Teradata, SQL Server and Apache Hadoop. See our Microsoft Azure Synapse Analytics vs. Vertica report.
See our list of best Cloud 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.