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 pricing seems to be quite fair."
"Overall deployment and integration is pretty fast."
"Its seamless integration with Azure services is most valuable. If somebody wants to use all Azure services, it is the best solution."
"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."
"The architecture, including compute and storage, is good."
"The initial setup is very simple."
"The most valuable feature of Microsoft Azure Synapse Analytics is its integration with the new legacy systems. Whatever application we want to integrate, we receive the reports based on the objects. The solution is easy to purchase from the cloud."
"The integrated workspace in Microsoft Azure Synapse Analytics where everything comes together, such as Power BI and Data Factory, is very good. Additionally, the ability to do dedicated SQL pooling is a benefit."
"The performance is great, we are able to query our data in one operation."
"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."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"It's very, very fast"
"We really enjoy the FastLoad, TPump, and MultiLoad features."
"It has a solid set of tools and consulting services."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"The functionality of the solution is excellent."
"The platform is not flexible, and the graphical user interface needs to be improved because the interface makes it hard for the end user to use it."
"I would like to see better integration with Active Directory, because we have had problems, and we still do."
"The configuration for things like high-availability could be more user-friendly for non-technical users."
"Adding more transformations and plugins to the solution is very important."
"More integration is needed to improve the product for the future."
"Integration with other vendors has limitations and could be improved."
"It could be beneficial to focus on integration with various data sources and similar enhancements."
"The macro functions, though useful, are not totally user-friendly. Some people have difficulties in learning them."
"Teradata's UI could be improved."
"The scalability could be better. The on-premises solution is always more complicated to scale."
"There is some improvement required on OLTP level and some analytical function is missing."
"Teradata hardly supports unstructured data or semi-structured data"
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"The setup is not straightforward."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The SQL Assistant is very basic. This tool can be improved for usability."
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 IBM Db2 Database. 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.