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."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."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"It is closely integrated with other products in the MS portfolio."
"I like that it's integrated with other Azure products."
"This is a well-integrated solution and that integration empowers results."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"I have found the solution to be scalable."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"The extensibility and efficiency provided by their C++ SDK."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"Allows us to take volumes and process them at a very high speed."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"The pricing model needs to be improved."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"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."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"Hybrid environments are complex to manage."
"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."
"They could improve on customer service."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"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."
"When it is about to reach the maximum storage capacity, it becomes slow."
"They could improve the integration and some of the features in the cloud version."
"Suboptimal projection design causes queries to not scale linearly."
"I believe the installation process could be streamlined."
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.