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.
Deepak Shiv - PeerSpot reviewer
Provides multiple transformations in one toolset and helpful when extracting data from multiple sources
Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify errors. In addition, there are KB articles published by Informatica that are really helpful. So, error handling and the KB articles provided by Informatica are very helpful. Even if you face any issues or errors, we can usually resolve them. If the error cannot be solved with Informatica PowerCenter, we can raise a case with Informatica, and their support team will help us address that issue. If it cannot be solved with that particular version, they will consider it and try to solve it with the next patch or hotfix. AI Initiatives: Our company also has organizational AI or machine learning initiatives. However, Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool. It doesn't have a significant role in the field. It is just a small ETL on-premises tool. So basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud and Informatica Cloud), where their AI comes into the picture. But for Informatica PowerCenter, AI does not come into the picture at all.

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 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."
"PowerCenter performs well during data transformation and optimization."
"It reduces a lot of legacy coding."
"The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness."
"I like the completeness of the way I can build ETL workflows."
"I found the map links, work links, and workflows valuable. They are important features."
"It works with any multi-databases, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use."
"The reliability of the product and the way of orchestration of different services is valuable to us."
 

Cons

"Skill requirement is required. There is a learning curve."
"The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive."
"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."
"I would like to see an improvement in the digital adoption."
"The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through."
"PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier."
"It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly."
"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."
"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."
 

Pricing and Cost Advice

Information not available
"The price of Informatica PowerCenter is expensive, but it does give value."
"The pricing is a little expensive, but in the same range as IBM and other competitors."
"I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price."
"We are satisfied with the pricing."
"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."
"The solution is in the middle price range compared to other solutions."
"Since the solution's cost is higher, I rate the pricing as a five out of ten."
"We have found the pricing very cost-effective. The licensing is CPU and data source-based."
report
Use our free recommendation engine to learn which Streaming Analytics solutions are best for your needs.
859,957 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
16%
Manufacturing Company
6%
Educational Organization
5%
Financial Services Firm
18%
Computer Software Company
12%
Manufacturing Company
8%
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.
859,957 professionals have used our research since 2012.