We performed a comparison between Microsoft Analytics Platform System and Vertica based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."This is a well-integrated solution and that integration empowers results."
"I like that it's integrated with other Azure products."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"Helps our customers to discover trends, which provides useful information based on their business."
"It is closely integrated with other products in the MS portfolio."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"Speed and resiliency are probably the best parts of this product."
"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."
"I have found the solution to be scalable."
"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."
"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."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"Functionality needs to be more up-to-date with competing products."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"Hybrid environments are complex to manage."
"Microsoft Analytics Platform System could have better support."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"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."
"It would be great if this were a managed service in AWS."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"The integration of this solution with ODI could be improved."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Support is an area where it could get better."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. Microsoft Analytics Platform System is rated 6.6, while Vertica is rated 8.2. The top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata. See our Microsoft Analytics Platform System vs. Vertica report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.