
![Informatica PowerExchange [EOL] Logo](https://images.peerspot.com/image/upload/c_scale,dpr_3.0,f_auto,q_100,w_64/gaXfZsz7e51ho14qsm4PpcUN.jpg?_a=BACAGSGT)
Informatica PowerExchange and Fivetran compete in the data transformation and integration tools category. Fivetran appears to have the upper hand due to its user-friendliness and scalable real-time data replication capabilities.
Features: Informatica PowerExchange is recognized for its powerful data transformation engine integrated with the Hadoop ecosystem and supports change data capture for near real-time processing. It manages extensive data volumes effectively and integrates seamlessly with external sources. Fivetran offers managed pipelines with pre-built connectors and a simplistic interface integrated with DBT for enhanced transformations, making it easy for users to set up connections and manage data integration processes efficiently.
Room for Improvement: Informatica PowerExchange could improve in cloud platform integration, simplifying complex feature implementations like COBOL Copybooks, and reducing high costs. It also needs enhancements in usability and broader database integration capabilities. Fivetran needs more robust logging features and faster real-time processing speeds. Its pricing, when dealing with large data volumes, is often criticized. Expanding the availability of connectors and improving customization options would enhance its appeal. Customer support and transformation options also require attention.
Ease of Deployment and Customer Service: Informatica PowerExchange offers on-premises deployment allowing control but has mixed reviews on customer service, with reports of delayed support. Fivetran, operating primarily in a public cloud environment, facilitates easy deployment with minimal setup but could improve its customer support responsiveness. Its simplicity in deployment benefits users but has some limitations in certain scenarios.
Pricing and ROI: Informatica PowerExchange has a complex, capacity-based pricing model, which can be perceived as expensive, but it provides cost-efficiency by reducing API and training costs, leading to a positive ROI in digital transformation. Fivetran's pricing is high, particularly for small operations, but offers scalable costs for large data volumes. Despite substantial costs, its flexibility makes it cost-effective for extensive use, providing good ROI by improving data integration efficiencies and decision-making processes.
Fivetran provides time savings, cost reductions, and improvements in data quality.
It saves us the effort of having one to two data engineers managing the tasks that Fivetran handles.
It is considered cost-efficient because it leads to the re-utilization of channels and platforms, which saves time and money.
If they could provide support more quickly, that would be great.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
Customer support from Fivetran is quite good; it's really nice and responsive.
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.
Fivetran's scalability has been tested effectively, and it has been working well for our organization's growing data needs.
They have 99.9% accuracy on the data load and they maintain transparency.
In my experience, Fivetran is stable with very few instances of downtime or reliability issues.
During the duration of the time that we used Fivetran, it was highly stable.
Technical errors sometimes occur, such as network breakages at the source level, which breaks connectivity.
From a cost perspective, if the number of connectors is lesser, then Fivetran is not the most cost-efficient option.
When we tried to use a built-in Oracle connector, it didn't allow for the tweaks we needed, which led us to the SDK connector route and caused delays in development.
Fivetran could improve by adapting more for technical users and by providing more options for such users.
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 addition of data quality dashboards or measures would also help in profiling data to assess its health before sharing or moving it.
Our current yearly contract for Fivetran is approximately $70,000.
Informatica PowerExchange is considered cost-efficient due to reduced number of APIs needed.
The pricing and cost depend heavily on SAP's licensing structure, especially if using SAP integration services.
The most valuable feature of Fivetran is its built-in connectors for a wide range of data sources.
The real-time data replication is what I see best in the market where it reduces the overhead of customers needing to maintain the pipeline.
Fivetran not only has built-in connectors but also provides SDK connectors, allowing us to develop our own connectors in an easy manner.
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.

| Company Size | Count |
|---|---|
| Small Business | 10 |
| Midsize Enterprise | 7 |
| Large Enterprise | 16 |
| Company Size | Count |
|---|---|
| Small Business | 8 |
| Midsize Enterprise | 3 |
| Large Enterprise | 12 |
Fivetran, the global leader in data movement, is trusted by companies like OpenAI, LVMH, Pfizer, Verizon and Spotify to centralize data from SaaS applications, databases, files, and other sources into cloud destinations, including data lakes. With high-performance pipelines, seamless interoperability, and enterprise-grade security, Fivetran empowers organizations to modernize their data infrastructure, power analytics and AI, ensure compliance, and achieve transformative business outcomes. Learn more at Fivetran.com
Informatica PowerExchange [EOL] offers advanced data integration capabilities, emphasizing data transformation, real-time integration, and connectivity to diverse data sources, ensuring seamless access and management of big data in complex environments.
Informatica PowerExchange [EOL] is a robust tool for managing data integration and transformation processes. It supports connectivity to numerous sources, enabling real-time data capture and transformation. With native connectors and APIs, it allows seamless integration, ensuring data mapping across data formats. While strong at data handling and integration, improvements in pricing, real-time processing, and enhanced technical support are necessary. Expanded cloud integration and improved high availability will further bolster its efficiency in managing extensive datasets, supporting ETL, and integrating systems like SAP.
What are the most important features of Informatica PowerExchange?Informatica PowerExchange [EOL] is implemented widely in sectors requiring robust data integration solutions. It serves industries such as finance, healthcare, and retail, facilitating the creation of data warehouses and lakes. Used for ETL processes and operational analytics, it integrates systems like Hadoop, Oracle, and legacy environments, driving efficient communication and information sharing.
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.