Azure Data Factory - data integration tool to build your Cloud Data Platform.
January 24, 2026

Azure Data Factory - data integration tool to build your Cloud Data Platform.

Yoganand Shinde | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User

Overall Satisfaction with Azure Data Factory

Azure Data Factory is a data integration technology used to integrate data to the cloud, especially. Azure cloud. Today, any organization wants to integrate its data into a cloud data platform. This cloud platform serves data for various purposes, such as sharing it with downstream applications, developing analytics, and even building AI applications on it. Azure Data Factory integrates data from various sources, such as on-prem applications, databases, and files, into this data platform.

Pros

  • Data Ingestion - it works very well with numerous data sources.
  • Data pipeline orchestration: It is a generic, popular tool for orchestrating data pipelines.
  • Works well in Azure ecosystem, Azure services and data platforms like Databricks.
  • It is a serverless and scalable solution for cloud data integration.

Cons

  • Data transformation has provided a data flow. But it is not ideal for complex data transformation.
  • Cost of Data Factory depends on number of pipelines and transformations used.
  • Azure Data Factory is efficient and good for parallel data pipeline runs. But not ideal for a large volume of data.
  • Reduces the cost of movement of the data to the cloud.
  • Efficient tool monitoring and maintenance of the cloud data platform.
  • No code, low code.
For data integration in areas like data ingestion, orchestrations etc Azure data factory is very useful and handy technology. It is no code/low code technology which saves development efforts. For monitoring and maintenance it is simpler compare to other technologies.
Informatica is a great product. However, given the Azure ecosystem and the pay-as-you-go model's optimal cost, Azure Data Factory was our choice. Also, it is better on the data ingestion and orchestration side. For complex data transformation, we can consider technologies like Databricks in addition to Azure Data Factory.

Do you think Azure Data Factory delivers good value for the price?

Yes

Are you happy with Azure Data Factory's feature set?

Yes

Did Azure Data Factory live up to sales and marketing promises?

Yes

Did implementation of Azure Data Factory go as expected?

Yes

Would you buy Azure Data Factory again?

Yes

Azure Databricks, GitLab, Oracle Data Integrator (ODI)
Azure Data Factory is a great data integration tool for developing a cloud data platform, especially within the Azure ecosystem. Azure Data Factory is very good for the Data Ingestion part. It can work for simple data transformation with its Data Flow, but it will also need cluster configuration, and there is some cost. Also, it is an excellent tool for orchestrating data pipelines. But for complex data transformations, you may need to use technologies like Databricks and PySpark.

Azure Data Factory Feature Ratings

Connect to traditional data sources
9
Connecto to Big Data and NoSQL
8
Simple transformations
8
Complex transformations
7
Business rules and workflow
7
Collaboration
7
Testing and debugging
8
Integration with data quality tools
6
Integration with MDM tools
7

Comments

More Reviews of Azure Data Factory