Informatica PowerExchange and Azure Data Factory are competitors in the data integration and transformation market. Based on various aspects, Azure Data Factory appears to have an edge due to its cloud integration capabilities and user-friendly experience, catering to a modern cloud-centric approach.
Features: Informatica PowerExchange offers robust data transformation, real-time capabilities, and extensive connectivity with diverse systems, making it highly valuable for handling large data volumes and complex environments. Azure Data Factory stands out with ease of integration, scalability, a wide range of connectors, and seamless compatibility with Microsoft's ecosystem, enhancing its application for cloud-oriented data transformations.
Room for Improvement: Informatica PowerExchange users point out integration challenges, seeking improvements in real-time processing and pricing structures. Enhanced support for newer data types is also desired. Azure Data Factory could benefit from better integration with Azure Machine Learning, broader API support, improvements in real-time processing, pricing transparency, and user interface enhancements.
Ease of Deployment and Customer Service: Informatica PowerExchange, primarily on-premises, focuses on legacy support and reliability but involves complex management. It receives mixed feedback on customer support regarding response times. Azure Data Factory operates in the cloud, offering deployment flexibility, especially in Azure-centric conditions, and garners positive user feedback though some improvement in support response times is noted.
Pricing and ROI: Informatica PowerExchange uses a capacity-based pricing model, perceived as high but justified by its extensive features, offering significant ROI through process efficiency. Azure Data Factory employs a usage-based pricing model, aligning costs with demand. It is seen as more cost-effective for scalable use cases, providing flexibility for dynamic projects.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
The technical support is responsive and helpful
The technical support from Microsoft is rated an eight out of ten.
The technical support for Azure Data Factory is generally acceptable.
Their support aligns with what I have experienced with Informatica data quality teams, and it is quite effective.
Informatica's technical support team is very supportive and provides help whenever required.
The support was good enough, and they were able to resolve all the issues I raised in the past.
Azure Data Factory is highly scalable.
The solution has a high level of stability, roughly a nine out of ten.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
There is a problem with the integration with third-party solutions, particularly with SAP.
Incorporating more dedicated API sources to specific services like HubSpot CRM or Salesforce would be beneficial.
Sometimes, the compute fails to process data if there is a heavy load suddenly, and it doesn't scale up automatically.
The addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
One area that could be improved is performance, as PowerExchange sometimes has less performance compared to native connectors when dealing with a huge volume of data.
The pricing is cost-effective.
It is considered cost-effective.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
It connects to different sources out-of-the-box, making integration much easier.
The interface of Azure Data Factory is very usable with a more interactive visual experience, making it easier for people who are not as experienced in coding to work with.
I find the most valuable feature in Azure Data Factory to be its ability to handle large datasets.
It also reduces the number of APIs needed for new integrations by offering a unified exchange platform.
The primary advantage of Informatica PowerExchange is being able to extract data from source systems that Informatica does not natively support.
PowerExchange is one of the best software solutions to build integrations with non-Oracle or standard database services, especially for SAP and Hana products.
Azure Data Factory efficiently manages and integrates data from various sources, enabling seamless movement and transformation across platforms. Its valuable features include seamless integration with Azure services, handling large data volumes, flexible transformation, user-friendly interface, extensive connectors, and scalability. Users have experienced improved team performance, workflow simplification, enhanced collaboration, streamlined processes, and boosted productivity.
Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
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.
