How do you or your organization use this solution?
Please share with us so that your peers can learn from your experiences.
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.
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.
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.
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.
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.
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.
We primarily use the solution for getting the data from the source and loading it into the warehouse by performing data transformation.