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 initial setup is very quick and easy."
"I like how you can create your own pipeline in your space and reuse those creations. You can collaborate with other people who want to use your code."
"The flexibility that Azure Data Factory offers is great."
"This solution will allow the organisation to improve its existing data offerings over time by adding predictive analytics, data sharing via APIs and other enhancements readily."
"The most valuable features are data transformations."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"The data copy template is a valuable feature."
"When it comes to our business requirements, this solution has worked well for us. However, we have not stretched it to the limit."
"Designing the database is easy."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"Improved performance of ETL procedures, reporting."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"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."
"It is a stable program."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"Sometimes I need to do some coding, and I'd like to avoid that. I'd like no-code integrations."
"The user interface could use improvement. It's not a major issue but it's something that can be improved."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"There is always room to improve. There should be good examples of use that, of course, customers aren't always willing to share. It is Catch-22. It would help the user base if everybody had really good examples of deployments that worked, but when you ask people to put out their good deployments, which also includes me, you usually got, "No, I'm not going to do that." They don't have enough good examples. Microsoft probably just needs to pay one of their partners to build 20 or 30 examples of functional Data Factories and then share them as a user base."
"Occasionally, there are problems within Microsoft itself that impacts the Data Factory and causes it to fail."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"The one element of the solution that we have used and could be improved is the user interface."
"I've been using the same UI for 20 years in Teradata. It could use some updating. Adding more stability around Teradata Studio would be outstanding. Teradata Studio is a Java-based version of their tool. It's much better now, but it still has some room for improvement."
"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)."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"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."
"Teradata's UI could be more user-friendly."
"Teradata needs to pay attention to the cloud-based solution to make sure it runs smoothly."
"Teradata can improve the way it handles big data and unstructured data."
"The solution is stable. However, there are times when we are using large amounts of data and we can see some latency issues."
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 IBM InfoSphere DataStage, 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.