We performed a comparison between Microsoft Azure Synapse Analytics and Teradata Cloud Data Warehouse based on real PeerSpot user reviews.
Find out in this report how the two Cloud Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."I have been working with Microsoft, and they have been very helpful."
"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."
"The most valuable feature of Microsoft Azure Synapse Analytics is the pipeline that is the ETL tool. It's very well designed and is overall very good. We usually don't use the ETL tool in Databricks, but we use the ETL tool in this solution."
"We have found that it is easy to develop and to do the analytics in the modules of data."
"The most valuable feature is the level of processing power, and being able to complete tasks in parallel."
"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."
"It is a fantastic product; we are satisfied with its features and performance."
"The product is reliable."
"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."
"Real-time integration is hard to do in Microsoft Azure Synapse Analytics."
"Scaling this solution up and down is not quick and easy. This could be improved. The pricing of this solution could also be improved."
"Integration with other vendors has limitations and could be improved."
"I would like to see them provide the ingestion of images."
"The linked services can be improved. We can create dynamic linked services to access a lot of databases but only those of the same type. For example, I can use the same linked services to access 11 SQL databases. However, if I have 11 SQL databases and five Oracle databases, I need two dynamic linked services. I cannot do it with only one linked service. The UI also needs to be improved. When I have used Azure Synapse for programming with PySpark, Scala, or .NET, for example, the UI has been unstable. If I open two notebooks for programming, one notebook will queue the session of the other."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"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."
"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."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"It could be a bit more user-friendly."
"The cost of Teradata Cloud Data Warehouse has room for improvement."
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 86 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 Microsoft Azure Synapse Analytics vs. Teradata Cloud Data Warehouse report.
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.