We performed a comparison between Microsoft Analytics Platform System and Teradata 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 solution will connect to any database, you can combine databases, and you can create a cube or tabular model."
"The Cube Solution is quite different when compared to the rest of the competition and has unique functionality for advanced analytics."
"I like that it's integrated with other Azure products."
"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."
"Helps our customers to discover trends, which provides useful information based on their business."
"This is a well-integrated solution and that integration empowers results."
"It is closely integrated with other products in the MS portfolio."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"The most valuable feature of Teradata is security. It runs on Unix and Linux platforms which provide better security."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"The most valuable feature of Teradata is the quick processing of large data."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"Teradata's pretty fast."
"We need better real-time analytics capabilities. It's a bit challenging for us."
"The pricing model needs to be improved."
"Hybrid environments are complex to manage."
"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."
"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."
"I think the biggest problem with the product is that it does a data ingest model, which is very expensive."
"The increasing volumes of data demand more and more performance."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata is an expensive tool. Like, if you're already using Microsoft products like Windows, they'll market all their products together. And with the rise of cloud technologies, companies will adopt solutions that offer them some privileges or facilities. Similar to how SAP does it in the market, so do Microsoft and other companies. Even Oracle and other such tools are quite commonly seen compared to Teradata's competitors in everyday solutions."
"Teradata hardly supports unstructured data or semi-structured data"
"The cloud is the new challenge and the new opportunity."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
More Microsoft Analytics Platform System Pricing and Cost Advice →
Microsoft Analytics Platform System is ranked 17th in Data Warehouse with 9 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Microsoft Analytics Platform System is rated 6.6, while Teradata 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 Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Microsoft Analytics Platform System is most compared with Microsoft Azure Synapse Analytics, IBM Netezza Performance Server and Snowflake, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Microsoft Analytics Platform System vs. Teradata 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.