Try our new research platform with insights from 80,000+ expert users

Informatica PowerCenter vs Talend Open Studio comparison

 

Comparison Buyer's Guide

Executive SummaryUpdated on Jan 12, 2025

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

Informatica PowerCenter
Ranking in Data Integration
2nd
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
81
Ranking in other categories
Data Visualization (8th)
Talend Open Studio
Ranking in Data Integration
5th
Average Rating
8.0
Reviews Sentiment
6.8
Number of Reviews
50
Ranking in other categories
No ranking in other categories
 

Mindshare comparison

As of April 2025, in the Data Integration category, the mindshare of Informatica PowerCenter is 9.7%, down from 11.9% compared to the previous year. The mindshare of Talend Open Studio is 4.9%, down from 5.1% compared to the previous year. It is calculated based on PeerSpot user engagement data.
Data Integration
 

Featured Reviews

Lars Borchers - PeerSpot reviewer
A stable and reliable product that provides a variety of features for data integration
The solution is not for newcomers. It has an old touch. The solution must improve the integration with new services. It was part of the program at Informatica when they moved to their cloud platform. It is integrated. However, from an on-premise perspective, we need to buy licenses for PowerExchange. If we want a native driver to access a special service, we need to extend our license to those services. It is expensive. I don't like that it's not all included in the solution.
Jason Hale - PeerSpot reviewer
Intuitive interface and documentation make it simple to build jobs and APIs and logging helps pinpoint and resolve issues quickly
Talend is doing a lot of work at the moment, and it's not there yet, but the whole platform could be managed in a SaaS-type environment. You still need to have the Studio running on a virtual desktop or a PC. They will get to be able to do the whole thing inside your browser, so you don't need to install anything locally. It's down the track, and it's the nirvana that we were looking for in Boomi. But the biggest challenge they have is that the platform is so focused on the Studio for all of its development. They'll probably get there, but they have such a mature Studio client that it's a huge amount of work to get all of that functionality into a browser or SaaS platform. That's pretty much the biggest flaw with the Talend environment—being reliant on the Studio, which needed to be on a local machine. The only other thing is that you have to integrate into an API gateway. We're in Azure, so we use Microsoft Azure Gateway. It doesn't come with its own gateway, which is another sort of big plus side that we saw in Boomi. Talend isn't quite there yet with the API gateway. Other than that, it's bloody hard to find something because it just seems to be all good.

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The ability to scale through partitions helped us to improve the performance."
"It is UI friendly and has all the advantages of an ETL tool."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute. It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team."
"My overall experience with Informatica PowerCenter is positive."
"UI-based ability to create data mapping."
"It has helped us monetize."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"The product's initial setup phase was easy."
"A very user friendly solution."
"I can connect with different databases such as Oracle Database or SQL Server. It allows you to extract the data from one database to another. I can structure the data by filtering and mapping the fields. It is very user-friendly. You need to know the basics of SQL development or SQL queries, and you can use this tool."
"Talend Studio has the ability to use it to ensure data quality."
"The main differentiator that I have seen between Talend and other data integration tools is the ability to view the data pipeline in the form of a program."
"The best thing I have found with Talend Open Studio is their major support for the lookups."
"The most valuable features are the ETL tools."
"We're able to handle large amounts of data with ease."
 

Cons

"I found it is kind of weird that not all of the mapping changes are treated as true changes."
"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."
"Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile."
"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."
"We need another tool for monitoring. It would be easier if all the features were consolidated into one tool."
"The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer."
"If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B."
"The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it."
"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 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 rate Talend Open Studio's stability an eight out of ten. Talend has some problems sometimes."
"Talend Open Studio has a lot of capabilities, but there is some restriction. For example, if we want to connect to an SAP system, Open Studio cannot do it. We need to go with an enterprise version. Additionally, the monitoring features could improve."
"It is complicated to understand the configuration process for email components."
"Multiple products are there within the product suite. That can be actually trimmed down."
"The technical support and documentation need a lot of work to come up to standard."
"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."
 

Pricing and Cost Advice

"The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good. In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution. On a scale of one to five, I'm rating its price a three."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"It is for big enterprises. We have leveraged Informatica for big enterprises but not for small and medium enterprises because it is a very costly product as compared to other products. We propose this solution only for enterprise customers. For small to medium enterprises, we would propose the Microsoft solution. Its licensing is currently bundle-wise. It should be features-wise and not bundle-wise."
"I consider this to be an expensive product."
"A basic setup can be from $100,000 and up annually."
"Its licensing is expensive in terms of scaling."
"We have found the pricing very cost-effective. The licensing is CPU and data source-based."
"Our customers pay a licensing fee yearly."
"Pricing and licensing are fairly straightforward. It is reasonably priced and managed."
"We are using the free version of the tool, because the enterprise version is a little expensive."
"The solution will be more expensive if you have a low data volume and a large number of developers."
"There are many versions available and one is open-sourced which is free."
"Right now, because we're using the open-source version, there's no cost."
"Price could be lower. It is getting too expensive when compared to some other solutions, which is actually a little bit concerning."
"It is an open-source tool which means it is a free solution."
"The cost, particularly in Africa, is quite high."
report
Use our free recommendation engine to learn which Data Integration solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
Feb 20, 2014
Informatica PowerCenter vs. Microsoft SSIS - each technology has its advantages but also have similarities
Technology has made it easier for businesses to organize and manipulate data to get a clearer picture of what’s going on with their business. Notably, ETL tools have made managing huge amounts of data significantly easier and faster, boosting many organizations’ business intelligence operations…
 

Top Industries

By visitors reading reviews
Financial Services Firm
18%
Computer Software Company
12%
Manufacturing Company
7%
Government
7%
Financial Services Firm
16%
Computer Software Company
14%
Manufacturing Company
8%
Government
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

How does Azure Data Factory compare with Informatica PowerCenter?
Azure Data Factory is flexible, modular, and works well. In terms of cost, it is not too pricey. It offers the stability and reliability I am looking for, good scalability, and is easy to set up an...
Which is better - SSIS or Informatica PowerCenter?
SSIS PowerPack is a group of drag and drop connectors for Microsoft SQL Server Integration Services, commonly called SSIS. The collection helps organizations boost productivity with code-free compo...
Which Informatica product would you choose - PowerCenter or Cloud Data Integration?
Complex transformations can easily be achieved using PowerCenter, which has all the features and tools to establish a real data governance strategy. Additionally, PowerCenter is able to manage huge...
How does Talend Open Studio compare with AWS Glue?
We reviewed AWS Glue before choosing Talend Open Studio. AWS Glue is the managed ETL (extract, transform, and load) from Amazon Web Services. AWS Glue enables AWS users to create and manage jobs in...
What do you like most about Talend Open Studio?
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...
 

Also Known As

PowerCenter
Open Studio
 

Overview

 

Sample Customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Almerys, BF&M, Findus
Find out what your peers are saying about Informatica PowerCenter vs. Talend Open Studio and other solutions. Updated: February 2025.
844,944 professionals have used our research since 2012.