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."It's user-friendly and has a good dashboard."
"Very interactive and provides flexibility."
"The useability, the user interface, is very user-friendly."
"The most valuable feature of the solution is the analytics and that it can connect with Power BI."
"The architecture, including compute and storage, is good."
"The solution has been working well overall."
"The product works well with other Azure products."
"The solution's best feature is its predictive analytics."
"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."
"Could have more connectors and better integration for Hadoop."
"More integration is needed to improve the product for the future."
"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."
"With respect to what needs to be improved, concurrent connectivity has some limitations."
"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."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"It would be ideal if the solution could be better used intuitively by the staff without having a great deal of training."
"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."
"It could be a bit more user-friendly."
"Stability-wise, we have had some issues with automation and the ability to handle large datasets."
"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.