Sr.Manager - Data Management & Data Governance at a tech company with 201-500 employees
Real User
2022-09-28T10:56:09Z
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.
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.
We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models.
The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.
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.
Director at a financial services firm with 10,001+ employees
Real User
2021-12-13T14:30:00Z
Dec 13, 2021
The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.
Associate Manager at a consultancy with 501-1,000 employees
Real User
2021-04-29T12:26:59Z
Apr 29, 2021
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.
Technology Director at a computer software company with 1,001-5,000 employees
Real User
2021-02-16T12:21:55Z
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.
Senior Consultant at a computer software company with 1,001-5,000 employees
Consultant
2021-02-08T19:24:33Z
Feb 8, 2021
It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle.
Senior Software Engineer at Depository Trust & Clearing Corporation
Real User
2020-11-01T09:32:00Z
Nov 1, 2020
If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.
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.
Director of Innovation & Development Department at Poslovna Inteligencija
Consultant
2019-07-18T11:31:00Z
Jul 18, 2019
Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better.
The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files.
Informatica PowerCenter is a data integration and data visualization tool. The solution works as an enterprise data integration platform that helps organizations access, transform, and integrate data from various systems. The product is designed to support companies in the full cycle of a project, from its initial rollout to critical deployments. Informatica PowerCenter allows developers and analysts to collaborate while accelerating the work process to deploy projects within days instead of...
The product's initial setup phase is very easy.
Informatica PowerCenter is a very good ETL tool.
Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution.
The reliability of the product and the way of orchestration of different services is valuable to us.
Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application.
PowerCenter performs well during data transformation and optimization.
We can scale the product.
I found the map links, work links, and workflows valuable. They are important features.
It has good standard features for ETL development.
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.
The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources.
I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions.
Has a good visual tool for data mapping.
It's very easy to use it to develop mappings and workflows.
The interface is very clean and clear.
The technical support is excellent.
It has a Data Catalog that uses the Model repository.
I like the completeness of the way I can build ETL workflows.
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.
The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.
It is UI friendly and has all the advantages of an ETL tool.
The technical support for Informatica PowerCenter is good.
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.
It is very comprehensive in terms of connector and transformation capabilities from both a source and target perspective.
The solution is stable.
We use Informatica PowerCenter to transfer the transitional database to and from the data warehouse. This is very efficient as it enables us to quickly find our data reports and the data, so we can build AI models.
The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.
The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.
It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases.
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.
It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put into the packet in a very fast way.
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.
The greatest feature is that it is very easy to have someone come in and jump right in. It is one of the nicest tools in terms of getting a person acquainted quickly.
It has helped us monetize.
It's a complete package, which is why we use this solution.
Deployment was simple and straightforward.
We have found the PowerCenter and B2B data transformation most valuable.
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.
The most valuable features are the monitoring tools and the reporting manager.
The number of docs has been reduced drastically, which is very good.
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.
It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle.
I like the automated scheduling feature.
Can manage a huge quantity of data and provide reliability.
Once you have learned Informatica, it is very easy to use.
What I like the most is that we have to deal with less while writing the queries.
If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.
The most valuable features are the metadata repository and the data warehouse application console.
Good interface, reasonable documentation.
Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System.
The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed.
The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution.
The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand.
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.
In the end, you have structured, proper data for use in an integrated BI solution.
The performance and design of Informatica have been very valuable. I find the performance faster than, say, Oracle Data Integrator or DataStage.
The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter.
Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica, Informatica is much better.
The most valuable features are the dynamic reading of the file metadata profile, and the ability to define business rules that are used to verify and validate the uploaded files.
It reduces a lot of legacy coding.
Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years.