We performed a comparison between Azure Data Factory and Informatica Powercenter based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Based on the parameters we compared, Azure Data Factory and Informatica Powercenter are very comparable to one another. Overall, PeerSpot users found that both solutions have helpful features. However, users found Informatica Powercenter to be more expensive than Azure Data Factory.
"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."
"The most important feature is that it can help you do the multi-threading concepts."
"We use the solution to move data from on-premises to the cloud."
"The trigger scheduling options are decently robust."
"An excellent tool for pipeline orchestration."
"It is very modular. It works well. We've used Data Factory and then made calls to libraries outside of Data Factory to do things that it wasn't optimized to do, and it worked really well. It is obviously proprietary in regards to Microsoft created it, but it is pretty easy and direct to bring in outside capabilities into Data Factory."
"Its integrability with the rest of the activities on Azure is most valuable."
"The flexibility that Azure Data Factory offers is great."
"If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful."
"It's very easy to use it to develop mappings and workflows."
"It has a Data Catalog that uses the Model repository."
"The product's initial setup phase is very easy."
"Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better."
"We have found the PowerCenter and B2B data transformation most valuable."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"The performance could be better. It would be better if Azure Data Factory could handle a higher load. I have heard that it can get overloaded, and it can't handle it."
"The solution can be improved by decreasing the warmup time which currently can take up to five minutes."
"When working with AWS, we have noticed that the difference between ADF and AWS is that AWS is more customer-focused. They're more responsive compared to any other company. ADF is not as good as AWS, but it should be. If AWS is ten out of ten, ADF is around eight out of ten. I think AWS is easier to understand from the GUI perspective compared to ADF."
"When the record fails, it's tough to identify and log."
"Currently, smaller businesses face a disadvantage in terms of pricing, and reducing costs could address this issue."
"The setup and configuration process could be simplified."
"The product's technical support has certain shortcomings, making it an area where improvements are required."
"It can improve from the perspective of active logging. It can provide active logging information."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"I would like to see it be able to import data from NoSQL."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
Azure Data Factory is ranked 1st in Data Integration with 81 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Azure Data Factory is rated 8.0, while Informatica PowerCenter is rated 8.0. 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 PowerCenter writes "Stable, provides good support, and integrating it with other systems is very fast, but its pricing is expensive". Azure Data Factory is most compared with Informatica Cloud Data Integration, Alteryx Designer, Snowflake, IBM InfoSphere DataStage and Microsoft Azure Synapse Analytics, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, SSIS, Databricks, AWS Glue and Oracle Data Integrator (ODI). See our Azure Data Factory vs. Informatica PowerCenter report.
See our list of best Data Integration vendors.
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.