"Can capture all the transactional data throughout a company."
"Overall deployment and integration is pretty fast."
"The most valuable features of Microsoft Azure Synapse Analytics are how easy and quick it is to set up the linked services."
"Synapse Analytics' best features are notebooks, pipelines, and monitoring."
"The features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."
"We use Azure Synapse Analytics in many different areas and industries, so I like that you can administrate and create pipelines for difference sources of data and later integrate and deploy it to other internal areas, such as separate dashboards for financials, and so on."
"The solution offers strong scalability opportunities."
"The architecture, including compute and storage, is good."
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"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."
"Teradata's most valuable feature is that it's easy to use."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"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."
"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."
"The performance is great, we are able to query our data in one operation."
"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."
"Microsoft should develop an interface to make it easier to shift from on-premise to the cloud."
"We'd, of course, always like to pay less for the service if we can."
"It would be beneficial to take the top vendors and identify some kind of straightforward action to work with them. Instead of having to employ a separate vendor tool to be able to move this, it would be nice to be able to go through Microsoft."
"They should provide a less expensive version with a smaller setup for small businesses. Currently, its price is quite high for entry-level or small businesses. In terms of integration, new connectors are always welcomed."
"Integration with other products is an area that can be improved."
"In the future, Microsoft Azure Synapse Analytics could improve the performance, there are other solutions that are better, such as Databricks."
"The performance and data consistency need to be improved."
"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."
"Teradata's UI could be more user-friendly."
"I would like to see more integration with many different types of data."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
"Teradata needs to expand the kind of training that's available to customers. Teradata only offers training directly and doesn't delegate to any third-party companies. As a result, it's harder to find people trained on Teradata in our market relative to Oracle."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"Teradata should focus on functionality for building predictive models because, in that regard, it can definitely improve."
"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 44 reviews while Teradata is ranked 3rd in Data Warehouse with 14 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Teradata is rated 8.2. The top reviewer of Microsoft Azure Synapse Analytics writes "Scalable, intuitive, facilitates compliance and keeping your data secure". On the other hand, the top reviewer of Teradata writes "Good performance, flexible, easy to tune queries, and scales well". Microsoft Azure Synapse Analytics is most compared with Snowflake, Amazon Redshift, Azure Data Factory, Apache Hadoop and Oracle Exadata, whereas Teradata is most compared with Snowflake, Oracle Exadata, SQL Server, Vertica and Amazon Redshift.
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.