We performed a comparison between Microsoft Azure Synapse Analytics 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."The most valuable aspect of this Microsoft Azure Synapse Analytics is its consolidation of technical support from Microsoft, and its ability to securely host large quantities of data within the cloud environment. The overall ability to manage and maintain Big Data within the cloud provides a heightened level of efficiency, reliability, and support from Microsoft. This results in a superior user experience and an increased level of value for the end user."
"The initial setup was really easy and straightforward."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"The initial setup is very simple."
"I think the most valuable component is that pipelines are built into it and then the feature that you can mirror a cosmos BB for analytics."
"The most valuable feature is that you can suspend the computer if it is not being used, which means that you don't incur costs."
"Synapse Analytics' best feature is its ability to process large files."
"The useability, the user interface, is very user-friendly."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"The functionality of the solution is excellent."
"The key advantages are Performance when processing Terabytes of data and scalability."
"The solution scales well on the cloud."
"It's very, very fast"
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"It has reduced a lot of reworking on maintaining indexes, partitions, etc."
"When I was trying to link services to an SFTP site it was not able to do all the possible encryption that I needed. They can improve by adding more encryption options."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"I am pretty sure that there are areas that need improvement but I just can think of them off the top of my head."
"The initial setup has a bit of a learning curve."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The support and price could improve."
"Microsoft Azure Synapse Analytics's pricing could be reduced."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"It needs a teaching web site with more training on third-party tools used for BI."
"The SQL Assistant is very basic. This tool can be improved for usability."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"It would help to make scaling easier with a reduced cost. "
"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."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"GUI of administrative tools is really outdated."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Teradata is rated 8.2. The top reviewer of Microsoft Azure Synapse Analytics writes "No competitors provide the entire solution to one place ". 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 Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Amazon Redshift, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Vertica. See our Microsoft Azure Synapse Analytics vs. Teradata 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.