No more typing reviews! Try our Samantha, our new voice AI agent.

Informatica Data Engineering Streaming [EOL] vs Informatica PowerCenter comparison

Why PeerSpot?
 

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
No ranking in other categories
Informatica PowerCenter
Average Rating
8.0
Reviews Sentiment
6.9
Number of Reviews
85
Ranking in other categories
Data Integration (4th), Data Visualization (13th)
 

Featured Reviews

DK
BI Practice Lead at a tech services company with 51-200 employees
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.
Hemanthreddy Vakiti - PeerSpot reviewer
Data Engineer at a tech vendor with 10,001+ employees
Streamlined daily sales workflows have reduced team size and enabled earlier, accurate reporting
One of the best features I appreciate about Informatica PowerCenter is that anyone with minimal knowledge of ETL can easily use it. It has four different interfaces: Monitor, Repository, Designer, and Workflow Manager. With our use case, we can easily go to that particular interface and use it. Another valuable feature is the use of Mapplets; if we have one mapping created that we want to use again and again for other workflows, we can create a Mapplet and save it so that we can reuse the mapping, reducing our workload. Informatica PowerCenter has positively impacted my organization because, as I mentioned previously, the development team has been reduced to half since we moved to it due to its easy interface and the reusability of Mapplets. It has also saved us a lot of time; for example, it has saved nearly one hour per day on monitoring and workflow tasks. Saving one hour a day is key because it has led us to report the data to business users one hour earlier than the usual time. If there are any anomalies or defects in the data, we can easily rectify them within that hour, which reduces the chance of errors in the data. Regarding cost, the number of people working on the project has been reduced to half, thus significantly decreasing costs for our organization since we moved to Informatica PowerCenter.

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."
"Informatica is scalable, it's perfect."
"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."
"It's quite suitable for our needs."
"In summary, this is a good tool and I definitely recommend it."
"The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources."
"Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology."
"The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible."
"What I like the most is that we have to deal with less while writing the queries."
 

Cons

"Skill requirement is required. There is a learning curve."
"This product is going to decommission in the next couple of years."
"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."
"The licensing is difficult."
"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."
"Improvement is needed in terms of some new transformation because API integration and all those things are very critical nowadays."
"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."
"We had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions."
"I would like to see an improvement in the digital adoption."
 

Pricing and Cost Advice

Information not available
"I consider this to be an expensive product."
"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."
"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."
"We have found the pricing very cost-effective. The licensing is CPU and data source-based."
"The price is mostly reasonable."
"I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have."
"According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products."
"Our client has purchased the license, and we are using it."
report
Use our free recommendation engine to learn which Streaming Analytics solutions are best for your needs.
917,433 professionals have used our research since 2012.
 

Comparison Review

it_user90069 - PeerSpot reviewer
BI Expert at a healthcare company with 1,001-5,000 employees
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
32%
Construction Company
9%
Computer Software Company
7%
Media Company
6%
Financial Services Firm
16%
Manufacturing Company
8%
Outsourcing Company
8%
Construction Company
6%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
No data available
By reviewers
Company SizeCount
Small Business14
Midsize Enterprise11
Large Enterprise76
 

Questions from the Community

Ask a question
Earn 20 points
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, Microsoft, Apache and others in Streaming Analytics. Updated: September 2026.
917,433 professionals have used our research since 2012.