Informatica PowerCenter Pros review quotes

YT
Sep 26, 2022
What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly.
AT
Feb 16, 2021
Complex transformations can be easily achieved by using PowerCenter. The processing layer does transformations and other things. About 80% of my transformations can be achieved by using the middle layer. For the remaining 15% to 20% transformations, I can go in and create stored procedures in the respective databases. Mapplets is the feature through which we can reuse transformations across pipelines. Transformations and caching are the key features that we have been using frequently. Informatica PowerCenter is one of the best solutions or products in the data integration space. We have extensively used PowerCenter for integration purposes. We usually look at the best bridge solution in our architecture so that it can sustain for maybe a couple of years. Usually, we go with the solution that fits best and has proven and time-tested technology.
RP
Jul 31, 2019
In the end, you have structured, proper data for use in an integrated BI solution.
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Mohamed Elkady - PeerSpot reviewer
Sep 28, 2022
To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions. Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use. Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle.
PS
Dec 5, 2022
We can scale the product.
NM
Jan 24, 2022
Enterprise-scale ETL solution that's very stable and is easy to scale. It integrates and connects with multiple new systems, both structured and semi-structured.
MK
Aug 7, 2019
Technical support, and their approach is good. They have a support portal and support tickets. If you open a ticket it has multiple levels of severity from level one to very high or critical.
IB
Oct 28, 2021
It has helped us monetize.
Ravi Kuppusamy - PeerSpot reviewer
May 17, 2022
The solution is stable.
Muharrem Iseri - PeerSpot reviewer
Dec 14, 2021
One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool.
 

Informatica PowerCenter Cons review quotes

YT
Sep 26, 2022
What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing. Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution. What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved.
AT
Feb 16, 2021
Its licensing can be improved. It should be features-wise and not bundle-wise. A bundle will definitely be costly. In addition, we might use one or two features. That's why the pricing model should be based on the features. The model should be flexible enough based on the features. Their support should also be more responsive to premium customers.
RP
Jul 31, 2019
Integration with Artificial Intelligence would benefit this solution.
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
765,386 professionals have used our research since 2012.
Mohamed Elkady - PeerSpot reviewer
Sep 28, 2022
Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful. Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it. What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together.
PS
Dec 5, 2022
If we could have the option of performance improvement within Informatica, and if it could have more features, that would be ideal.
NM
Jan 24, 2022
This solution needs the functionality to do batch processing of data. It also lacks connectivity to NoSQL, unstructured data sources.
MK
Aug 7, 2019
The licensing cost for Informatica is very high. Other all-in-one solutions have much lower prices than Informatica.
IB
Oct 28, 2021
It would be nice to have all tools in one place. CDC needs more effort, as it's only easy to develop if you are familiar with Linux.
Ravi Kuppusamy - PeerSpot reviewer
May 17, 2022
It should be more cloud-centric than on-prem-centric.
Muharrem Iseri - PeerSpot reviewer
Dec 14, 2021
PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it.