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."We have been using drivers to connect to various data sets and consume data."
"The tool's most valuable features are its connectors. It has many out-of-the-box connectors. We use ADF for ETL processes. Our main use case involves integrating data from various databases, processing it, and loading it into the target database. ADF plays a crucial role in orchestrating these ETL workflows."
"Allows more data between on-premises and cloud solutions"
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"Data Flow and Databricks are going to be extremely valuable services, allowing data solutions to scale as the business grows and new data sources are added."
"Data Factory itself is great. It's pretty straightforward. You can easily add sources, join and lookup information, etc. The ease of use is pretty good."
"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 scalability of the product is impressive."
"It is a solid database a lot of different tools to move data."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"It's very, very fast"
"I like this solution's ease of design and the fact that its performance is quite good. It is stable as well."
"Teradata's pretty fast."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"The solution scales well on the cloud."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"In the next release, it's important that some sort of scheduler for running tasks is added."
"Snowflake connectivity was recently added and if the vendor provided some videos on how to create data then that would be helpful."
"Lacks a decent UI that would give us a view of the kinds of requests that come in."
"There is no built-in function for automatically adding notifications concerning the progress or outline of a pipeline run."
"Data Factory could be improved in terms of data transformations by adding more metadata extractions."
"Data Factory's monitorability could be better."
"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."
"If the user interface was more user friendly and there was better error feedback, it would be helpful."
"Teradata's UI could be more user-friendly."
"The user interface needs to be improved."
"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."
"Teradata can improve the way it handles big data and unstructured data."
"The SQL Assistant is very basic. This tool can be improved for usability."
"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."
"The cloud is the new challenge and the new opportunity."
"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."
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.