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.
"In the end, you have structured, proper data for use in an integrated BI solution."
"The interface is very clean and clear."
"I like the completeness of the way I can build ETL workflows."
"The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."
"The technical support is excellent."
"Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years."
"It's very easy to use it to develop mappings and workflows."
"I like the automated scheduling feature."
"Talend lets you do everything — mapping, workflow, and orchestration — in a single place."
"The standout feature for me is the user-friendly nature of the components."
"Talend Open Studio's installation process is easy. One just needs to install Java before installing the product"
"Talend Open Studio is easy to create jobs. We use the basic functionality and it is very good."
"This is a user-friendly solution that is easy to use."
"You can use Talend as a stand-alone application without customization to collect data and generate reports over dashboards. It's got great functionality."
"It is easy to use and covers most of the functions needed. We can use the code without any extra effort. The open source is very good. They have the same commercials with additional connectors. The graphical design environment is also very easy."
"The product's initial setup phase was easy."
"The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement."
"We had stability issues, mostly with JVM size."
"There is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce."
"PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it."
"Integration with Artificial Intelligence would benefit this solution."
"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"The solution could have better documentation on basic steps or blocks that specify what to do."
"Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations."
"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."
"It is complicated to understand the configuration process for email components."
"The price for Talend Data Integration should be less expensive."
"Inter-version compatibility is a problem, and migration projects between versions are required."
"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."
"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 high price of the solution is an area of concern where improvements are required."
"It needs better installation configuration for other databases. Although the installation allows you to select another database, this doesn't mean that all connection points in the application point to the database selected. You actually need to do a search through the entire install to locate the configuration settings and change them."
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 Alteryx Designer, whereas Talend Open Studio is most compared with SSIS, IBM InfoSphere DataStage, Talend Data Fabric, AWS Glue and Talend Data integration. 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.