We performed a comparison between Fivetran and Informatica PowerCenter 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."Fivetran is remarkably easy to use; I haven't encountered any other data integration tool that is as user-friendly."
"It is not like a traditional ETL, but it gives quite a lot of flexibility."
"The most valuable feature of Fivetran is that it only synchronizes what needs to be synchronized."
"Fivetran can perform data migration incredibly fast, depending on the source and target."
"The compare feature is the most valuable piece of it."
"The portal is very intuitive and easy to use."
"There's the general feature of the platform where it just makes it very easy to integrate different things, but I would say a specific difference is their integration of DBT,."
"The general data ingestion is valuable. It's used for a lot of data. It provides about 90% of the data we use in our data warehouse without needing data engineering."
"It has very good monitoring and process monitoring."
"Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured."
"It reduces a lot of legacy coding."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"Can manage a huge quantity of data and provide reliability."
"I found the map links, work links, and workflows valuable. They are important features."
"Deployment was simple and straightforward."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"I would like for them to incorporate additional transformations. A valuable aspect of the product is that it does inflight transformations and that could be expanded."
"The interface needs to be more user-friendly."
"The connections with SAP must be improved."
"There was a random change to our contract in a unilateral manner after the first year. The overall cost of using Fivetran was then unclear and this is the reason I would not recommend this solution."
"More connectors are needed for exotic, popular, and rising star portals."
"The environment must be more development-friendly."
"Some of the pain points we're looking at are trying to integrate some of the items in the Microsoft stack, so SharePoint and Excel, and then some of the newer Azure services."
"Fivetran should add more connectors because its competitors, like Airbyte, have more connectors."
"What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that."
"In terms of performance improvement and tuning, there should be a bit more guidance and documentation."
"Lacks ability to calculate cost of the product."
"Integration with Artificial Intelligence would benefit this solution."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
Fivetran is ranked 13th in Data Integration with 19 reviews while Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews. Fivetran is rated 8.0, while Informatica PowerCenter is rated 8.0. The top reviewer of Fivetran writes "Solution reduces time-to-value; high ROI". 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". Fivetran is most compared with AWS Database Migration Service, Qlik Replicate, Azure Data Factory, Oracle GoldenGate and Matillion ETL, whereas Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and AWS Glue. See our Fivetran vs. Informatica PowerCenter report.
See our list of best Data Integration vendors and best Cloud 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.