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.
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse."
"It reduces a lot of legacy coding."
"To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle."
"Has a good visual tool for data mapping."
"The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand."
"Good interface, reasonable documentation."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"The product's initial setup phase was easy."
"The initial setup of the product was very easy."
"The API integration and big data approach are very good because of how you extract data from JSP files or big data web repositories like MongoDB."
"The most valuable feature of Talend Open Studio is the tMap component. There is a lot of functionality in one component."
"A very user friendly solution."
"The solution has a good balance between automated items and the ability for a developer to integrate and extend what he needs. Other competing tools do not offer the same grade of flexibility when you need to go beyond what is provided by the tool. Talend, on the other hand, allows you to expand very easily."
"The solution's technical support is responsive and helpful."
"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."
"What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved."
"Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud."
"The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica."
"While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product."
"As a connector to big data, it is not well developed. We've had problems connecting Informatica with Hadoop. The functionality to connect Informatica with Hadoop, for me it's not good."
"It should be more cloud-centric than on-prem-centric."
"It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux."
"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."
"As for improvement or additional features, I would like to know how to use Java in Talend and also how to use Talend in the cloud or in big data. I would prefer to have storage directly on Talend."
"The physical appearance of the product is an area of concern where improvements are required."
"he overall marketing and documentation of this product need to improve a lot."
"It doesn't have the ability to keep the repository of the source code (visual pipeline). It can be integrated with Git."
"The profiling perspective needs improvement. Instead of using it in the studio, we are using a different tool which is also provided by Talend. It's redundant."
"There used to be many Youtube channels that offered Talend training, but now there don't seem to be any. The solution should offer more online training resources."
"Inter-version compatibility is a problem, and migration projects between versions are required."
Informatica PowerCenter is ranked 3rd in Data Integration with 78 reviews while Talend Open Studio is ranked 5th in Data Integration with 48 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 "Intuitive interface and documentation make it simple to build jobs and APIs and logging helps pinpoint and resolve issues quickly". 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 AWS Glue. 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.