Try our new research platform with insights from 80,000+ expert users

Microsoft Analytics Platform System vs OpenText Analytics Database (Vertica) vs Snowflake comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

As of September 2025, in the Data Warehouse category, the mindshare of Microsoft Analytics Platform System is 1.5%, up from 0.5% compared to the previous year. The mindshare of OpenText Analytics Database (Vertica) is 6.9%, down from 9.1% compared to the previous year. The mindshare of Snowflake is 12.5%, down from 18.7% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Warehouse Market Share Distribution
ProductMarket Share (%)
Snowflake12.5%
OpenText Analytics Database (Vertica)6.9%
Microsoft Analytics Platform System1.5%
Other79.1%
Data Warehouse
 

Featured Reviews

MahmoudMohamed1 - PeerSpot reviewer
Offers smooth data integration between systems, but requires better real-time analytics capabilities
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services. This lets us continue using private databases without paying additional licensing fees. Additionally, the license includes Analytics services and Power BI, which work on-premises, unlike most other technologies that require cloud solutions.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…
Snehasish Das - PeerSpot reviewer
Transformation in data querying speed with good migration capabilities
Snowflake is a data lake on the cloud where all processing happens in memory, resulting in very fast query responses. One key feature is the separation of compute and storage, which eliminates storage limitations. It also has tools for migrating data from legacy databases like Oracle. Its stability and efficiency enhance performance greatly. Tools in the AI/ML marketplace are readily available without needing development.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"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."
"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."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"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."
"I like that it's integrated with other Azure products."
"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. ​"
"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."
"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 uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"Allows us to take volumes and process them at a very high speed."
"It has improved my organization's functionality and performance."
"The initial setup was straightforward."
"The product's most important feature is unloading data to S3."
"The ability to share the data and the ability to scale up and down easily are the most valuable features. The concept of data sharing and data plumbing made it very easy to provide and share data. The ability to refresh your Dev or QA just by doing a clone is also valuable. It has the dynamic scale up and scale down feature. Development and deployment are much easier as compared to other platforms where you have to go through a lot of stuff. With a tool like DBT, you can do modeling and transformation within a single tool and deploy to Snowflake. It provides continuous deployment and continuous integration abilities. There is a separation of storage and compute, so you only get charged for your usage. You only pay for what you use. When we share the data downstream with business partners, we can specifically create compute for them, and we can charge back the business."
"Its speed and performance were the most valuable. Easy configuration of Snowflake in any cloud was also a benefit."
"My company wanted to have all our data in one single place and this what we use Snowflake for. Snowflake also allows us to build connectors to different data sources."
"It is a very well-distributed system. It has different data engines for different applications. Many applications can use different computational engines at the same time. In terms of data processing, the feeling was similar to working with a relational database but in a scalable way."
"I like the ability to work with a managed service on the cloud and that is easy to start with."
"The solution is easy to use."
"The features that I have found most valuable are the ease of use, the rapidness, how quickly the solution can be implemented, and of course that it's been very easy to move from the on-premise world to the Cloud world because Snowflake is based on SQL also."
 

Cons

"Microsoft Analytics Platform System could have better support."
"Releases of new products and functionality is never accompanied by associated documentation, training and resources that adequately explain the release."
"Functionality needs to be more up-to-date with competing products."
"​Hybrid environments are complex to manage."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
"The pricing model needs to be improved."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The biggest problem is the cost of cloud deployment."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"Support is an area where it could get better."
"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."
"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"It's not that flexible when compared to Oracle."
"There are some challenges with loading unstructured data and integrating some message queues or brokers. In one project, we had a problem connecting to one of the message queues and we had to take a different route altogether on Microsoft Azure."
"Product activation queries can't be changed while executing."
"They need to improve its ETL functionality so that Snowflake becomes an ETL product. Snowpipe can do some pipelines and data ingestion, but as compare to Talend, these functionalities are limited. The ETL feature is not good enough. Therefore, Snowflake can only be used as a database. You can't use it as an ETL tool, which is a limitation. We have spoken to the vendor, and they said they are working on it, but I'm not sure when they will bring it to production."
"We would like to see more security including more masking and more encryption at the database level."
"Availability is a problem."
"I don't know about GCP, if they have connected for GCP. If they don't, they should allow for it."
"These days, they are pushing users towards the GUI or graphical version. However, I am more familiar with the classic version. I'd like to continue to work with it using the older approach."
 

Pricing and Cost Advice

"Users have to pay extra for premium-level technical support."
"I rate Microsoft Analytics Platform System a seven out of ten for pricing."
"The initial price is lower than Oracle, but extensive use of SQL may lead to a higher total cost of ownership."
"We are currently paying $200,000 a year for all the different parts of the suite during an ingest model Microsoft now charges us $700,000 a year."
"The solution is relatively cost-effective."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"Vertica is an expensive tool."
"Read the fine print carefully."
"From a cost perspective, the software is less than most of its competitors."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"Pricing is approximately $US 50 per DB. Terabyte is around $US 50 per month."
"There is a separation of storage and compute, so you only pay for what you use."
"It's expensive."
"I have not been billed yet, but it should be less. I'm still running the trial version, but it seems to be less than Databricks."
"I believe that pricing is reasonable for this solution."
"Snowflake goes by credits. For a financial institution where you have 5,000 employees, monthly costs may run up to maybe $5,000 to $6,000. This is actually based on the usage. It is mostly the compute cost. Your computing cost is the variable that is actually based on your usage. It is pay-per-use. In a pay-per-use case, you won't be spending more than $6,000 to $7,000 a month. It is not more than that for a small or medium enterprise, and it may come down to $100K per year. Storage is very standard, which is $23 a terabyte. It is not much for any enterprise. If you have even 20 terabytes, you are not spending more than $400 per month, which may turn out to be $2,000 to $3,000 per annum."
"It is on a monthly basis. It is based on your usage. There are no additional costs from the point of the licensing fee. We do give some kind of evaluation to the customers about how much it is going to be. You can decide in Snowflake the virtual machine that you are using for customers. There are several kinds of virtual machines that you can use. It is similar to the clothing sizes: small to extra large. If you need more power in the coming month, you can decide in advance and take a more powerful machine. You can just select it from the platform. You can also decide which machine you want to take for extracting data."
"It is pay-as-you-go. Its cost is in the medium range."
report
Use our free recommendation engine to learn which Data Warehouse solutions are best for your needs.
867,299 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
No data available
Financial Services Firm
18%
Computer Software Company
16%
Manufacturing Company
9%
Comms Service Provider
5%
Financial Services Firm
20%
Computer Software Company
13%
Manufacturing Company
8%
Healthcare Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
By reviewers
Company SizeCount
Small Business4
Large Enterprise7
By reviewers
Company SizeCount
Small Business29
Midsize Enterprise23
Large Enterprise38
By reviewers
Company SizeCount
Small Business28
Midsize Enterprise20
Large Enterprise56
 

Questions from the Community

What do you like most about Microsoft Analytics Platform System?
We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any o...
What is your experience regarding pricing and costs for Microsoft Analytics Platform System?
It's not too confusing. It's based on features, and we don't have to buy additional licenses.
What needs improvement with Microsoft Analytics Platform System?
We need better real-time analytics capabilities. It's a bit challenging for us. Moreover, there are some permission l...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
What do you like most about Snowflake?
The best thing about Snowflake is its flexibility in changing warehouse sizes or computational power.
What is your experience regarding pricing and costs for Snowflake?
It is complicated to understand how requests impact warehouse size. Unlike competitors such as Microsoft and Databric...
What needs improvement with Snowflake?
Pricing is quite high for Snowflake Data Cloud, which is an area that could be improved. Snowflake Data Cloud is stil...
 

Also Known As

Microsoft APS, MS Analytics Platform System
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
Snowflake Computing, Snowflake Data Cloud
 

Overview

 

Sample Customers

Transport for London, E-Plus Mobilfunk GmbH & Co. KG, Prometeia, Tangerine, SSM Health Care, Service Corporation International
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Accordant Media, Adobe, Kixeye Inc., Revana, SOASTA, White Ops
Find out what your peers are saying about Snowflake Computing, Oracle, Teradata and others in Data Warehouse. Updated: August 2025.
867,299 professionals have used our research since 2012.