IT Central Station is now PeerSpot: Here's why

Informatica PowerCenter Room for Improvement

Technology Director at a computer software company with 1,001-5,000 employees

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.

View full review »
Principal Consultant at a tech services company with 501-1,000 employees

Though I wasn't able to explore all features of Informatica PowerCenter, it would be good if Informatica can also have connectivity with NoSQL compliant, unstructured data sources, e.g. Microsoft Azure Data Factory or Talend.

The cloud-based solution mostly focuses on continuous data stream processing, but not on batch processing. If Informatica enhances this cloud-based solution to also do the batch processing of data, and also integrate semi-structured and unstructured data processing, that will be more beneficial.

View full review »
IhabBekhiet - PeerSpot reviewer
Service Delivery Manager & Data Governance Consultant at Master Works

It would be nice to move from Windows tools (like Developer, Designer, or Manager) and have everything in one place like DATAQ developer, which is eclipse-based and user-friendly. 

CDC needs more improvement. It's stable and has good features, but it's only easy to develop if you are familiar with Linux. 

Sometimes a new monitor will not be accurate in logging or you'll open a log and get a misleading error message. The connection parameter is sometimes inaccurate, or the parameter will not load. Proactive Monitoring doesn't work very well with all of the Informatica processes. The latest version came out five years ago and there has been no enhancement since then. It doesn't make sense for a product to be ranked number one but have no enhancements. The product hangs and you can lose control for several hours. It works, but it hangs. 

View full review »
Buyer's Guide
Informatica PowerCenter
August 2022
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: August 2022.
622,949 professionals have used our research since 2012.
Ravi Kuppusamy - PeerSpot reviewer
CEO and Founder at BAssure Solutions

PowerCenter seems to be a little bit higher side of cost. Customers are thinking about alternatives. Talend seems to be a pure Java-based thing, however, there are some technical hiccups there. There are a few finance companies are probably started using Talend as a competition tool for Informatica. Most of the smaller companies are trying to build open-source-based ETL tools.

It should be more cloud-centric than on-prem-centric. That is where the problem with Informatica.

View full review »
Muharrem Iseri - PeerSpot reviewer
Managing Partner at Caligo

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. 

View full review »
Franklin Nascimento - PeerSpot reviewer
Principal Associate at Data Meaning, Inc.

To be honest, we didn't find big issues with this tool. All the issues we found, we were able to fix. We don't have any issues with the tool so far.

I would like to see this solution change the way it creates workflows. In Alteryx, for example, it's easier to build the workflow because of the way it was built, while PowerCenter was built in a more complex way to be able to process a large number of roles. The way PowerCenter creates the workflows is much more complex than the others, but nothing big. It's just that it's the old way. It would be good to recreate the entire interface to make it easier for users to build workflows. This is what I'd like to see in the next release.

View full review »
RobertoMessora - PeerSpot reviewer
Head of Business Integration and Architecture at Jakala

The solution currently requires quite an established data center in place because there is no option for software as a service so the best option to install the platform is on-prem. I know Informatica is thinking about it because they are introducing a brand new platform for big data management, but it doesn't yet have the same level of features as PowerCenter. This is something they can improve on. There are some significant differences between the two platforms.

The other issue is price. I understand this is a high-level professional tool designed for big companies that have a great need for managing huge amounts of data and I understand these kinds of tools are quite expensive, but sometimes the cost is too high. Their focus is obviously a high-level market but I think there would be other companies who would want to use it but it's too expensive for them. 

I'd like to see improved on-prem support like Cloudera which is very oriented towards traditional databases, like Oracle, SQL Server and others. 

View full review »
Director at a financial services firm with 10,001+ employees

What I didn't like about it is that the platform itself is not great at distributed processing. When you need high parallel processing, it has some inherent issues. We had to use Java transformation, and it did not go very well. I have heard that it is going to the cloud, but we haven't tried that. We have Informatica in-house, and we thought it would go with ADF. Microsoft is leaning on us to do that because we're working with Azure. So, I don't know much about cloud features.

The pricing model is a little bit difficult for development tools versus running the system in production. So, it has some shortcomings, but in general, it is not bad.

View full review »
Software Test Automation Engineer at a insurance company with 1,001-5,000 employees

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. As it is now, writing custom transformations is not user-friendly.

View full review »
Computer system engineer at Groupe Casino

Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside.

We would like to be able to communicate with our Google Cloud platform. This feature probably exists, but I'm not sure if we tested it. 

View full review »
Data Architecture/Management at a consultancy with 10,001+ employees

The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through. I would say that's the biggest issue.

View full review »
Senior Associate at PwC Acceleration Centers

Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user.

In a future release of Informatica PowerCenter, they should add more flexibility on re-usability options. Reusing any setup developed on Informatica PowerCenter, more options to make it reusable, exporting the setup, or importing the setup to any project folder or anywhere in Informatica PowerCenter so that we can use it as a plug-and-play option.

View full review »
Director at Lolatech

In the future, I would like to see Informatica PowerCenter integrate a more powerful dashboard.

View full review »
Senior Architect at a computer software company with 10,001+ employees

Support could be better. Technical support's friendly, but we should be able to get responses from them more quickly.

View full review »
Senior Consultant at a computer software company with 1,001-5,000 employees

Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. 

It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff.

Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help.

View full review »
Practice Head - Advanced Analytics & Cloud at a computer software company with 201-500 employees

I believe that people are shifting to more agile, flexible platforms not only in this era but also in the last two or three years. This is happening not only on data management platforms but also on analytics platforms. Platforms for visualizing data dashboards. We used to have very rigid tools like Cognos and MicroStrategy, but Tableau and Power BI have recently taken over. The same can be said for data management. 

Informatica, in my opinion, is very rigid and not very flexible, whereas platforms like Alteryx or Matillion are very flexible and agile.

View full review »
CIO at a tech services company with 1,001-5,000 employees

It is very difficult to learn.

The documentation could be improved. For example, if they were to create a system like SAS Books or IBM Redbooks that includes books on how to install, and how to troubleshoot problems, then it would be great.

I would like to see a centralized dashboard that can be used to access all of the Informatica products, rather than having a set of fragmented applications. A consolidated system with everything in a single platform would make it easier for technicians, as well as when it comes to purchasing it. That would be amazing.

View full review »
Saravana Babu - PeerSpot reviewer
Project Manager at a tech services company with 10,001+ employees

Integrating new tools can be tricky and challenging.

View full review »
MohamedFouda - PeerSpot reviewer
Informatica Developer at a computer software company with 51-200 employees

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. 

View full review »
Resource Manager at a computer software company with 1,001-5,000 employees

An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing. Also, the EPA related data processing should be improved. 

Processing capabilities should be streamlined.

I prefer a third party scheduler tool to that of Informatica scheduler, since the latter is not one which is very physical. The solution is not so helpful if one wishes to perform multiple tasks simultaneously. 

View full review »
Technical Lead at a financial services firm with 5,001-10,000 employees

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.

View full review »
AliRaza1 - PeerSpot reviewer
Senior Technical Lead at Speridian Technologies

There is some room for improvement in terms of pricing.

View full review »
Associate Manager at a consultancy with 501-1,000 employees

Its scalability can be improved. It is not scalable.

View full review »
Information Technology Security Analyst at a tech services company with 10,001+ employees

I would like to see it be able to import data from NoSQL.

View full review »
Senior Data Architect at a manufacturing company with 10,001+ employees

If you were migrating or connecting with multiple sources, initially there were issues that caused network latency. In the latest version, there are fewer bugs.

The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement.

Being able to generate reports on all of the status of the monitoring tools and the job qualities would be very helpful to provide to the operational team.

View full review »
SureshSwaminathan - PeerSpot reviewer
Senior Software Engineer at Depository Trust & Clearing Corporation

We need another tool for monitoring. It would be easier if all the features were consolidated into one tool.

View full review »
RemonHanna - PeerSpot reviewer
Data Engineer at a tech services company with 51-200 employees

The performance of Informatica PowerCenter could improve.

View full review »
Associate Director at a consultancy with 1,001-5,000 employees

One of the things that I found lacking is that there should be some sort of a calculator where you can input your requirements regarding the number of data switches required, number of users, and the number of data switches in order to get a general idea of cost. It would save me time rather than having to run to the company to get the information. 

View full review »
Lead BI&A Consultant at a computer software company with 10,001+ employees

The pricing could be improved.

View full review »
Team Lead Manager at a manufacturing company with 10,001+ employees

PowerCenter has yet to announce additional features. The face that it has not made improvements is fine, as it is very easy to integrate. We are in touch with the vendors of products other than Informatica PowerCenter. 

The reason I chose to rate the solution as a nine out of ten is because there is a need to buy a separate license if one wishes to connect with some kind of SAP system, such as SalesForce. 

View full review »
Raghavendra Rao - PeerSpot reviewer
Solution Architect at Refinitiv

Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version.

View full review »
Buyer's Guide
Informatica PowerCenter
August 2022
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: August 2022.
622,949 professionals have used our research since 2012.