We just raised a $30M Series A: Read our story
2018-03-05T18:47:00Z

What needs improvement with Informatica PowerCenter?

27

Please share with the community what you think needs improvement with Informatica PowerCenter.

What are its weaknesses? What would you like to see changed in a future version?

ITCS user
Guest
2626 Answers

author avatar
Top 20Real User

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.

2021-08-17T13:30:49Z
author avatar
Top 20Real User

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.

2021-07-30T09:56:48Z
author avatar
Top 5LeaderboardReal User

Its scalability can be improved. It is not scalable.

2021-04-29T12:26:59Z
author avatar
Top 10Real User

Integrating new tools can be tricky and challenging.

2021-04-06T02:46:58Z
author avatar
Top 5LeaderboardReal User

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.

2021-02-22T21:16:55Z
author avatar
Top 20Real User

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.

2021-02-16T12:21:55Z
author avatar
Consultant

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.

2021-02-08T19:24:33Z
author avatar
Top 5LeaderboardReal User

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

2021-02-08T10:22:15Z
author avatar
Top 10Real User

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.

2021-02-01T20:44:36Z
author avatar
Top 20Real User

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.

2020-12-28T16:35:14Z
author avatar
Top 20Real User

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

2020-11-09T15:06:22Z
author avatar
Top 10Real User

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

2020-11-01T09:32:00Z
author avatar
Top 20Real User

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.

2020-09-27T04:09:50Z
author avatar
Top 20Real User

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.

2020-09-13T07:02:27Z
author avatar
Top 20Real User

I found it is kind of weird that not all of the mapping changes are treated as true changes.

2019-10-24T14:54:00Z
author avatar
Top 10Real User

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.

2019-10-10T20:02:00Z
author avatar
Real User

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.

2019-08-01T05:43:00Z
author avatar
Reseller

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.

2019-07-31T05:51:00Z
author avatar
MSP

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.

2019-07-31T05:51:00Z
author avatar
Real User

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.

2019-07-31T05:51:00Z
author avatar
Real User

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.

2019-07-29T10:11:00Z
author avatar
Top 5LeaderboardReal User

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.

2019-07-28T07:34:00Z
author avatar
Consultant

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.

2019-07-18T11:31:00Z
author avatar
Real User

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.

2019-05-02T01:57:00Z
author avatar
Real User

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.

2018-05-23T10:30:00Z
author avatar
Real User

* 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.

2018-03-05T18:47:00Z
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: October 2021.
542,608 professionals have used our research since 2012.