We performed a comparison between Azure Data Factory and Informatica PowerExchange based on real PeerSpot user reviews.
Find out in this report how the two Data Integration solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."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 solution is okay."
"It is a complete ETL Solution."
"I can do everything I want with SSIS and Azure Data Factory."
"On the tool itself, we've never experienced any bugs or glitches. There haven't been crashes. Stability has been good."
"From what we have seen so far, the solution seems very stable."
"From my experience so far, the best feature is the ability to copy data to any environment. We have 100 connects and we can connect them to the system and copy the data from its respective system to any environment. That is the best feature."
"UI is easy to navigate and I can retrieve VTL code without knowing in-depth coding languages."
"The product’s flexibility is valuable."
"The most valuable feature is connectivity to data sources."
"The scalability is excellent."
"Provides a significant amount of control over the landscape and overall implementation."
"The agentless RCDC enablement through PowerExchange is a great idea and has worked very well so far."
"It is easy to integrate the solution with other tools."
"Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking."
"Mainstream integration and real-time integration are the best features."
"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."
"The number of standard adaptors could be extended further."
"Azure Data Factory can improve by having support in the drivers for change data capture."
"Azure Data Factory's pricing in terms of utilization could be improved."
"You cannot use a custom data delimiter, which means that you have problems receiving data in certain formats."
"Azure Data Factory uses many resources and has issues with parallel workflows."
"It would be better if it had machine learning capabilities."
"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."
"I would like to have easier integration with cloud platforms."
"Real-time has not been enhanced that much over the past few years. There has not been as many features added like they did before."
"The connectivity with T24 core banking could be improved."
"The solution needs better integration with other tools."
"The solution could be made more user-friendly. The configurations are also quite difficult."
"The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk."
"The product is not suitable for application integration."
"They should make it quick and easy for use of citizen data integration or for people or integrators developing at the customer side. They could be development teams within the business team. For them, the product owners can consider making it a little bit more seamless and a little bit more democratized."
Azure Data Factory is ranked 1st in Data Integration with 79 reviews while Informatica PowerExchange is ranked 21st in Data Integration with 19 reviews. Azure Data Factory is rated 8.0, while Informatica PowerExchange 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 PowerExchange writes "Handles big data better than competitors". Azure Data Factory is most compared with Informatica PowerCenter, Alteryx Designer, Informatica Cloud Data Integration, Snowflake and Microsoft Azure Synapse Analytics, whereas Informatica PowerExchange is most compared with Informatica PowerCenter, Oracle GoldenGate, Qlik Replicate, Informatica Cloud Data Integration and SSIS. See our Azure Data Factory vs. Informatica PowerExchange 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.