Informatica PowerExchange [EOL] Reviews

We use PowerExchange to track data from the CDC, from sources like Oracle, DB2 or SQL Servers. That is pretty much what this tool is designed for and that's exactly what we use it for.

Overall, it's a good tool. It's currently number one on the market. It pretty much has all the necessary capabilities to pull the incremental data from the source system, technically speaking.

Overall, I am pretty satisfied.

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.

I've been working with Informatica for the last 18 years.

Their technical support is good. They have a good system of responding back to queries. Some queries gets resolved immediately and some queries take time to get resolved, but they do get resolved.

PowerExchange is a very good tool to work with. It has the capabilities and compared to other tools, this tool has more features. It collaborates with the call center on more features, so definitely, it's a good tool to work with.

On a scale of one to ten, I would give it an eight.

I would definitely recommend Informatica PowerExchange.

I am a solution architect and PowerExchange is one of the products that I work with. It is used for data integration and we use it to bring together all of the data from our legacy systems.

The most valuable feature is connectivity to data sources. I leverage everything in terms of connectors to big data such as DBMS, RDBMS, and conversion to COBOL format. 

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.

I have been working with Informatica PowerExchange for approximately five years. More generally, I have worked with Informatica products for between 10 and 12 years.

This has been a wonderful product and we have had no trouble with stability.

We have been in contact with technical support and there have been delays in terms of responding to tickets. Overall, I would rate support as average.

I have also used Informatica PowerCenter and the main difference is that PowerExchange is mainly cloud-hosted. People can access it from anywhere.

The suitability of this tool depends on the client and their needs. Based on their requirements, this is certainly a solution that I would recommend. For example, if their teams are really diversified and they need a quick solution in terms of integration then this is the right product for them.

So far, I have found this product to be good. That said, we did face some difficulties with respect to data connections where we needed a real-time feed to be consumed.

I would rate this solution a seven out of ten.

We primarily use the solution for getting the data from the source and loading it into the warehouse by performing data transformation.

We can now update data from several source files from both a database or java source.

The data transformation is the solution's most valuable feature.

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.

I've been using the solution for five years.

The solution is stable.

The solution is scalable. We can include many other sources and load it into the table. The solution can be scaled to various other transformations. We have 100-200 people using the solution currently. We do not plan to increase usage at this time.

We haven't had a reason to reach out to technical support yet.

The initial setup has a moderate amount of difficulty. It's not straightforward, but it's not too complex. Our deployment was a scheduled deployment. We planned it so that it happened incrementally.

We had a team that was specialized in Informatica handle the implementation.

I'd rate the solution eight out of ten. I'd rate it higher if it was more user-friendly and had better integration with other tools.