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."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"The most valuable feature of Microsoft Azure Synapse Analytics is the capabilities, and the integration with other Azure resources, such as Data Factory, Databricks, and Spark for data processing. The overall ability to compose the solution with other Azure resources is valuable."
"The platform has multiple valuable use cases. They include performance, compatibility, flexibility, and cost."
"Azure Synapse combines the strengths of SQL technologies for effective enterprise data management."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"Data can be stored any way you want in the data warehouse."
"There are several features of Teradata that I like. One of the most basic is the indexes. I also like that it provides lower TCO. It also has the optimizer feature which is a good feature and isn't found in other legacy systems. Parallelism is also another feature I like in Teradata because when you are running or hosting on multiple systems, you have this shared-nothing architecture that helps. Loading and unloading in Teradata are also really helpful compared to other systems."
"Cuts time to process huge amounts of data with efficient analytical queries."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"It is a stable program."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"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."
"The solution scales well on the cloud."
"It is a solid database a lot of different tools to move data."
"The major challenge that we're seeing with Azure Synapse is around security concerns. The way it is working right now, it has Managed VNet by Microsoft option, similar to the implementation of Azure Databricks, which may pose a concern for financial institutions. For managed environments, the banks have very strict policies around data being onboarded to those environments. For some confidential applications, the banks have the policy to encrypt it with their own key, so it is sort of like Bring Your Own Key, but it is not possible to manage the resources with Microsoft or Databricks, which is probably the major challenge with Azure Synapse. There should be more compatibility with SQL Server. It should be easier to migrate solutions between different environments because right now, it is not really competitive. It is not like you can go and install SQL Database in some other environment. You will have to go through some migration projects, which probably is one of the major showstoppers for any bank. When they consider Synapse, they not only consider the investment in the actual service; they also consider the cost of the migration process. When you scale out or scale down your system, it becomes unavailable for a few minutes. Because it is a data warehouse environment, it is not such a huge deal, but it would be great if they can improve it so that the platform is available during the change of configuration."
"Microsoft Azure Synapse Analytics can improve by adding more flexibility to the reports. Having more visible structures based on the area, region and country would be beneficial."
"The solution does not support oriented scaling in the synapse."
"This solution needs to have query caching so that if the same query is run and the results are available, it will return the data from the cache without having to re-run the query."
"I am a researcher. For people to be able to research a solution, there should be at least a free trial. Just advertising a product or saying that this product is better doesn't work. I would strongly recommend providing a lot of free trials and trainings. This will also help Microsoft in having more users or customers. Oracle provides some free trials. You can just go for a free trial and use your database online, which is very good."
"Microsoft Azure Synapse Analytics could improve in usability. I have found the same issue with all Microsoft solutions."
"I'd like to see part of the service de-coupled."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata can improve the way it handles big data and unstructured data."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"I would like to see an improved Knowledge Base on the web."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
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 IBM Db2 Database. 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.