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 function of the solution is great."
"I like its integration with SQL pools, its ability to work with Databricks, its pipelines, and the serverless architecture are the most effective features."
"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."
"I can do everything I want with SSIS and Azure Data Factory."
"The most valuable features of Azure Data Factory are the flexibility, ability to move data at scale, and the integrations with different Azure components."
"We use the solution to move data from on-premises to the cloud."
"Data Factory's most valuable feature is Copy Activity."
"The flexibility that Azure Data Factory offers is great."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"It is a solid database a lot of different tools to move data."
"The two types of partitioning have been very significant for us - row and columnar partitioning."
"We did performance testing. We had a set of real life MicroStrategy reports. Our conditions were: Not allowed to redesign data model, not allowed to rewrite the queries, all queries should be generated by MicroStrategy, no aggregates. Teradata appeared to be way faster than a similarly configured (in terms of hardware) Oracle server."
"It handles large amounts of information with a linear performance increase, in relation to a HW investment."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"It's very mature from a technology perspective."
"The performance is great, we are able to query our data in one operation."
"The thing we missed most was data update, but this is now available as of two weeks ago."
"We require Azure Data Factory to be able to connect to Google Analytics."
"There is room for improvement primarily in its streaming capabilities. For structured streaming and machine learning model implementation within an ETL process, it lags behind tools like Informatica."
"Data Factory could be improved by eliminating the need for a physical data area. We have to extract data using Data Factory, then create a staging database for it with Azure SQL, which is very, very expensive. Another improvement would be lowering the licensing cost."
"The need to work more on developing out-of-the-box connectors for other products like Oracle, AWS, and others."
"The initial setup is not very straightforward."
"The solution needs to be more connectable to its own services."
"There's no Oracle connector if you want to do transformation using data flow activity, so Azure Data Factory needs more connectors for data flow transformation."
"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)."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"It could use some more advanced analytics relating to structured and semi-structured data."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Sometimes the large injestion takes days to load data, and some of our stored procedures take two to three days."
"The following could be better: licensing, architecture openness, integration with other tools."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"There is some improvement required on OLTP level and some analytical function is missing."
Azure Data Factory is ranked 3rd in Cloud Data Warehouse with 81 reviews while Teradata is ranked 3rd in Data Warehouse with 55 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, Snowflake, Alteryx Designer 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.