Informatica PowerExchange Primary Use Case

reviewer1286829
Data Management Consultant & Delivery Manager at a tech company with 201-500 employees
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. View full review »
Anirban Bhattacharya
Practice Head, Data & Analytics at a computer software company with 10,001+ employees
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. View full review »
Prasun Nesu
Solution Integration and Implementation Manager at a comms service provider with 10,001+ employees
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. View full review »
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: November 2020.
448,896 professionals have used our research since 2012.
ArunKumar4
Specialist - Technology at Synechron
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. View full review »
reviewer1285233
Solution / Application Architect at a tech services company with 1,001-5,000 employees
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. View full review »
Liana Iuhas
CEO at Quark Technologies SRL
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. View full review »
reviewer1091745
OBIEE Developer at a tech services company with 51-200 employees
We primarily use the solution for getting the data from the source and loading it into the warehouse by performing data transformation. View full review »
Find out what your peers are saying about Informatica, Qlik, Oracle and others in Data Integration Tools. Updated: November 2020.
448,896 professionals have used our research since 2012.