Informatica PowerExchange Room for Improvement

reviewer1286829
Data Management Consultant & Delivery Manager at a tech company with 201-500 employees
Real-time has not been enhanced that much over the past few years. There have not been as many features added like they did before. When comparing Informatica PowerExchange to other competing technologies, like Oracle GoldenGate, GoldenGate is selling more features and adding more functions. It's why PowerExchange is still behind GoldenGate for certain functions. The higher availability and fill over capabilities is not that strong, so it needs to be enhanced more. It's not an issue, it's a limitation. Like some new data types that are not supported at all by PowerExchange, some new Oracle table types, like some IUT tables, for example. So, it's missing some features. GoldenGate, for example, is supporting everything in Oracle. It's not a good product in the end. However, Informatica is maybe supporting 80% of the things in Oracle systems. So, it is still missing some functions and some features still need to be supported. For example, if you have data stored like XML content and Oracle table, you cannot get it in real-time using PowerExchange. Supporting all the different data types which are still not supported by the product. Adding more flexibility and what I call administration utilities to manage the product in some graphical way, or some new easy way to use, enhancing the high availability and fill over capabilities of the products. View full review »
Anirban Bhattacharya
Practice Head, Data & Analytics at a software R&D company with 10,001+ employees
I think Informatica could be improved if they were to get into the data exploitation side of things. The value chain of exporting, reporting, visualizing, etc. That seems to be a blind spot for Informatica. If it were to diversify a little more, maybe with the reporting and visualization utility, it would be an add-on to PowerExchange. From a product strategy, Informatica seems to be getting fragmented by diversifying to various product lines and then going into the market. If I were to have any additional features, it would be diagnostics and reporting visualization. View full review »
Prasun Nesu
Solution Integration and Implementation Manager at a comms service provider with 10,001+ employees
Informatica is very expensive in all aspects, so the pricing is something that could be improved. We are using many other tools for data ingestion that are part of the Apache family, NiFi. When we see that we have some challenges we then use other tools. View full review »
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: March 2020.
406,860 professionals have used our research since 2012.
ArunKumar4
Specialist - Technology at Synechron
Saving a COBOL Copybook can be difficult and it would be nice if it were simplified. The complexity arises when we use recursive statements and redefined classes. Technical support can be improved with respect to delays in ticket response time. I would like to see more implements for big data including ORC file support. This is what most of our clients are now demanding. View full review »
reviewer1285233
Solution / Application Architect at a tech services company with 1,001-5,000 employees
The one place where it could be improved is definitely pricing. That's a very big problem. It depends product to product, but pricing is an issue. They have their own way of pricing it. I'm coming from a technical background, so I don't get myself involved much in pricing. Additionally, I definitely would love to have a PowerExchange tool without having to connect to the call center, to just to load the data directly into the respective target components. This would be very preferable. All in all, they already have a good monitoring tool. It would be better if they could add the feature where we could avoid the call center feed and use PowerExchange directly to our target databases. View full review »
Liana Iuhas
CEO at Quark Technologies SRL
Integration with the largest number of databases and other systems would be important. We worked a lot with this ETL tool and in my opinion, it is the best on the market and what we missed in Informatica, compared with ETL. For example, each component in parallel with a configurable parallel made on the same machine or even on different machines. It's that kind of thing that I don't think Informatica PowerExchange can provide at this moment. In Informatica PowerExchange we ran jobs in parallel but not components with a parallel degree. View full review »
reviewer1091745
OBIEE Developer at a tech services company with 51-200 employees
The solution needs better integration with other tools. The solution needs to be more user-friendly. Right now, a first time user needs to get training before they can use the solution. View full review »
reviewer1314648
IT Architect at a financial services firm with 10,001+ employees
I would like to have easier integration with cloud platforms. View full review »
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: March 2020.
406,860 professionals have used our research since 2012.