Informatica PowerCenter Room for Improvement

reviewer1318821
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 »
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 »
MohamedKhamis
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 »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
464,655 professionals have used our research since 2012.
RobertoMessora
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 »
reviewer1293765
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 »
AmanyEldaly
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 »
Senthil Kumar Kesavan
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 »
Innodirec67
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 »
reviewer1498596
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 »
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 »
reviewer1245828
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 »
SeniorEtddda
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 »
reviewer1448301
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 »
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 »
SureshSwaminathan
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 »
reviewer1407579
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 »
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 »
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 »
reviewer1215849
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 »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: February 2021.
464,655 professionals have used our research since 2012.