PowerCenter Software

4.52 / 5 (27)

About PowerCenter


PowerCenter is a cloud-based enterprise data integration platform that helps businesses with data integration life cycle. The platform enables users to manage data integration agility, enterprise scalability, operational confidence and data integration projects. 

PowerCenter’s key features include business collaboration, IT collaboration, re-usability, automation, operations, governance oversight, real-time data, prototype, profiling, validation, automated data validation testing, data transformation and connectivity to cloud applications. Additionally, the platform allows users to monitor reinforce coding and production providing support for adaptive load balancing, grid computing, pushdown optimization, partitioning and more.

PowerCenter add-on packages include data integration hub, B2B data exchange, PowerExchange for cloud applications and PowerCenter productivity. Pricing of the product is available on request and support is extended via phone, online help desk and documentation.



Read More

Supported Operating System(s):

Web browser (OS agnostic)

27 Reviews of PowerCenter

Average User Ratings

Overall

4.52 / 5 stars

Ease-of-use

4.5

Value for money

4.5

Customer support

4.0

Functionality

4.5

Ratings Snapshot

5 stars

(15)

4 stars

(11)

3 stars

(1)

2 stars

(0)

1 stars

(0)

Likelihood to Recommend

Not likely

Very likely

Filter reviews by:

Sort by: Most Helpful | Most Recent

Showing 1-20 of 27 reviews

Do you use this product?Write a review

March 2018

Sri Ramani from ATT

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

March 2018

Ease to use

Ease to work

Pros

It Works vwell with large structured data files PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files.
PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily.
PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within AT&T organization.

Cons

PowerCenter processes input files, performs specified transformations, and maps the input data format to the output data format very quickly. The PowerCenter backend implementation seems to be optimized to process and map structured input records to structured output records and load the records into a database. One of the strengths of PowerCenter is performance of processing petabytes of structured input data files.
PowerCenter does not require a software development experience or education. After providing initial hands-on training, the data consultants (who are statisticians, subject matter experts) in our organization were able to implement data ingest and data transformation tasks fairly easily.
PowerCenter supports multiple DBMS technologies (for example, Oracle, Netezza). This flexibility allows it to be used by multiple departments within our organization.

June 2017

Sriram from Techmahindra

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

5.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

June 2017

Awesome Tool

Pros

When joining Informatica I have to say, the whole process was a very nice and comforting transition. I was very impressed by level of care, focus and how they approached the recruitment process.
The Human resources and Management team are a really great bunch of people and I believe we made the right choice together. They gave me confidence in how the company is run, they were clear and concise on how the company structure works and what the expectations are.
The company progression is great, already I'm gaining more responsibility and growing and learning more about the industry, so on this I would certainly recommend Informatica as a prospect to anyone looking for an Innovative, Positive, growing and fun company to work for

Cons

Scheduler tools can manage dependencies
accross many systems and environments. For instance you can
configure it so that your informatica job only runs after the
successful completion of some other system's windows job and/or
another system's batch job.

October 2016

Sarathy from SFDC

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

October 2016

Informatica Powercenter

I have using Informatics Powercenter for ETL and data integration needs for the past 12 years and its one of the best tool available in the market.

Pros

It can connect to almost all types for sources and targets, it has so many built in transformations which can be readily used to meet the business needs.

Cons

Its performance when dealing with huge volume of data is not that great when compared to Ab-initio. Also, its very expensive.

December 2018

Anonymous

Verified Reviewer

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Customer support

5.0

Functionality

4.0

December 2018

Informatica - Performance with ease

I have been working on the tool since last 8+ years and the tool has never failed me. I could design almost everything i could think of in terms of data flow and transformations.

Pros

The ease of development, debugging, migrating and maintaining the code.
Heavy duty performer and can scale to perform multi-threading.

Cons

It does not have strong ELT features or market - so cannot leverage the high computing capability.
Still based out of legacy ETL process which needs to be migrated.

July 2018

Sagar from Tarkett

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

5.0

Functionality

5.0

July 2018

Strong ETL Tool for your data warehousing need

Pros

Powercenter by Informatica is a strong ETL tool which has all the features and functionality making it the best choice for your data warehouse needs. The GUI interface makes designing a mapping super-easy. The tool contains various transformation that can be used to translate your business needs

Cons

There is no actual CONS that I have seen with tool. Have been using it for so many years and I am completely happy with it.

November 2016

Daniel from Freelance

Company Size: 1 employee

Review Source: Capterra


Ease-of-use

4.0

Value for money

2.0

Customer support

5.0

Functionality

4.0

November 2016

A complete integration platform with a high focus on ETL/ELT processes

If you need to do a fast ETL/ELT process and you do not want complications, this is your application. Informatics (on-premises) is quick to deploy and you can start to develop your process really quickly. The Informatica Knowled Base is very complete and you can find in it some templates to use. In all the development process, you can see and following the data per each transformation. You can launch a part of the process, simulating the data output. The quality of the solution is fantastic and his support is great, they usually respond to a problem in hours.

Pros

Great support and knowledge base. Easy to learn

Cons

Currently the managing of EII processes (like Restful or SOAP) are not well supported by the on-premise solution.

October 2018

Aniket from NTT DATA Services

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

4.0

October 2018

Informatica PowerCenter ETL Tool

I have used Informatica PowerCenter data masking module for masking Production data in the TEST and DEVELOPMENT environments. It has worked out pretty well.

Pros

Informatica PowerCenter is a user friendly tool.

Cons

The price of Informatica PowerCenter tool is a bit high

October 2018

Abhisha from North Carolina State University

Company Size: 1 employee

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

3.0

Functionality

4.0

October 2018

Good ETL tool

I was using Informatica PowerCenter as an ETL to to feed data into Teradata datawarehouse that houses customer information for an insurance company.

Pros

Informatica PowerCenter is a good ETL tool for users who wish to develop a datawarehouse but do not have much programming experience. It has a nice interface where the user can simply drag and drop to create a data flow. It is very intuitive and user friendly.

Cons

PowerCenter is a heavy software and installation is not a trivial task. It uses a lot of memory and it could crash the system if it does not have enough resources.

November 2018

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

5.0

Customer support

4.0

Functionality

5.0

November 2018

Informatica Power center

Overall as a data analyst. Informatica is the one of the best etl tool to be used nowadays.

Pros

The best thing about informatica power center is that we can use it with multiple source types.

Cons

I guess the GUI can be improved as it is less user friendly or you can say boring.

October 2016

Lakshmi from Salesforce

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

4.0

Value for money

4.0

Customer support

4.0

Functionality

5.0

October 2016

Informatica Powercenter Experience

I am working on Informatica Power Center since 2000 as I have a good amount of expertise with this tool.

Pros

Ease of Use

Cons

Too many tools

December 2018

Anonymous

Verified Reviewer

Company Size: 10,000+ employees

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Functionality

5.0

December 2018

Market leader in ETL

Pros

Drag and drop function is easy for the developers and users to complete development faster.

Powerful out of box functions are added advantage.

Cons

Initially the licensing was a bit expensive however with competition from market helped make competitively priced.

December 2018

Darpan from CITIUSTECH INC

Company Size: 1,001-5,000 employees

Review Source: Capterra


Ease-of-use

5.0

Value for money

4.0

Functionality

4.0

December 2018

User friendly tool for ETL developer

PowerCenter is an great tool for ETL if it involves multiple kind of data sources / targets.

Pros

One of the Important pro is that GUI interface is very easy to use and understand. I have used other ETL tool like SSIS but Informatica PowerCenter helps developing ETL is easiest way.
Transformation works great and efficiently.

Cons

When compared with SSIS, informatica PowerCenter doesn't perform well when source and/or target database is SQL Server. However that is understood because SSIS and SQL Server both are native to Microsoft.
Sometimes the buffer space gets filled quickly even if lookup query doesn't seem to be heavy.
Just as a suggestion - It would have been great if there was a inbuilt performance tuning tool that could suggest way to improve mapping performance.

December 2016

Scott from Rapid Recovery

Review Source: Capterra


Ease-of-use

3.0

Value for money

5.0

Customer support