Informatica PowerCenter Archived Reviews (More than two years old)

Filter by:Reset all filters
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Real User
Data Warehousing and Business Intelligence Lead at Bank of America
Oct 06 2016

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… 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… 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… more»

What's my experience with pricing, setup cost, and licensing?

It is not an economical software, but if you are planing for a long term robust end-to-end enterprise level tool that can handle any kind of data, and any type of task… more»

Which solution did I use previously and why did I switch?

We were using a conventional RPG programming tool to do analysis, but every time you add more tables for data analysis, profiling, quality, manipulation, it was turning… more»

What other advice do I have?

Informatica is a great product. If you can spend a good amount of time researching what you want,have a proper SDLC in place, and work with the technicality of… more»

Which other solutions did I evaluate?

* Data Stage * Ab Initio * MicroStrategy
Vendor
Business Intelligence Analyst at a comms service provider with 10,001+ employees
Feb 25 2016

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… 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… more»

Which solution did I use previously and why did I switch?

We previously used Oracle Warehouse Builder. We switched because Warehouse Builder generated PL/SQL code and the transformation resided inside the database. With PWC, the transformation is on a… more»

What other advice do I have?

Be persistent in trying to implement all kinds of transformations with Power Center, you will be happy with the final result.

Which other solutions did I evaluate?

We also looked at ODI (Oracle data integration).

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
Informatica PowerCenter customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

BUYER'S GUIDE
Download our free Data Integration Tools Report and find out what your peers are saying about Informatica, Microsoft, Oracle, and more!