2019-12-16T08:14:00Z

What is your primary use case for Informatica PowerExchange?


How do you or your organization use this solution?

Please share with us so that your peers can learn from your experiences.

Thank you!

Guest
77 Answers

author avatar
Top 5Real User

Our primary use case is for carrying out data integration from across different types of sources, different types of data stores and types of data. Our goal is to bring in data at a very fast pace and in very large volume. It has to diversify and we have to strike a balance between the two. We partner with Informatica and I'm practice head of data analytics.

2020-03-16T06:56:22Z
author avatar
Real User

We use Informatica PowerExchange for all of our ETL and data warehousing tasks. PowerExchange is something to be used in conjunction with Hadoop. It provides the native features and you can connect to the HDFS system.

2020-03-05T08:39:00Z
author avatar
Top 10Real User

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.

2020-03-04T08:49:00Z
author avatar
Top 10Consultant

The connection layer Informatica uses to get the data from different sources can change. for traditional systems like databases, Oracle, for example, this is something that is managed by a protocol change. But there are two other key areas. One is integrating with legacy systems, mainframes, and for this one, there are some PowerExchange components. Another important one is getting data in real-time using CDC concepts. For these, there is PowerExchange for CDC. So, it's the three main use cases, legacy data integration, real-time integration, and traditional relational systems integration. PowerExchange is not about users. PowerExchange is something that you deploy on one system and it will give the data in real-time and feed it to multiple consumers. So, in the end, you don't need to have multiple users dealing with PowerExchange. It's one engine to deploy on a specific system and its core function would be to continuously feed the information from that system.

2020-03-04T08:49:00Z
author avatar
Top 5Real User

We work with Informatica PowerExchange for a very big trial for data warehousing and loading data for various systems. They work off transformation, creating a data warehouse. We also made part of the administration for that client.

2020-03-03T08:47:00Z
author avatar
Top 10Real User

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.

2020-02-13T07:50:55Z
author avatar
Top 5Real User

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

2019-12-16T08:14:00Z
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: October 2020.
442,517 professionals have used our research since 2012.