I worked for clients in building IT implementation in their projects. I have also worked for a bank in Bahrain. I worked for waste management organizations, implementing IT solutions in their companies. I worked for Emaar Properties, the company that developed Burj Khalifa. All the companies have their internal IT, and I was part of their digital solution team in which we were working on multiple projects in the IT domain, with Power BI's reporting, database programming, ETL, and data integration areas.
PowerExchange is a data integration tool. We use PowerExchange when we have data sitting in silos in different systems and databases, and the customer wants to capture and analyze it. Customers usually want to bring the data into one place or build a central data warehouse to perform analytics or reporting. The solution can ingest data from different systems and bring it to the data warehouse.
Vice President --Analytics & Digital Transformation at Polestar Solutions & Services India Pvt Ltd
MSP
Top 5
2024-02-28T10:48:28Z
Feb 28, 2024
I use the solution in my company for data integrations and building a data warehouse or data lake. It is mainly used for the integration of common data services. The tool gets used based on the requirements related to the data lake or data warehouse, which were needed by Informatica. Informatica PowerExchange is used in our organization for the integration of some of the planning tools.
In my company, the tool is useful for data onboarding purposes. You can use Informatica PowerExchange if you have to deal with different data sources in your company and you want to have everything in one common environment, like a data warehouse. Informatica PowerExchange can connect to different sources, including flat-file databases and different types of data sources. The tool helps you onboard all the data into a single target or different targets.
There are two primary use cases. One is standard data warehousing, which is batch loading with a transformation. We prefer to do push-down to data because we have invested a lot in the platform. We are doing ETL for standard data warehousing, which is a batch mode loading with pushdown to Teradata. We use it for schedule monitoring. Everything is enabled to Informatica for that batch. Second, with PowerCenter, we are doing real-time capturing from negative source systems and then replicating data in our data warehouse platform.
Practice Head, Data & Analytics at Tech Mahindra Limited
Real User
Top 10
2023-02-03T10:31:30Z
Feb 3, 2023
We are a system integrator. My experience is primarily around solution consulting, designing, and proposing it in the right perspective so that its features are best utilized, and we are able to provide the best value for our customers.
We are using the solution for real-time integration. Sometimes there are some complex requirements for real-time reporting, and it'll be maybe for CDC, change data capture.
Sr.Manager - Data Management & Data Governance at a tech company with 201-500 employees
Real User
2022-04-08T18:14:00Z
Apr 8, 2022
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.
Practice Head, Data & Analytics at Tech Mahindra Limited
Real User
Top 10
2020-03-16T06:56:22Z
Mar 16, 2020
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.
Solution Integration and Implementation Manager at Amdocs
Real User
2020-03-05T08:39:00Z
Mar 5, 2020
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.
Solution / Application Architect at a tech services company with 1,001-5,000 employees
Real User
2020-03-04T08:49:00Z
Mar 4, 2020
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.
Sr.Manager - Data Management & Data Governance at a tech company with 201-500 employees
Real User
2020-03-04T08:49:00Z
Mar 4, 2020
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.
Director Technology at a computer software company with 10,001+ employees
Real User
2020-02-13T07:50:55Z
Feb 13, 2020
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.
I worked for clients in building IT implementation in their projects. I have also worked for a bank in Bahrain. I worked for waste management organizations, implementing IT solutions in their companies. I worked for Emaar Properties, the company that developed Burj Khalifa. All the companies have their internal IT, and I was part of their digital solution team in which we were working on multiple projects in the IT domain, with Power BI's reporting, database programming, ETL, and data integration areas.
PowerExchange is a data integration tool. We use PowerExchange when we have data sitting in silos in different systems and databases, and the customer wants to capture and analyze it. Customers usually want to bring the data into one place or build a central data warehouse to perform analytics or reporting. The solution can ingest data from different systems and bring it to the data warehouse.
I use the solution in my company for data integrations and building a data warehouse or data lake. It is mainly used for the integration of common data services. The tool gets used based on the requirements related to the data lake or data warehouse, which were needed by Informatica. Informatica PowerExchange is used in our organization for the integration of some of the planning tools.
In my company, the tool is useful for data onboarding purposes. You can use Informatica PowerExchange if you have to deal with different data sources in your company and you want to have everything in one common environment, like a data warehouse. Informatica PowerExchange can connect to different sources, including flat-file databases and different types of data sources. The tool helps you onboard all the data into a single target or different targets.
We use it for referral calls with Salesforce.
There are two primary use cases. One is standard data warehousing, which is batch loading with a transformation. We prefer to do push-down to data because we have invested a lot in the platform. We are doing ETL for standard data warehousing, which is a batch mode loading with pushdown to Teradata. We use it for schedule monitoring. Everything is enabled to Informatica for that batch. Second, with PowerCenter, we are doing real-time capturing from negative source systems and then replicating data in our data warehouse platform.
We are a system integrator. My experience is primarily around solution consulting, designing, and proposing it in the right perspective so that its features are best utilized, and we are able to provide the best value for our customers.
We are using the solution for real-time integration. Sometimes there are some complex requirements for real-time reporting, and it'll be maybe for CDC, change data capture.
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.
The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems.
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.