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 solution's scalability is very, very good. It's one of the most important aspects for us."
"The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"The most valuable feature is performance gains."
"The solution can scale."
"Synapse Analytics gives you information and reports in real-time."
"I have not used the technical support from Microsoft Azure Synapse Analytics, but I worked with the developers at Microsoft who were top-notch."
"The speed is great and the architecture is excellent."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The key advantages are Performance when processing Terabytes of data and scalability."
"The most valuable features of Teradata are that it is a massively parallel platform and I can receive a lot of data and get the queries out correctly, especially if it's been appropriately designed. The native features make it very suitable for multiple large data tasks in a structured data environment. Additionally, the automation is very good."
"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."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"Teradata has good performance, the response times are very fast. Overall the solution is easy to use. When we do the transformation, we have all of our staging and aggregation data available."
"Teradata is a great, industry-leading data warehousing product that has MPP architecture."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"It's a pre-configured appliance that requires very little in terms of setting-up."
"Integration with other products is an area that can be improved."
"It's stable, but its stability could be better. However, we understand that it's in production, and new features are getting added and upgraded, so you do get hiccups sometimes."
"Synapse Analytics' performance slows down if you don't get your distribution right because it gets queued and goes into a single node."
"Integration with other vendors has limitations and could be improved."
"It could be more stable."
"Microsoft Azure Synapse Analytics could improve its compatibility with Visual Studio. One of the challenges for people moving from an on-premise to a cloud solution, such as Microsoft Azure Synapse Analytics, is that you're constantly working in a browser. There are people that have been working for decades on desktop applications. For them to start working in a browser, it's quite a change. Allowing people to work and do their work inside Visual Studio than in the browser, would be a large advantage."
"There is a limit on the number of concurrent queries to around 125 for Azure Synapse."
"The performance and data consistency need to be improved."
"The following could be better: licensing, architecture openness, integration with other tools."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"Teradata is an old data warehouse, and they're not improving in terms of new, innovative features."
"There is some improvement required on OLTP level and some analytical function is missing."
"Teradata's UI could be more user-friendly."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"It could use some more advanced analytics relating to structured and semi-structured data."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 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.