We performed a comparison between Apache Hadoop and Microsoft Analytics Platform System 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."The scalability of Apache Hadoop is very good."
"The best thing about this solution is that it is very powerful and very cheap."
"Since both Apache Hadoop and Amazon EC2 are elastic in nature, we can scale and expand on demand for a specific PoC, and scale down when it's done."
"As compared to Hive on MapReduce, Impala on MPP returns results of SQL queries in a fairly short amount of time, and is relatively fast when reading data into other platforms like R."
"Hadoop is designed to be scalable, so I don't think that it has limitations in regards to scalability."
"High throughput and low latency. We start with data mashing on Hive and finally use this for KPI visualization."
"I liked that Apache Hadoop was powerful, had a lot of tools, and the fact that it was free and community-developed."
"The most valuable features are powerful tools for ingestion, as data is in multiple systems."
"We leverage its capabilities for many applications. We can integrate with our databases, like Oracle, MySQL, or any other, using Microsoft Integration Services."
"Microsoft Analytics Platform System's most valuable feature is its ecosystems and seamless integration with other Microsoft reporting platforms and databases."
"I like that it's integrated with other Azure products."
"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 is a well-integrated solution and that integration empowers results."
"It is closely integrated with other products in the MS portfolio."
"This solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"Since it is an open-source product, there won't be much support."
"I think more of the solution needs to be focused around the panel processing and retrieval of data."
"Real-time data processing is weak. This solution is very difficult to run and implement."
"It needs better user interface (UI) functionalities."
"It would be helpful to have more information on how to best apply this solution to smaller organizations, with less data, and grow the data lake."
"It could be more user-friendly."
"In certain cases, the configurations for dealing with data skewness do not make any sense."
"In the next release, I would like to see Hive more responsive for smaller queries and to reduce the latency."
"Microsoft Analytics Platform System could have better support."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"Functionality needs to be more up-to-date with competing products."
"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."
"Hybrid environments are complex to manage."
"Machine learning and artificial intelligence capabilities need to be more friendly for beginning users."
"The flexibility of this solution needs to be improved because you cannot make changes at every one of the different steps."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Apache Hadoop is ranked 5th in Data Warehouse with 33 reviews while Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews. Apache Hadoop is rated 7.8, while Microsoft Analytics Platform System is rated 6.6. The top reviewer of Apache Hadoop writes "Handles huge data volumes and create your own workflows and tables but you need to have deeper knowledge". On the other hand, the top reviewer of Microsoft Analytics Platform System writes "Offers smooth data integration between systems, but requires better real-time analytics capabilities". Apache Hadoop is most compared with Azure Data Factory, Microsoft Azure Synapse Analytics, Oracle Exadata, Snowflake and Teradata, whereas Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, Teradata, IBM Netezza Performance Server and Snowflake. See our Apache Hadoop vs. Microsoft Analytics Platform System report.
See our list of best 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.