We performed a comparison between Informatica PowerCenter and Talend Open Studio based on our users’ reviews in four categories. After reading all of the collected data, you can find our conclusion below.
Comparison Results: Talend Open Studio comes out on top for paid support and Informatica PowerCenter comes out on top for its features. If you are looking for a solution that consumes fewer resources, then you should go with Informatica PowerCenter. However, if you are looking to start with a free data integration tool, Talend Open Studio would be the tool for you.
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"It has helped us monetize."
"Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application."
"It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle."
"Talend is safe to use because it is very restrictive. It is easy to use when one learns how to manipulate data with SQL."
"We have contacted their technical support. They are great. They offer very professional help. If I need some technical answer, they are very professional. They are quick, professional, and very accurate."
"The solution's technical support is responsive and helpful."
"The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component."
"A helpful feature for us is the integration with NoSQL databases."
"It is user-friendly and the interface is good."
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"The most valuable feature for me when it comes to this solution is that it's easy to use."
"The solution does not scale."
"The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application."
"The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella."
"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."
"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."
"There can be scalability issues. Huge amounts of data ingestion will impact performance."
"Its scalability can be improved. It is not scalable."
"An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing."
"Talend Open Studio's interface does not provide a good experience...I would like to see better documentation and a more enhanced graphical interface in Talend Open Studio."
"Technical support and customer service need to be improved."
"The price for Talend Data Integration should be less expensive."
"Talent consumes a lot of resources on my PC."
"In terms of what can be improved, the scheduling is not there in the sister version, while it is there in the cloud one, which is a paid version. If all kinds of scheduling could be available on the Open Studio that we generally use and practice on, that would be great. The scheduling of the data migration is currently not available in the sister version of Talend Open Studio that we are working on. It is available in the advanced version of the Talend. This is the one thing that can be improvised."
"The technical support and documentation need a lot of work to come up to standard."
"The pricing could be lower. They should work to make it more affordable."
"In version 6.2 we did encounter issues with the job servers and specifically with ESB. Version 6.3 is better but large jobs can cause the MDM server to fall over, requiring a reboot."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Talend Open Studio is ranked 5th in Data Integration with 47 reviews. Informatica PowerCenter is rated 8.0, while Talend Open Studio is rated 8.0. 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". On the other hand, the top reviewer of Talend Open Studio writes "An open-source ETL tool, when deployed on-premises, requiring an easy installation phase". Informatica PowerCenter is most compared with Informatica Cloud Data Integration, Azure Data Factory, SSIS, Databricks and SAP Data Services, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, Talend Data Management Platform and Oracle Data Integrator (ODI). See our Informatica PowerCenter vs. Talend Open Studio report.
See our list of best 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.