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."
"For us, Fivetran has been able to scale both in terms of the data we bring into our warehouse and the amount of data that we use as well."
"The ease of usability is the most valuable feature. It's very easy and quick to set up. It also has a central hub as opposed to GoldenGate which is one direct interface. For GoldenGate I would have needed three interfaces whereas with HVR I have a central interface that manages everything."
"The most important feature of the solution is its ability to build data pipelines in less time."
"The simplicity of the solution is its valuable feature."
"Making the decision to implement Fivetran was supported by the fact that they have better connectors than other competitors."
"Fivetran's most valuable feature is replication."
"The solution is stable. We've never faced any stability issues."
"What I like the most is that we have to deal with less while writing the queries."
"I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions."
"Once you have learned Informatica, it is very easy to use."
"It's a complete package, which is why we use this solution."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"It has good standard features for ETL development."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"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."
"The environment must be more development-friendly."
"More connectors are needed for exotic, popular, and rising star portals."
"The connections with SAP must be improved."
"Fivetran is very expensive for data sources with a lot of rows, such as email data. I would like to see cheaper pricing for data sources like that."
"HVR Software's technical support could be improved. Whenever we log a case, the response that we get from the support is a bit delayed."
"The documentation can be laid out better to make it easier to find things, and I really wish there was built-in support for changing passwords. Some features don't work as advertised for the platform/repository database, and HVR is not always the fastest at getting results."
"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."
"The documentation is decent, but it's hard to find information online about Fivetran. For example, if you try to search for an error code, you won't find much information about it in forums."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"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."
"We had stability issues, mostly with JVM size."
"PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one."
"Its scalability can be improved. It is not scalable."
"Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was when it was PowerCenter, though it has some nice features. This Developer tool could be better."
"In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
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.