Informatica PowerCenter Room for Improvement

Ricardo Pedro
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
I would like to see the inclusion of a tool that allows you to report performance metrics. For example, it can determine whether the connectivity is correct, or how long it's taking the integration to move data from one place to another. This would allow administrators to govern the performance and better maintain the solution. Having a tool that can work is nice, but we're not sure if it works accurately without something to evaluate performance. Integration with Artificial Intelligence would benefit this solution. The system should start to learn the behavior of your connections, and understand where your data is coming from to ensure that the process is being done correctly. As the system learns the stages, it will be able to easily identify problems. For example, if I have different databases where I want to store information, such as pictures in one and PDF files in another, it will be able to distinguish that. View full review »
Data Scientist at IME
The licensing cost for Informatica is very high. Other all-in-one solutions offer much lower prices. Also, sometimes with data capture, the solution doesn't support some data types so you must find an alternative, Informatica Data Replication, for instance. You end up buying two very expensive products to get just a little bit more functionality. They need to offer an all-in-one package. I'd like Informatica to provide more use cases. We have a huge knowledge base, but use cases in specific domains like healthcare, banking, and financial transactions would be helpful. There are some tools that exist for making predictions in different domains. I want something like that in Informatica so we can see use cases that showcase better management, better quality, and better governance, in different domains. The solution needs better support and training. Informatica can do a better job in making it clear at the beginning what is supported and not supported, and what the licenses include and do not include. That way we are better able to communicate with the clients and to get assistance from support. It would also save us time in raising issues with support if we knew what was covered. View full review »
Data Engineer at a tech services company with 51-200 employees
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. When we are dealing with multiple transformations and mapping, we cannot see the flow of our transformation until we run reports. It is not like Informatica Developer, where we can see every step of what we're doing and the flow of the mapping. With those solutions, we can see data and transformation and how it's affected by our expressions or anything we do. In Informatica PowerCenter, we cannot see any data in the transformation until the end or you may need to do some debugging, and it is very confusing for some people. They need to enhance their viewer so we can see data within the transformation and show the affected data. View full review »
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: March 2020.
407,401 professionals have used our research since 2012.
Director of Innovation & Development Department at a tech services company with 51-200 employees
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. I would like the solution to offer better metadata management. View full review »
Vijaya Saduvuv
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
It has everything we want. We were looking for a feature but they have already it in Informatica 10. We are using Informatica 9.6.1 but they added the feature we were thinking about in 10.1. View full review »
Kirill Slivchikov
Owner at 7Spring Consult
I hope that the next release of this solution will: * Work with HADOOP and other BigData solutions. * Have an ability to compile code to run it quicker. * Include new features for parallel job execution. * Include more instruments for LOGs analysis, interpretation, and job corrections. View full review »
Senior ETL Developer at Office of State Revenue
I would like to see an improvement in the digital adoption. It would be nice if they could be cheaper, because the training is very expensive as they do everything online. View full review »
Hassan Emam
Regional Manager at a tech services company with 201-500 employees
The cost and set up of the licenses could be improved. You need a lot of different licenses, depending on your setup, and it gets expensive. For example, we're connected with Oracle, be we need licenses for that plus the core server, Terradata, etc. It gets costly. There's also a feature that exists on IBM DataStage called CDC. It's not on Informatica PowerCenter, but if they could add a feature similar to this in the next release, it would be useful. View full review »
Kamal Bouyanzer
Project Manager at a comms service provider with 1,001-5,000 employees
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 is not good. Right now, we use Informatica to connect with the tools of big data. We have been able to connect Informatica with Teradata. I use Informatica to integrate the data of Teradata. Although we have a lot of functionality in Teradata, when you use Informatica as a connector, the compatibility with Teradata and Informatica it's not sufficient. In future releases, they need to have a good version of the cloud. View full review »
Mark Ma
Student at Ontario Ministry of Labour
* XML processing * Scheduler * Non-limit SQL qualifier embedded (right now 32K limitation) The Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design. View full review »
Chiranjeeva Reddy
ETL Reporting Analytics Consultant at Accenture
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. View full review »
Senior Associate at a tech consulting company with 1,001-5,000 employees
I found it is kind of weird that not all of the mapping changes are treated as true changes. View full review »
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: March 2020.
407,401 professionals have used our research since 2012.