Informatica PowerExchange and Fivetran are key competitors in the data integration tools category. Informatica PowerExchange holds an edge with its robust real-time integration and data transformation capabilities, while Fivetran shines in its simplicity and efficiency, especially for real-time data syncs.
Features: Informatica PowerExchange is known for real-time integration, data transformation, and efficient data processing using pushdown optimization. It also offers strong change data capture and metadata capabilities. Fivetran is valued for its ease of setup and high scalability, with user-friendly managed pipelines and integration with tools like DBT enhancing its transformation processes.
Room for Improvement: Informatica PowerExchange could enhance its price competitiveness and real-time capabilities, along with easing its usability. It also requires broader integration support and improved setup simplicity. Fivetran would benefit from improved pipeline observability and additional connectors. Users seek ETL and reverse ETL within a single platform, as well as better customization for on-premise deployments and more transparency in pricing.
Ease of Deployment and Customer Service: Informatica PowerExchange primarily supports on-premises deployments with limited cloud capabilities, and its support varies in quality. Fivetran, focusing on public cloud deployments, offers straightforward setup but has average customer service with some delays in response times.
Pricing and ROI: Informatica PowerExchange, although expensive, is appreciated for the value it brings, offering significant ROI through streamlined operations. Its pricing is linked to capacity and usage. Fivetran, with a varied pricing model based on data ingestion, provides substantial ROI via scalability, being more cost-effective for large enterprises despite challenges for smaller businesses.
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.
The technical support provided by Fivetran has generally been good, with a response time and competence that I would rate as good.
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.
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.
If a specific feature is required, it should be integrated promptly.
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.
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 ability to seamlessly integrate with a large variety of data sources is valuable.
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.
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 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.
