Informatica PowerCenter Archived Reviews (More than two years old)
- Highest Rating
- Lowest Rating
- Review Length
Oct 06 2016
It can work with any kind of database, including NoSQL ones, but when a database object changes then object definitions do not get refreshed automatically.
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
Feb 25 2016
There were many performance problems during the implementation, but you will be happy with the final result.
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 asPowerCenter
Informatica PowerCenter customers
University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank