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

Informatica Data Engineering Streaming vs Informatica PowerCenter comparison

 

Comparison Buyer's Guide

Executive Summary

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 Data Engineerin...
Average Rating
8.0
Reviews Sentiment
6.4
Number of Reviews
1
Ranking in other categories
Streaming Analytics (17th)
Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
82
Ranking in other categories
Data Integration (4th), Data Visualization (9th)
 

Mindshare comparison

Informatica Data Engineering Streaming and Informatica PowerCenter aren’t in the same category and serve different purposes. Informatica Data Engineering Streaming is designed for Streaming Analytics and holds a mindshare of 1.5%, up 1.1% compared to last year.
Informatica PowerCenter, on the other hand, focuses on Data Integration, holds 8.5% mindshare, down 11.6% since last year.
Streaming Analytics
Data Integration
 

Featured Reviews

DK
Helps with real-time data processing and improves decision-making overall
It improves decision-making overall for the company. Informatica is usually the tool for setting up the data, streaming the data into your data warehouse from your source, transforming the data, and preparing and modeling it into some desired format. It improves the performance. You need to know how to use it and how to implement it, but it improves performance.
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.

Quotes from Members

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

Pros

"It improves the performance."
"The reliability of the product and the way of orchestration of different services is valuable to us."
"One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool."
"Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"It has very good monitoring and process monitoring."
"Reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"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."
 

Cons

"Skill requirement is required. There is a learning curve."
"Unstructured data handling is an important area with a shortcoming that needs improvement in the solution."
"Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers."
"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."
"With all these no code/low code platforms, Informatica still forces us to use the ANSI format of SQL for joins, especially left outer join."
"Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration."
"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."
"I would like to see an improvement in the digital adoption."
"I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases."
 

Pricing and Cost Advice

Information not available
"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."
"Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products. Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"Informatica PowerCenter is reasonably priced. It is less expensive than Pentaho. There is a standard version fee in Taiwan. It is a one-time yearly subscription price that is approximately $3,010 US dollars for three users."
"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."
"I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"We are satisfied with the pricing."
report
Use our free recommendation engine to learn which Streaming Analytics solutions are best for your needs.
860,825 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
27%
Computer Software Company
15%
Manufacturing Company
6%
Educational Organization
5%
Financial Services Firm
19%
Computer Software Company
12%
Manufacturing Company
7%
Insurance Company
7%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
 

Questions from the Community

What needs improvement with Informatica Data Engineering Streaming?
Skill requirement is required. There is a learning curve.
What is your primary use case for Informatica Data Engineering Streaming?
We implement business intelligence solutions, including data warehousing tools, data integration to load data into warehouses, and then creating reports.
What advice do you have for others considering Informatica Data Engineering Streaming?
Overall, I would rate the solution an eight out of ten. Usually, Informatica is for big clients because of its pricing, and it also requires some skill sets. It requires investment into a proper da...
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...
 

Also Known As

Big Data Streaming, Informatica Intelligent Streaming, Intelligent Streaming
PowerCenter
 

Overview

 

Sample Customers

Jewelry TV
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank
Find out what your peers are saying about Databricks, Amazon Web Services (AWS), Microsoft and others in Streaming Analytics. Updated: June 2025.
860,825 professionals have used our research since 2012.