Informatica PowerCenter Reviews

4.1 out of 5 stars
 (6)
2aa4c284 3c4a 444f 8fb6 defc7039139f avatar
Real User
Data Warehousing and Business Intelligence Lead at Bank of America

What is most valuable?

* Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well. * SQL override allows users to write simple to complex queries inside mapping for... more»

How has it helped my organization?

Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the... more»

What needs improvement?

There are three areas where they can make a significant improvement: * Live feeds, where if a database object changes then object definitions should automatically get refreshed as well. This would avoid re-import of objects. Auto refresh will... more»
0c9bce29 fb0a 4f7e a93d be896202f2cc avatar
Consultant
Technology Architect at Broadridge Financial Solutions
Jun 25 2017

What is most valuable?

We are using it to source data from Sybase database and flat files so as to load to the target Greenplum Database. The facility to do parallel load on Greenplum using gpload feature is valuable for us. Also, the ability to scale through... more»

How has it helped my organization?

We used Informatica PowerCenter for a re-platforming project where the earlier application was using an in-house Java-based ETL, that suffered in terms of the performance and scalability issues. With Informatica PowerCenter, we were able to... more»

What needs improvement?

In our implementation, for the initial conversion, we had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we... more»
Data integration tools report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools.
254,040 professionals have used our research since 2012.
Anonymous avatar x80
Real User
Business Intelligence Analyst at a comms service provider with 1,001-5,000 employees

What is most valuable?

With this product, we managed to implement all of our ETL, including those with many sources, and complex transformations.

How has it helped my organization?

With this product we can centralize all our ETL needs in one technology. One unique team with the right expertise is responsible for developing, implementing, and tuning it. We eliminated the variety of different solutions and different... more»

What needs improvement?

One area for improvement is with huge ETLs, where the product has to extract large amounts of information. That's because some sources wait for others inside the map to finish, and only afterwards do they continue extracting data from other... more»
Anonymous avatar x80
Real User
DW Admin at a hospitality company with 1,001-5,000 employees
Jun 06 2017

What do you think of Informatica PowerCenter?

Valuable Features Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory. • Improvements to My Organization Like any other ETL tool, it collects business information for centralized reporting and analytics. • Room for Improvement The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application. • Use of Solution Our company has used it since 2002, I started using it in 2009. • Stability Issues The integration service itself is very stable. The applications suffer from minor stability problems. • Scalability Issues The product scales very well, beyond our needs. • Customer Service and Technical Support The technical...
Anonymous avatar x80
Real User
Integration developer at a tech services company with 10,001+ employees
Jan 24 2018

What do you think of Informatica PowerCenter?

Improvements to My Organization We are trying to implement both Finance and Operations modernization with the help of Informatica. This tool is mainly used in data ingestion, where we bring different sources into a Hadoop environment. • Valuable Features Big Data connectivity, Data Integration solutions, and Data Quality solutions.  Easy to code and understand solutions in Informatica. • Use of Solution More than five years. • Stability Issues Yes, we had stability issues, mostly with JVM size. • Scalability Issues Yes, there can be scalability issues. Huge amounts of data ingestion will impact performance. • Customer Service and Technical Support I rate tech support seven out of 10. • Initial Setup Straightforward. • Other Solutions Considered There...
See 1 more reviews

Articles

User Assessments By Topic About Informatica PowerCenter

Data integration tools report from it central station 2018 01 27 thumbnail
Find out what your peers are saying about Informatica, Microsoft, Talend and others in Data Integration Tools.
254,040 professionals have used our research since 2012.

Informatica PowerCenter Questions

Informatica PowerCenter Projects By Members

Informatica PowerCenter Consultants

What is Informatica PowerCenter?

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.
Also known as
PowerCenter
Vendor 7430 screenshot 1514055580
BUYER'S GUIDE
Not sure which Data Integration Tools solution is right for you?

Download our free Data Integration Tools Report and find out what your peers are saying about Informatica, Microsoft, Talend, and more!
Data integration tools report from it central station 2018 01 27 thumbnail

Sign Up with Email