We performed a comparison between Azure Data Factory and Informatica Cloud Data Integration based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Azure Data Factory comes out on top in this comparison. It is easy to set up, user-friendly, and performs well. In addition, Azure Data Factory users are happier with the pricing. One area where Informatica Cloud Data did come out on top was in the support category.
"Data Factory's most valuable feature is Copy Activity."
"One of the most valuable features of Azure Data Factory is the drag-and-drop interface. This helps with workflow management because we can just drag any tables or data sources we need. Because of how easy it is to drag and drop, we can deliver things very quickly. It's more customizable through visual effect."
"ADF is another ETL tool similar to Informatica that can transform data or copy it from on-prem to the cloud or vice versa. Once we have the data, we can apply various transformations to it and schedule our pipeline according to our business needs. ADF integrates with Databricks. We can call our Databricks notebooks and schedule them via ADF."
"Azure Data Factory became more user-friendly when data-flows were introduced."
"Data Factory's best features are simplicity and flexibility."
"It is beneficial that the solution is written with Spark as the back end."
"The scalability of the product is impressive."
"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."
"Informatica Cloud Data Integration is stable."
"It is one of the best tools available for data integration."
"REST API: Excellent for scripting control and reporting mechanisms"
"The most valuable feature of Informatica Cloud Data Integration is Pushback. You are able to push the data to the solution itself, and it can handle the queries. It helps us a lot. With other tools, the burden is kept on the server."
"I do a quite a lot of data transformations, and the fact that I can do them without changing any of my SQL queries from the code, using the inbuilt tools, is very helpful."
"I like the fact that you can find almost any product connection that you need and the list is always expanding."
"Informatica Cloud Data Integration is stable."
"It is a scalable solution. Scalability-wise, I rate the solution a nine out of ten."
"The initial setup is not very straightforward."
"Currently, our company requires a monitoring tool, and that isn't available in Azure Data Factory."
"Some of the optimization techniques are not scalable."
"Data Factory's performance during heavy data processing isn't great."
"On the UI side, they could make it a little more intuitive in terms of how to add the radius components. Somebody who has been working with tools like Informatica or DataStage gets very used to how the UI looks and feels."
"Data Factory has so many features that it can be a little difficult or confusing to find some settings and configurations. I'm sure there's a way to make it a little easier to navigate."
"The product could provide more ways to import and export data."
"The pricing scheme is very complex and difficult to understand."
"The integration process is not easy."
"The main issue preventing Brazilian companies from migrating to Informatica Cloud Data Integration from on-prem is the price."
"A general improvement in icons and the virtual interface would be good."
"One area where Informatica Cloud Data Integration could improve is in providing more accelerators for certain functionalities."
"One area that needs to improve is the user experience because it is very complex. The trial version is very complex so it's not easy to start using the program immediately. You must study the rules first."
"There is room for improvement at the highest level in terms of useability and connectors for various types of new applications. The row processing performance could be better because you experience some latency dealing with high volumes of data. Most organizations will be dealing with multiple cloud applications, so you could see performance issues moving from one system to another."
"There are a small number of UI bugs that occur on occasion."
"The cloud version of the Informatica, it's a very substandard product. They might say it's enterprise-ready but it's not at all ready. They need to add more features, such as improved data replication features. If you look at other tools, such as Matillion they are now cloud-native and flexible. Additionally, Informatica Cloud Data Integration should have a good migration strategy from Informatica PowerCenter to Informatica Cloud Data Integration."
More Informatica Cloud Data Integration Pricing and Cost Advice →
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Informatica Cloud Data Integration is ranked 5th in Cloud Data Integration with 40 reviews. Azure Data Factory is rated 8.0, while Informatica Cloud Data Integration is rated 7.8. 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 Informatica Cloud Data Integration writes "A stable, scalable, and user-friendly solution". Azure Data Factory is most compared with Informatica PowerCenter, Alteryx Designer, Snowflake, IBM InfoSphere DataStage and Palantir Foundry, whereas Informatica Cloud Data Integration is most compared with Informatica PowerCenter, AWS Glue, Fivetran, IBM Cloud Pak for Data and Mule Anypoint Platform. See our Azure Data Factory vs. Informatica Cloud Data Integration report.
We monitor all Data Integration 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.