We use the solution to fill the data warehouse from multiple data sources. We have 1500 pipelines built-in production.

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.

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.

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.

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 in banking, telecommunication, and insurance companies. We use it to take data from sources and make data warehouse models.

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.

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.

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. 

Our primary use case is for carrying out data integration and transformation from across different types of sources, different types of data stores and types of data. Our goal is to bring in data from diverse sources at a very fast pace and in very large volumes. 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. 

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.

The solution can connect to different systems i.e. mainframe, IMS or AS/400 Legacy Systems.

We use it for referral calls with Salesforce.

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 primarily use the solution for getting the data from the source and loading it into the warehouse by performing data transformation.