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.
"It provides monitoring and we can therefore be aware of what is happening when we are handling jobs."
"It reduces a lot of legacy coding."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"It has good standard features for ETL development."
"The number of docs has been reduced drastically, which is very good."
"Informatica PowerCenter is a very good ETL tool."
"It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases."
"The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files."
"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 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."
"A helpful feature for us is the integration with NoSQL databases."
"The most valuable features are the ETL tools."
"The initial setup was quite straightforward. The deployment took between two and three days."
"We're sold on the customization part of the solution."
"A very user friendly solution."
"The standout feature for me is the user-friendly nature of the components."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The pricing could be improved."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"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."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources."
"I would like to see an improvement in the digital adoption."
"In terms of features, it has all the features that I need. However, it consumes a lot of resources. It is using a lot of RAM, and they need to fix the issue related to resource consumption. It currently requires more than 24 gigabytes of RAM, which is a big amount of RAM."
"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."
"The security features could be improved."
"When faced with a challenge, such as the necessity to link up with an unconventional data source like the legacy Cyprus Vision database that wasn't inherently supported by Talend, I had to resort to writing Python code to establish the connection."
"Inter-version compatibility is a problem, and migration projects between versions are required."
"The user interface could be made simpler."
"The stability of the solution could improve when running jobs. There can be errors when running projects but in the end, it works well and the errors do not impact the result."
"I would say that writing to JSON is kind of a pain. It reads from a JSON file pretty well, but writing to a JSON file is not so great because its components are not good."
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.