What is our primary use case?
We use PowerExchange for operational analytics. Some customers need us to collect data events in real time and push them into some central place like an operational hub or database and build insights on top of it. It gives us business insights into whatever is happening in the organization in real time.
We have around 20 to 30 engineers enabled on the real-time and PowerExchange products.
What is most valuable?
The main benefit of PowerExchange is its native real-time capabilities. Competing tools are counting on third-party packages or Oracle to offer real-time capabilities. However, Informatica has a native ability to scan the data on the file system level and capture the changes almost instantly when I push it to the consumers. The solution has a powerful built-in replication engine.
What needs improvement?
The major shortcoming of PowerExchange is high availability and failover. None of the versions we've used to date have had the out-of-the-box ability to enable failover and high-availability requirements. This is a significant challenge and risk.
PowerExchange's engine also lacks support for some data types. We are capturing data in a raw format, and there are also some data types like XML structure or big objects that are still hosted, so there are sometimes problems importing data. If it's not supported, you won't be able to build your scenario. Those are two main challenges that hopefully will be covered with any subsequent or new releases.
For how long have I used the solution?
We've been using Informatica PowerExchange for seven or six years.
Buyer's Guide
Informatica PowerExchange
March 2024
Learn what your peers think about Informatica PowerExchange. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
768,886 professionals have used our research since 2012.
What do I think about the stability of the solution?
PowerExchange's performance is great. The stability is acceptable. Sometimes it fails because of a high resource load, but it's adequate.
What do I think about the scalability of the solution?
PowerExchange isn't flexible in terms of scalability. This is the nature of the product. For example, you cannot run multiple instances in high availability or active mode.
How are customer service and support?
Informatica support is good. They are helpful whenever we have a challenge that requires a custom fix.
Which solution did I use previously and why did I switch?
We work with various solution vendors. For example, we use IBM Confluent for messaging and streaming, Tibco for application and data integration, etc.
I would compare PowerExchange to Oracle GoldenGate for real-time integration. GoldenGate consumes more resources from CPU and memory, but it's more stable, and the performance benchmark is higher.
The investment is bigger than Informatica. Informatica is moving to the cloud, so the investment required for real-time stuff and on-prem integration is not like before. I always compare to GoldenGate when choosing a technical solution. They're doing quite well in real-time integration.
How was the initial setup?
Deploying PowerExchange is average. It's not an easy GUI-based setup, but it's not that complicated, either. It requires some effort, but I wouldn't say it's difficult. The installation took a few days, but full end-to-end implementation takes around a month.
It requires some maintenance because there is no automatic failover and high availability. If it crashes, a qualified engineer has to take care of the instance and turn it on again or manually intervene to start it on a new machine.
What about the implementation team?
We did it by ourselves. Our team has qualified engineers who can handle the implementation. Some issues required hotfixes from Informatica, and they were cooperating as much as they could.
What's my experience with pricing, setup cost, and licensing?
The cost of PowerExchange is reasonable. It does not rely on complicated formulas or unrealistic equations. The pricing model is straightforward. There is one component, and real-time integration is included. Some other solutions require purchasing additional modules or third-party plugins for this capability.
At the same time, you can't just consider the cost of the license. You also need to dedicate a lot of resources and provide real-time support. It's a journey that must be assessed from different angles, including licensing, maintenance after deployment, operational headaches, etc. You need to calculate the investment from different angles.
What other advice do I have?
I rate PowerExchange seven out of 10. My advice to people considering PowerExchange is that you need to have a strong business case to justify investing in a real-time solution.
It has to bring value to the organization because it's not a straightforward journey. Real-time implementation creates a lot of operational headaches. You have to take care of everything to run in real time. You have to run patches and ETLs every hour, every two hours, or every morning.
Which deployment model are you using for this solution?
On-premises
Disclosure: My company has a business relationship with this vendor other than being a customer: Integrator