We performed a comparison between Microsoft Azure Synapse Analytics and Teradata Cloud Data Warehouse based on real PeerSpot user reviews.
Find out what your peers are saying about Snowflake Computing, Microsoft, Amazon Web Services (AWS) and others in Cloud Data Warehouse."It is a highly stable solution and it's easy to use."
"The solution's scalability is very, very good. It's one of the most important aspects for us."
"The most valuable features of Microsoft Azure Synapse Analytics are the interface and the agility of the on-cloud platform."
"The speed is great and the architecture is excellent."
"The setup is pretty simple."
"We've had a good experience with technical support in general."
"The useability, the user interface, is very user-friendly."
"I like SQL post, which is for storage and distributed computing. Another good feature is the copy activity."
"The cloud is ten times better than physical hardware; it is more cost-effective and the upgrade process is ten times easier."
"The most valuable feature is the ease of running queries."
"The product is reliable."
"It needs strong support for social media, internet data, and native support for NoSQL."
"We'd, of course, always like to pay less for the service if we can."
"They should automate some of the features. There are some things, such as the creation of external tables, that you have to do manually. They should be automated."
"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."
"The security performance and cost are the two things that needs improvement."
"The performance and data consistency need to be improved."
"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."
"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."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"It could be a bit more user-friendly."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
More Teradata Cloud Data Warehouse Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 85 reviews while Teradata Cloud Data Warehouse is ranked 13th in Cloud Data Warehouse with 3 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Teradata Cloud Data Warehouse is rated 8.0. 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 Cloud Data Warehouse writes "Is quick, easy to upgrade, and cost-effective". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Teradata, whereas Teradata Cloud Data Warehouse is most compared with Snowflake, Amazon Redshift, Teradata, Oracle Exadata and Vertica.
See our list of best Cloud Data Warehouse vendors.
We monitor all Cloud 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.