We performed a comparison between Microsoft Azure Synapse Analytics and Teradata based on real PeerSpot user reviews.
Find out in this report how the two Data Warehouse solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most important feature for me is the integration with PolyBase."
"This is a stable solution with many functionalities."
"The most advantageous aspect of Microsoft Azure Synapse Analytics is its simplified data transformation process compared to traditional databases. This makes data cleansing and transformation more manageable and straightforward, which we appreciate. It is much easier to build as well."
"The pricing seems to be quite fair."
"I like its performance. It is well-structured and offers a lot of practical options. Because of the visual design of the product, it is very easy to find icons and other visual elements. It took me more than two weeks to understand how it works. I had an intensive training session to understand it, which was enough. It was not hard to understand how it works."
"Fills the gap between big data and classic data warehouses."
"The most valuable features are the flexibility and that it's easy to use as an end-user compared to AWS."
"It is a highly stable solution and it's easy to use."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"The flexibility in design is very good."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"Parallel processing features have helped to easily dump any size of data and retrieve data with great performance."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"From an infrastructure standpoint, I believe it can be more secure in terms of availability."
"The solution does not support oriented scaling in the synapse."
"Indicating what areas need improvement in this solution is a difficult question because the organizations that I am working for are really new in this area. However, an even better more simple interface, or perhaps an extension of a connector app store solution, would be helpful."
"The only issue that we have run into with the solutions performance is with regards to concurrency."
"The security performance and cost are the two things that needs improvement."
"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."
"The performance needs to improve in future releases."
"Synapse makes it easy to integrate and onboard data from other Microsoft and Azure sources. The interface is familiar because we were using Azure Data Factory before Synapse. It made the transition even easier because the Synapse interface is exactly the same."
"Data synchronization to the DR site."
"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."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"Query language and its functionality are rather limited, compared to Oracle or even SQL Server. However, it is possible to perform any kind of logic in it (though some workarounds may be required)."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Limited interest and success in some areas make us hesitate about upgrading."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
More Microsoft Azure Synapse Analytics Pricing and Cost Advice →
Microsoft Azure Synapse Analytics is ranked 2nd in Cloud Data Warehouse with 86 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Microsoft Azure Synapse Analytics is rated 7.8, while Teradata is rated 8.2. 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 writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". Microsoft Azure Synapse Analytics is most compared with Azure Data Factory, SAP BW4HANA, Snowflake, Oracle Autonomous Data Warehouse and Amazon Redshift, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and Vertica. See our Microsoft Azure Synapse Analytics vs. Teradata report.
See our list of best Data Warehouse vendors and best Cloud Data Warehouse vendors.
We monitor all 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.