IT Central Station is now PeerSpot: Here's why

Microsoft Azure Synapse Analytics vs Teradata comparison

Cancel
You must select at least 2 products to compare!
Featured Review
Buyer's Guide
Cloud Data Warehouse
August 2022
Find out what your peers are saying about Snowflake Computing, Microsoft, Micro Focus and others in Cloud Data Warehouse. Updated: August 2022.
621,703 professionals have used our research since 2012.
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More Microsoft Azure Synapse Analytics Pros →

"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."

More Teradata Pros →

Cons
"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."

More Microsoft Azure Synapse Analytics Cons →

"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 Teradata Cons →

Pricing and Cost Advice
  • "Our license is very expensive"
  • "They are cost aggressive, and it integrates well with other Microsoft tools."
  • "There is a cost calculator available online that allows you to input your entire scenario, and it will get back to you with information on what the costs are going to be."
  • "Its price could be better. It was a school project, and I got it for free. If I try to pay through my company, it is a little bit more expensive as compared to Oracle."
  • "The price of the package not expensive and depends on how much it is used."
  • "The cost of the licensing depends on the size of the warehouse, where the cost of storage is approximately $130 USD per terabyte."
  • "This is a cost-effective product."
  • "Because it's cloud the cost is a different convention and the licensing costs are not the same."
  • More Microsoft Azure Synapse Analytics Pricing and Cost Advice →

  • "The solution requires a license."
  • "The price of Teradata is on the higher side, and I think that it where they lose out on some of their business."
  • "The price of the solution could be reduced, it is expensive."
  • "Teradata is expensive, so it's typically marketed to big customers. However, there have been some changes, and Teradata is now offering more flexible pricing models and equipment leasing. They've added pay-as-you-go and cloud models, so it's changing, but Teradata is generally known as an expensive high-end product."
  • "The cost of running Teradata is quite high, but you get a good return on investment."
  • "Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
  • "The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
  • More Teradata Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Cloud Data Warehouse solutions are best for your needs.
    621,703 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:Amazon Redshift is very fast, has a very good response time, and is very user-friendly. The initial setup is very straightforward. This solution can merge and integrate well with many different… more »
    Top Answer:Traditional ETL would usually use a dedicated database (or even database server) where you'll load & transform your raw data before ingesting it into the final destination. This would allow checking… more »
    Top Answer:I've never had any issues with scalability.
    Top Answer:Apart from Control-M, it would be nice if it could integrate with other tools. Specifically, with respect to the integrations with the automation tools, if that can be increased, and if the tester… more »
    Top Answer:We primarily use the solution for the EDW.
    Ranking
    2nd
    Views
    33,074
    Comparisons
    22,599
    Reviews
    44
    Average Words per Review
    491
    Rating
    7.9
    3rd
    out of 30 in Data Warehouse
    Views
    12,671
    Comparisons
    10,215
    Reviews
    11
    Average Words per Review
    439
    Rating
    8.6
    Comparisons
    Also Known As
    Azure Synapse Analytics, Microsoft Azure SQL Data Warehouse, Microsoft Azure SQL DW, Azure SQL Data Warehouse, MS Azure Synapse Analytics
    Learn More
    Overview

    Microsoft Azure Synapse Analytics is an end-to-end analytics solution that successfully combines analytical services to merge big data analytics and enterprise data warehouses into a single unified platform. The solution can run intelligent distributed queries among nodes, and provides the ability to query both relational and non-relational data.

    Microsoft Azure Synapse Analytics is built with these 4 components:

    1. Synapse SQL
    2. Spark
    3. Synapse Pipeline
    4. Studio

    Microsoft Azure Synapse Analytics Features

    Microsoft Azure Synapse Analytics has many valuable key features, including:

    • Cloud Data Service: WIth Microsoft Azure Synapse Analytics you can operate services (data analytics, machine learning, data warehousing, dashboarding, etc.) in a single workspace via the cloud.

    • Structured and unstructured data: Microsoft Azure Synapse Analytics supports both structured and unstructured data and allows you to manage relational and non-relational data - unlike data warehouses and lakes that tend to store them respectively.

    • Effective data storage: Microsoft Azure Synapse Analytics offers next-level data storage with high availability and different tiers.

    • Responsive data engine: Microsoft Azure Synapse Analytics uses Massive Parallel Processing (MPP) and is designed to handle large volumes of data and analytical workloads efficiently without any problems.

    • Several scripting languages: The solution provides language compatibility and supports different programming languages, such as Python, Java, Spark SQL, and Scala.

    • Query optimization: Microsoft Azure Synapse Analytics works well to facilitate limitless concurrency and performance optimization. It also simplifies workload management.

    Microsoft Azure Synapse Analytics Benefits

    Some of the benefits of using Microsoft Azure Synapse Analytics include:

    • Database templates: Microsoft Azure Synapse Analytics offers industry-specific database templates that make it easy to combine and shape data.

    • Better business insights: With Microsoft Azure Synapse Analytics you can expand discovery of insights from all your data and apply machine learning models to all your intelligent apps.

    • Reduce project development time: Microsoft Azure Synapse Analytics makes it possible to have a unified experience for developing end-to-end analytics, which reduces project development time significantly.

    • Eliminate data barriers: By using Microsoft Azure Synapse Analytics, you can perform analytics on operational and business apps data without data movement.

    • Advanced security: Microsoft Azure Synapse Analytics provides both advanced security and privacy features to ensure data protection.

    • Machine Learning: Microsoft Azure Synapse Analytics integrates Azure Machine Learning, Azure Cognitive Services, and Power BI.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by Microsoft Azure Synapse Analytics users who are currently using the solution.

    PeerSpot user Jael S., who is an Information Architect at Systems Analysis & Design Engineering, comments on her experience using the product, saying that it is “Scalable, intuitive, facilitates compliance and keeps your data secure”. She also says "We also like governance. It looks at what the requirements are for the company to identify the best way to ensure compliance is met when you move to the cloud."

    Michel T., CHTO at Timp-iT, mentions that "the features most valuable are the simplicity, how easy it is to create a dashboard from different information systems."

    A Senior Teradata Consultant at a tech services company says, "Microsoft provides both the platform and the data center, so you don't have to look for a cloud vendor. It saves you from having to deal with two vendors for the same task."


    Teradata's portfolio of big data analytic solutions, integrated marketing applications, and services help organizations gain a sustainable competitive advantage with data.

    Offer
    Learn more about Microsoft Azure Synapse Analytics
    Learn more about Teradata
    Sample Customers
    Toshiba, Carnival, LG Electronics, Jet.com, Adobe, 
    Netflix
    Top Industries
    REVIEWERS
    Computer Software Company24%
    Comms Service Provider14%
    Manufacturing Company10%
    Healthcare Company10%
    VISITORS READING REVIEWS
    Computer Software Company25%
    Comms Service Provider16%
    Financial Services Firm7%
    Energy/Utilities Company6%
    REVIEWERS
    Comms Service Provider29%
    Financial Services Firm14%
    Energy/Utilities Company14%
    Computer Software Company14%
    VISITORS READING REVIEWS
    Computer Software Company24%
    Financial Services Firm16%
    Comms Service Provider14%
    Energy/Utilities Company6%
    Company Size
    REVIEWERS
    Small Business27%
    Midsize Enterprise24%
    Large Enterprise49%
    VISITORS READING REVIEWS
    Small Business17%
    Midsize Enterprise15%
    Large Enterprise67%
    REVIEWERS
    Small Business35%
    Midsize Enterprise10%
    Large Enterprise54%
    VISITORS READING REVIEWS
    Small Business13%
    Midsize Enterprise11%
    Large Enterprise76%
    Buyer's Guide
    Cloud Data Warehouse
    August 2022
    Find out what your peers are saying about Snowflake Computing, Microsoft, Micro Focus and others in Cloud Data Warehouse. Updated: August 2022.
    621,703 professionals have used our research since 2012.

    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.