2019-12-16T08:14:00Z

What is your primary use case for Informatica PowerExchange?

Julia Miller - PeerSpot reviewer
  • 0
  • 38
PeerSpot user
15

15 Answers

AS
MSP
Top 5Leaderboard
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.

Search for a product comparison
RajeevKumar9 - PeerSpot reviewer
Real User
Top 10
2024-02-01T08:37:53Z
Feb 1, 2024

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.

WS
Real User
Top 5
2023-10-31T11:54:08Z
Oct 31, 2023

We use it for referral calls with Salesforce.

IA
Consultant
Top 20
2023-09-05T07:04:00Z
Sep 5, 2023

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.

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
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.

Hassan Emam - PeerSpot reviewer
Reseller
Top 10
2022-12-15T18:37:04Z
Dec 15, 2022

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.

Learn what your peers think about Informatica PowerExchange. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,234 professionals have used our research since 2012.
Mohamed Elkady - PeerSpot reviewer
Real User
Top 5
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.

RajeevKumar9 - PeerSpot reviewer
Real User
Top 10
2022-01-20T13:06:00Z
Jan 20, 2022

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

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
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.

PN
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.

RR
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.

Mohamed Elkady - PeerSpot reviewer
Real User
Top 5
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.

Liana Iuhas - PeerSpot reviewer
Real User
Top 5
2020-03-03T08:47:00Z
Mar 3, 2020

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.

AK
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.

SS
Real User
2019-12-16T08:14:00Z
Dec 16, 2019

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

Informatica PowerExchange Connectors provides high performance, out-of-the-box connectivity without having to develop custom data access programs.
Download Informatica PowerExchange ReportRead more