Compare Informatica PowerCenter vs. StreamSets

Cancel
You must select at least 2 products to compare!
Informatica PowerCenter Logo
40,460 views|32,402 comparisons
StreamSets Logo
8,286 views|6,129 comparisons
Most Helpful Review
Use StreamSets? Share your opinion.
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2021.
456,719 professionals have used our research since 2012.
Quotes From Members

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

Pros
"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.""Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better.""The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage.""In the end, you have structured, proper data for use in an integrated BI solution.""The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand.""Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical.""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.""The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed."

More Informatica PowerCenter Pros »

"It is really easy to set up and the interface is easy to use."

More StreamSets Pros »

Cons
"The developer tool documentation can be enhanced with a more clear explanation of each utility, accompanied by relevant examples, so that developers are able to create programs with ease.""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.""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.""Integration with Artificial Intelligence would benefit this solution.""I would like to see an improvement in the digital adoption.""The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica.""Include more instruments for LOGs analysis, interpretation, and job corrections.""I found it is kind of weird that not all of the mapping changes are treated as true changes."

More Informatica PowerCenter Cons »

"We've seen a couple of cases where it appears to have a memory leak or a similar problem."

More StreamSets Cons »

Pricing and Cost Advice
"Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis.""Its maintenance is expensive.""It's much more expensive, almost three times more expensive than most other solutions.""We are satisfied with the pricing.""I consider this to be an expensive product."

More Informatica PowerCenter Pricing and Cost Advice »

"We are running the community version right now, which can be used free of charge."

More StreamSets Pricing and Cost Advice »

report
Use our free recommendation engine to learn which Data Integration Tools solutions are best for your needs.
456,719 professionals have used our research since 2012.
Questions from the Community
Top Answer: Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System.
Top Answer: Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was… more »
Ask a question

Earn 20 points

Ranking
1st
Views
40,460
Comparisons
32,402
Reviews
14
Average Words per Review
367
Rating
8.2
20th
Views
8,286
Comparisons
6,129
Reviews
1
Average Words per Review
399
Rating
8.0
Popular Comparisons
Compared 16% of the time.
Compared 11% of the time.
Compared 8% of the time.
Compared 7% of the time.
Compared 7% of the time.
Also Known As
PowerCenter
Learn
Informatica
StreamSets
Video Not Available
Overview

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.

StreamSets Dataflow Performance Manager was created to enable enterprises to harness their data in motion. It unifies visibility and control of dataflows, which reduces management costs, improves data quality and enables IT agility.

Offer
Learn more about Informatica PowerCenter
Learn more about StreamSets
Sample Customers
University of Texas MD Anderson Cancer Center, LexisNexis, RabobankCisco, Lithium Technologies, Cloudera, Elastic
Top Industries
REVIEWERS
Financial Services Firm18%
Retailer14%
Healthcare Company9%
Energy/Utilities Company9%
VISITORS READING REVIEWS
Computer Software Company38%
Comms Service Provider13%
Insurance Company6%
Financial Services Firm6%
VISITORS READING REVIEWS
Computer Software Company34%
Comms Service Provider12%
Insurance Company10%
Media Company8%
Company Size
REVIEWERS
Small Business14%
Midsize Enterprise10%
Large Enterprise76%
VISITORS READING REVIEWS
Small Business2%
Midsize Enterprise12%
Large Enterprise86%
No Data Available
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools. Updated: January 2021.
456,719 professionals have used our research since 2012.

Informatica PowerCenter is ranked 1st in Data Integration Tools with 16 reviews while StreamSets is ranked 20th in Data Integration Tools with 1 review. Informatica PowerCenter is rated 8.2, while StreamSets is rated 8.0. The top reviewer of Informatica PowerCenter writes "Assists us with integration as we migrate from on-premise to cloud, but it needs a performance analyzer". On the other hand, the top reviewer of StreamSets writes "Easy to set up and use, and the functionality for transforming data is good". Informatica PowerCenter is most compared with SSIS, Informatica Cloud Data Integration, Azure Data Factory, Oracle Data Integrator (ODI) and Oracle GoldenGate, whereas StreamSets is most compared with Talend Open Studio, Spring Cloud Data Flow, Azure Data Factory, Oracle GoldenGate and SSIS.

See our list of best Data Integration Tools vendors and best Cloud Data Integration vendors.

We monitor all Data Integration Tools 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.