Informatica PowerCenter Valuable Features
YT
Yahya Tlaghi
Developer, Architect at L'Oreal
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.
View full review »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.
View full review »PS
reviewer2042916
Analytics Insights - Manager at a consultancy with 10,001+ employees
It's the best ETL tool that one can have.
The initial setup is easy.
It's stable.
We can scale the product.
Support has been helpful in the past.
View full review »Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,955 professionals have used our research since 2012.
They know what they're doing, and it's a more mature tool compared to Talend. They really think about every scenario. For example, if you want to write a data cleansing algorithm and all that is probably rules. It's just easier. There are a lot of provisions in PowerCenter. In terms of the transformation algorithms and all that, there are a lot of operations. It's great.
The solution is stable.
It's a scalable product.
View full review »HK
Hava Kafka
Developer and Team Lead at ZIM
The most valuable feature of the solution stems from the fact that it is good for big data, meaning it is a useful tool if there is a need for integration functionalities to manage a huge amount of data. The tool has many functionalities and options. The main valuable features of the product revolve around its flexibility and ability to deal with big data. The tool's components help my company in areas where integrations are required.
CC
reviewer2123568
Senior Oracle Database Administrator at a financial services firm with 1,001-5,000 employees
It is an excellent tool. It covers our needs.
The solution is used mostly to handle our daily data loads in our data warehouse. We've been successful so far using it.
It provides monitoring and we can therefore be aware of what is happening when we are handling jobs.
The ETL and monitoring tools are the most useful for us.
The transformations we need to do, to comply with user requests, is very easy with this product.
The solution is stable.
It can scale.
View full review »AE
Afthab Ellath
Enterprise application architect at Ministry of Health
In general, it is a great tool.
The initial setup is not very complex.
There are many features available. It has very rich transformation tools. You can have union integration. There are many kinds of set operators, aggregators, and plate operators.
Graphically you can define a lot, and you can also inject variables too. If you define one transformation, you can replicate it with several sources.
It has very good monitoring and process monitoring.
There is an excellent scheduler.
The integration capabilities are pretty good.
We've found the solution to be very stable.
It's a product that scales well.
View full review »PB
Pavan B
Technical Manager at Agriitex
It has good standard features for ETL development. I mostly like the transformation simplicity, which is very good. It has common features that are very similar to all similar tools.
It is stable and reliable.
Technical support is good.
View full review »The solution has been issue-free overall.
The traceability has been extremely useful. You can see all of the workflows, and you can trace the data transformation very easily. Each column in the target can be easily traceable, and you easily can see all that data transformation on the path from the source to the target.
The setup is straightforward.
It's stable.
The solution can scale a bit.
Technical support is helpful.
View full review »CR
reviewer1342140
Business Intelligence Architect at a manufacturing company with 10,001+ employees
It's very easy to use it to develop mappings and workflows.
View full review »VS
Vineth Suresh
Senior Associate at PwC Acceleration Centers
The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth.
View full review »The reliability of the product and the way of orchestration of different services is valuable to us. It is a very old tool, so it is a classic solution. Once someone is familiar with it, they would like to use it.
View full review »SG
reviewer2116809
Solution Design Expert at a pharma/biotech company with 10,001+ employees
The cloud version is very useful.
The features provided are great.
It is stable and reliable.
Technical support is quite helpful.
The setup is very simple.
View full review »AS
Ankit Sinha
Associate Manager at Accenture
Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution.
KG
reviewer1488372
Associate Manager at a consultancy with 501-1,000 employees
Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute.
It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.
View full review »RR
reviewer1080585
Practice Head - Advanced Analytics & Cloud at a computer software company with 201-500 employees
It is very robust, scalable, and simple to use.
It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective.
View full review »VJ
Vasubabu Jetty
Principal Consultant at Genpact - Headstrong
I found the map links, work links, and workflows valuable. They are important features.
MS
Mukul Shukla
Assistant Manager at a insurance company with 10,001+ employees
The solution's most valuable feature is its support service. The support team efficiently resolves any technical issues.
View full review »The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.
View full review »Informatica PowerCenter has many features compared to Talend, DataStage, and Airflow. Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application. Also, one won't face issues related to bugs when using Informatica PowerCenter.
View full review »PowerCenter performs well during data transformation and optimization.
View full review »The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources.
View full review »The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.
View full review »This is an old and reliable product. I like the visual tool for data mapping and the workflow manager.
I like the completeness of the way I can build ETL workflows. It's not one feature that stands out. Rather, it's the way everything is working together.
On the matter of data lineage and data catalog and metadata, in particular, several new developments are embedded as options you could use or could buy. The modular structure is very helpful.
View full review »Informatica PowerCenter is a very good ETL tool.
View full review »Buyer's Guide
Informatica PowerCenter
March 2024
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: March 2024.
763,955 professionals have used our research since 2012.