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."Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"Azure elasticity allows us to scale as much as we want, and it is pay-as-you-go, so we can scale up as we need to."
"Data can be stored any way you want in the data warehouse."
"One central workspace to manage everything for your data warehouse including visualization."
"We can have the dedicated SQL up and running within 15 minutes."
"It's feature-rich. It has a wide range of features."
"The solution handles single or complex items within a second."
"The best thing about it is that it has integration at multiple places. It can talk to more than 90 types of data sources, which is one good thing about it."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"The most valuable features are the Shared-nothing architecture and data protection functionality."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"Teradata's best feature is its speed with historical data."
"The initial setup was straightforward."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it."
"The filing can be improved."
"Right now, we are really struggling with the performance. it's not as good as we had hoped."
"It would be of interest to improve things like the web service integration and availability in terms of being easy to create internal web services in the database."
"In the future, Microsoft Azure Synapse Analytics has the potential to enhance its capabilities by expanding its connectors, specifically with regard to Oracle solutions, such as operating systems. This would involve a comprehensive approach to adding more connectors for both data input and consumption purposes. By doing so, Microsoft Azure Synapse Analytics would be better equipped to meet the diverse needs of its users and achieve greater efficiency in its performance. The provision of more connectors is definitely a crucial area that needs improvement."
"I'd like to see part of the service de-coupled."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"It needs a teaching web site with more training on third-party tools used for BI."
"The increasing volumes of data demand more and more performance."
"Limited interest and success in some areas make us hesitate about upgrading."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"The SQL Assistant is very basic. This tool can be improved for usability."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"It would help to make scaling easier with a reduced cost. "
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 38 reviews while Teradata is ranked 3rd in Data Warehouse with 21 reviews. Microsoft Azure Synapse Analytics is rated 8.0, while Teradata is rated 8.4. The top reviewer of Microsoft Azure Synapse Analytics writes "Multifeatured, has better performance over other solutions, and lets users manage structured and unstructured information, but the platform needs to be more user-friendly". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, Snowflake, SAP BW4HANA, Amazon Redshift and Apache Hadoop, whereas Teradata is most compared with SQL Server, Snowflake, MySQL, Oracle Exadata 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.