It's been two months since this profile received a new review

Informatica PowerCenter Reviews & Product Details

Informatica PowerCenter® helps you unleash the value of your data. It offers a unique end-to-end data integration platform, with a broad set of capabilities to integrate raw, fragmented data from disparate sources, transforming it into complete, high-quality, business-ready information. As your environment grows and matures, PowerCenter scales to meet your expanding business needs, data volumes, and complexity, while providing insights to IT and the business

Seller

Informatica

Discussions

Informatica PowerCenter Community

Product Description

Informatica PowerCenter is an ETL tool that is used to enterprise extract, transform, and load the data from the sources. We can build enterprise data warehouses with the help of the Informatica PowerCenter. The Informatica PowerCenter produces the Informatica Crop.

Overview by

Peggy O'Neill (Vice President, Industry Analyst Relations at Informatica)

Value at a Glance

Averages based on real user reviews.

Perceived Cost

$$$$$

View More Pricing Information

Top-Rated Alternatives

Talend Data Integration

4/5

(60)

Pentaho Data Integration

View All Alternatives

Informatica PowerCenter Media

Informatica PowerCenter

G2 reviews are authentic and verified.

Here's how.

Verified User in Retail

Enterprise (> 1000 emp.)

1/4/2017

"Great product"

3.5/5

What do you like best about Informatica PowerCenter?

Will highly recommend this product , it makes charting, reporting very easy, with various building blocks needed to generate exec reporting Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

The tool sometimes take some hands on learning in the initial stages to get accustomed to. Review collected by and hosted on G2.com.

Niranjan S.

Consultant

Management Consulting

Enterprise (> 1000 emp.)

1/12/2016

"The best ETL tool ever!"

5/5

What do you like best about Informatica PowerCenter?

Informatica PowerCenter is my go to solution for any ETL need. It is flexible, easy to understand and easy to maintain. It is easier to debug and absolutely simple to build any logic you have in mind. The security is very straight forward which avoids unnecessary confusions and saves time to concentrate on developing and testing the applications. The command line comes to rescue when you need to create a custom solution. Deployment groups and simple XML migration saves time and energy during migrations. The inbuilt version control saves lots of time when something is modified by mistake. The ETL templates for SCD saves time and avoids complexity by providing a simple method to implement complex SCDs. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Though the tools is reliable compared to other tools like ODI, frequent crashes, screen hang causes troubles. One notable issue is when you try to change the domain name in Informatica Workflow monitor-impossible to change! Review collected by and hosted on G2.com.

Recommendations to others considering Informatica PowerCenter:

Simple interface, easy to learn, use and administer. Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

Any ETL problem can be handled by Informatica, I work with a very big EBS implementation and developing a data warehouse was so easy with Informatica, Earlier we were considering Oracle's ODI but later realized the flexibility which was readily available in Informatica was missing in ODI. Review collected by and hosted on G2.com.

Verified User in Oil & Energy

Enterprise (> 1000 emp.)

8/1/2016

"Leader in Data Integration"

5/5

What do you like best about Informatica PowerCenter?

Informatica offers integration with wide range of databases and enterprise application integration with a interface helping easy to support and sustain application. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Need seamless job scheduling with dependency flexibility like control or autosys scheduling Review collected by and hosted on G2.com.

Verified User in Higher Education

Enterprise (> 1000 emp.)

8/25/2016

"Occasionally use for fast ETL development"

3.5/5

What do you like best about Informatica PowerCenter?

Powerful tools, get results very quickly with full functionality Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

Too many features, easy to make wrong choices if you don't know what you are doing Review collected by and hosted on G2.com.

Samrat M.

Data Integration / Datawarehousing Specialist

Enterprise (> 1000 emp.)

5/19/2015

"Informatica Powercentre : A Leader in the Data Migration tools stack like no other."

5/5

What do you like best about Informatica PowerCenter?

Informatica, unlike other vendors like Oracle do not believe in 'reinventing the wheel' when it comes to enhancements: old features are backward compatible and new ones are intuitive to use to the familiar user. one of the best features of Informatica and a dream come true for most Informatica Developers and Designers is its ability to visually model the business process whose data it is trying to transform. This means process models developed in industry standard BPMN can be modelled to exact specification mappings in Informatica and with its robust debugger engine, it serves as the best visual tool to visualise each and every data transformation when you need to get those data sign-offs in complex data integrations. Hence code development is more agile and prototyping is faster and more robust.

Code Migration and Version Control in Informatica are pretty robust too and the process works out of the box with its excellent code labelling and version history system with minimal configuration! Add to this the excellent error handling capabilities of its workflow monitor and you have a data migration platform that works best for you and the business. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

In the Product per se, the Informatica Powercentre suite needs a stronger ETL(Extract Transform Load) orchestration tool that is as intuitive as the Oracle Datawarehouse application console(DAC). Informatica allows orchestration of workflows to a certain extent but needs to come up with more level of control on table related tasks that speed up the ETL like dropping and recreating indexes. Informatica can do these activities by calling procedures in pre and post sql actions but the tasks are not very visibly monitored on its work flow monitor.Nevertheless, the session logs on the monitor do keep a record of these tasks. Review collected by and hosted on G2.com.

Recommendations to others considering Informatica PowerCenter:

Before falling into the sales pitch of ETL tools set by Oracle or IBM(Data Stage), consider this: Informatica has been the market leader for Enterprise Data Migration for the last couple of years(more than 5 years as a Leader in this sector on the Gartner Magic Quadrant). If this statistic does not impress you, consider its ability to make robust prototypes, efficient ETL Engine, strong debugging and error handling capabilities plus a version control and code migration system that simply works out of the box and you got a winner in the Data Migration tools space that will make your investment worthwhile over the years! Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

We are using Informatica to make complex data transformations from multiple source systems using complex business process flows that reflect the convergence of CRM(Customer Relationship Management) systems and Financial systems right from when the Customer represents an opportunity for business to the point when he holds assets from our business as a result of the Customer journey. Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/7/2016

"Using this product since 2006 as an ETL developer/Architect "

4.5/5

What do you like best about Informatica PowerCenter?

easy to use, reliable. lot of features. can be connected to any type of source (xml, flat file, mainframe, rdbms -Oracle etc).

Rapid development.

Integration with other products like IDQ. Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

error message documentation is not correct or enough to debug issues. Review collected by and hosted on G2.com.

Recommendations to others considering Informatica PowerCenter:

Highly recommend this product for ETL related work Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

Data migration -- Full load and incremental load with lots of transformation rules.

A new system is being developed with new data model which will be populated with three existing systems. Review collected by and hosted on G2.com.

Naresh K.

Solutions Designer

Financial Services

Enterprise (> 1000 emp.)

1/7/2016

"Informatica by far is the most user friendly and advanced ETL tool"

4.5/5

What do you like best about Informatica PowerCenter?

the user interface, diversity in its products to achieve anything related to data integration etc Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

too many products with overlapping features Review collected by and hosted on G2.com.

Verified User in Information Technology and Services

Mid-Market (51-1000 emp.)

1/14/2016

"One of the simplest ETL tool available in the market!"

4/5

What do you like best about Informatica PowerCenter?

1.) Reliability and easy to learn

2.) It can integrate any type of data, data format from any data source

3.) Integrates well with oracle and teradata Review collected by and hosted on G2.com.

What do you dislike about Informatica PowerCenter?

1.) Custom built tools used to enhance functionality are not readily available

2.) It frequently crashes and the very often the screen gets stuck Review collected by and hosted on G2.com.

Recommendations to others considering Informatica PowerCenter:

Simple interface, worth a trying the 30 day free trial, easy for both user and administrator Review collected by and hosted on G2.com.

What problems is Informatica PowerCenter solving and how is that benefiting you?

Better performance: able to run Multiple huge scale data integration and data warehousing projects can be executed Review collected by and hosted on G2.com.