2019-12-16T08:14:00Z

What advice do you have for others considering Informatica PowerExchange?

Miriam Tover - PeerSpot reviewer
  • 0
  • 2
PeerSpot user
15

15 Answers

AS
MSP
Top 5Leaderboard
2024-02-28T10:48:28Z
Feb 28, 2024

The product helped streamline our company's batch data processing workflow in a good way since it provides us with all the information, consisting of details like what kind of configurations need to be carried out, which can help maintain the pipelines that connect two different systems and the area from where you can push data from point A to point B. The problem is not attached to the solution's ability to provide support and have the ability to respond to security threats, but it's terms from the fact that Trend Micro is more focused on Apex One. When you contact Trend Micro for Worry-Free Services Suites, the type of support provided for the product is similar to the one provided to those who possess some basic licenses. In general, it takes a lot of time to get a response from the product's support team when you face any problems. The product supports our company's data governance because it is an established solution in the market that supports all the cloud-based features. The product supports features that allow the distribution of data across nodes. The product also offers high performance and supports high scalability features. The tool attempts to follow some of the best practices through the development to ensure how the design has been implemented. The tool also looks at the best features that you will implement during the designing phase in the development process. The tool looks into the configurations from the hardware point of view. The tool considers factors like how much configuration is required based on the capacity and requirements of users. The product follows best practices in areas like hardware and design. To those who plan to use the solution, I suggest that they look into the prices and the use cases they want to handle on the cloud. Informatica offers an old product named Informatica PowerCenter, which was the renowned and standard product preferred by clients considering its availability at a global level. The marketing of Informatica PowerExchange has not been done properly, owing to which people are not aware of its existence in the market. The data quality part of the solution is more about the design and not about the product. The tool has the capability to support the data quality features, and it is something that is taken care of from the design and development point of view. You can implement data quality to figure out how to design or handle the best practices in the solution. There should be a focus on the design and development part of the solution since the product has a lot of capabilities. I rate the overall tool a nine out of ten.

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

The solution has streamlined our company's batch data processing workflows. In our company, we have different data sources, so it is not possible to get all the information at a single point without Informatica PowerExchange. The features I found to be most effective for managing data across various sources stem from the fact that it connects to different sources, irrespective of the type of source. The tool helps to validate the data because it has an in-built product that helps us validate the data coming from different sources. Users can integrate the tool with data quality and rules. Informatica PowerExchange helps our company in terms of the correct data since it helps us connect with a single source of truth. I cannot comment on how the change in the data capture capability of Informatica PowerExchange enhanced our company's data synchronization area since it is not currently being used. Informatica PowerExchange has the capability to connect with mainframe data sources, like flat-file databases. I mostly use a product from Informatica, which helps me create workflows. Informatica PowerExchange helps me connect with different sources within Informatica. Informatica PowerExchange helps connect with legacy data sources like the mainframe data sources or VSAM files that are considered outdated. With the help of Informatica PowerExchange, users can read data from legacy data sources, a feature that no other technology in the market provides since no other tools can bring out the data from the mainframe. Informatica PowerExchange can bring out the data from the mainframe data sources even if it has to deal with a complex architecture. I recommend the product to those who plan to use it. The tool can be preferred by users like banks or those who want a solution that has been in the market for around twenty years. Banks prefer to go with Informatica PowerExchange over the new cloud solutions that are available in the market since they offer more reliability and stability. The solution has impacted our company's data governance practices because it is a procedure to deal with data quality rules product known as Informatica Data Quality or IDQ. With Informatica Data Quality, if you set up the rules, then while reading the data from the source, it will flag whether the data has the right quality or if there are some breaches when it comes to GDPR compliance. I rate the overall tool an eight out of ten.

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

I didn't like the solution very much. It is the cloud version, so maybe that's why it's a little complicated to understand. I rate Informatica PowerExchange a five out of ten.

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

I'm a contractor with a government entity, and the government entity is using Informatica. I work as a Solution Architect for the whole ecosystem, and one of the products under our umbrella is Informatica PowerExchange. We are trying to rationalize and consolidate all the products that are related to data engineering and data governance under the suite of Informatica. We are trying to converge all our ETL tools, data components, and data quality under the Informatica umbrella. We are researching and exploring how good this idea is. Implementing Informatica PowerExchange is a very good experience overall. I would recommend it because it is a well-integrated product for all data-related use cases, such as data quality, data engineering, and data cataloging. Overall, I rate the solution an eight out of ten.

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
2023-02-03T10:31:30Z
Feb 3, 2023

If the customer has money, I'd recommend Informatica PowerExchange. If the customer doesn't have money, I'd recommend a PoC. I'd certainly suggest trying it once. Overall, it's a fairly comprehensive technology, and it has been one of the earliest movers in this space. It has been there right at the top in the Gartner quadrants and other platforms. It has been used by a significantly high number of customers across the globe. I'd rate Informatica PowerExchange a nine out of ten.

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

I am using the software, I'm a distributor of the software. I'm managing the distribution of Informatica technology, so I have many customers, and a lot of them are using the latest version. However, the version can vary from customer to customer. Overall, I would recommend this product to others. I'd rate the solution nine out of ten.

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

I rate PowerExchange seven out of 10. My advice to people considering PowerExchange is that you need to have a strong business case to justify investing in a real-time solution. It has to bring value to the organization because it's not a straightforward journey. Real-time implementation creates a lot of operational headaches. You have to take care of everything to run in real time. You have to run patches and ETLs every hour, every two hours, or every morning.

RS
Real User
2020-03-30T07:58:12Z
Mar 30, 2020

Overall, it is good and I recommend it, but it still has gaps in terms of functionality. I would rate this solution an eight out of ten.

Anirban Bhattacharya - PeerSpot reviewer
Real User
Top 5
2020-03-16T06:56:22Z
Mar 16, 2020

Informatica is possibly the world leader in this field and has been for the last several years. It has features and functionalities which has made it the world leader for such a long period of time. It's a fully equipped and compatible solution with big data and it's able to drive and achieve the best of both worlds. I would rate this product a nine out of 10.

PN
Real User
2020-03-05T08:39:00Z
Mar 5, 2020

I would say that this is one of the best tools for any data ingestion mechanism. It has tremendous capabilities for data movement from one environment and multiple environments, and it can also be used for providing API services. I would rate this solution a nine out of ten.

RR
Real User
2020-03-04T08:49:00Z
Mar 4, 2020

PowerExchange is a very good tool to work with. It has the capabilities and compared to other tools, this tool has more features. It collaborates with the call center on more features, so definitely, it's a good tool to work with. On a scale of one to ten, I would give it an eight. I would definitely recommend Informatica PowerExchange.

Mohamed Elkady - PeerSpot reviewer
Real User
Top 5
2020-03-04T08:49:00Z
Mar 4, 2020

You need to get prepared very well before using it. If you just go with the initial default configuration, it will end up with very poor performance. You need to spend some time getting the technical details and the technical workarounds for the product itself. You need some time to master the product. I would rate Informatica PowerExchange at a seven out of ten.

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

I would rate Informatica PowerExchange at a nine on a scale of ten. I would recommend it. I would not rate it a ten because I have seen better tools.

AK
Real User
2020-02-13T07:50:55Z
Feb 13, 2020

The suitability of this tool depends on the client and their needs. Based on their requirements, this is certainly a solution that I would recommend. For example, if their teams are really diversified and they need a quick solution in terms of integration then this is the right product for them. So far, I have found this product to be good. That said, we did face some difficulties with respect to data connections where we needed a real-time feed to be consumed. I would rate this solution a seven out of ten.

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

I'd rate the solution eight out of ten. I'd rate it higher if it was more user-friendly and had better integration with other tools.

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