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.
"I enjoy the ease of use for the backend JSON generator, the deployment solution, and the template management."
"It is easy to deploy workflows and schedule jobs."
"The most valuable feature of Azure Data Factory is that it has a good combination of flexibility, fine-tuning, automation, and good monitoring."
"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."
"We use the solution to move data from on-premises to the cloud."
"The solution is okay."
"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."
"The most important feature is that it can help you do the multi-threading concepts."
"The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness."
"What I like the most is that we have to deal with less while writing the queries."
"The number of docs has been reduced drastically, which is very good."
"The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Can manage a huge quantity of data and provide reliability."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly."
"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."
"It's a good idea to take a Microsoft course. Because they are really helpful when you start from your journey with Data Factory."
"Azure Data Factory should be cheaper to move data to a data center abroad for calamities in case of disasters."
"Data Factory would be improved if it were a little more configuration-oriented and not so code-oriented and if it had more automated features."
"Data Factory's performance during heavy data processing isn't great."
"There's space for improvement in the development process of the data pipelines."
"We have experienced some issues with the integration. This is an area that needs improvement."
"This solution is currently only useful for basic data movement and file extractions, which we would like to see developed to handle more complex data transformations."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design."
"Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version."
"There is some room for improvement in terms of pricing."
"Requires an established data center because there is no option for software as a service."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
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.