We performed a comparison between Azure Data Factory and Teradata 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."The data copy template is a valuable feature."
"The data mapping and the ability to systematically derive data are nice features. It worked really well for the solution we had. It is visual, and it did the transformation as we wanted."
"It is a complete ETL Solution."
"It is beneficial that the solution is written with Spark as the back end."
"We use the solution to move data from on-premises to the cloud."
"The flexibility that Azure Data Factory offers is great."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"I think it makes it very easy to understand what data flow is and so on. You can leverage the user interface to do the different data flows, and it's great. I like it a lot."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"It effectively has allowed us to remove over 20 portion copies of the data sets on other DB platforms for real-time operational reporting purposes."
"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."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"The initial setup was straightforward."
"Teradata's best feature is its speed with historical data."
"Improved performance of ETL procedures, reporting."
"The pricing scheme is very complex and difficult to understand."
"There is no built-in pipeline exit activity when encountering an error."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"The solution should offer better integration with Azure machine learning. We should be able to embed the cognitive services from Microsoft, for example as a web API. It should allow us to embed Azure machine learning in a more user-friendly way."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"Data Factory's cost is too high."
"I have not found any real shortcomings within the product."
"User-friendliness and user effectiveness are unquestionably important, and it may be a good option here to improve the user experience. However, I believe that more and more sophisticated monitoring would be beneficial."
"It could use some more advanced analytics relating to structured and semi-structured data."
"The user interface needs to be improved."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"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)."
"Data synchronization to the DR site."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"The cloud is the new challenge and the new opportunity."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Teradata is ranked 3rd in Data Warehouse with 54 reviews. Azure Data Factory is rated 8.0, while Teradata is rated 8.2. The top reviewer of Azure Data Factory writes "The data factory agent is quite good but pricing needs to be more transparent". 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". Azure Data Factory is most compared with Informatica PowerCenter, Informatica Cloud Data Integration, Alteryx Designer, Snowflake and Microsoft Azure Synapse Analytics, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, MySQL and BigQuery. See our Azure Data Factory vs. Teradata 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.