PowerCenter Software

Find out more:

Find out more:

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 incl...

PowerCenter Pricing

Contact Informatica for pricing details. A 30-day free trial is available.

Free trial: 

Available

Free version: 

Not Available

Close

Image 1 of 3

Mapping debugger

Headshot of Software Advice Advisor

Find the right Business Intelligence Tools for you.

What key features are most important to you in Business Intelligence Tools?

PowerCenter User Reviews

OVERALL RATING

SECONDARY RATINGS

Ease-of-use

4.5

Value for money

4

Customer support

4

Functionality

4.5

Showing 1 - 5 of 38 reviews

User Profile

Abhisha

Verified reviewer

Company size: 1 employee

Industry: Higher Education

Time used: More than 2 years

Review Source: Capterra

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
4

Ease-of-use

out of 5
5

Value for money

out of 5
3

Customer support

out of 5
4

Functionality

out of 5

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.

Manali

Company size: 10,000+ employees

Industry: Information Technology and Services

Time used: Less than 2 years

Review Source: Capterra

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
5

Ease-of-use

out of 5
3

Value for money

out of 5
4

Customer support

out of 5
3

Functionality

out of 5

July 2019

Good but require to inbuilt multiple function

It's good but yeah not too good

Pros

1. Drag and drop services 2. Easily maintain 3. Run multiple batch jobs 4. Define methods with logistics

Cons

1. Can't schedule in workflow 2. Job running status logs are too long 3. Doesn't have parallel off functionality 4. Can't be sync with repository automatically

Reasons for switching to PowerCenter

Integration in cloud becomes easy Schedule the process with in the tool Define the process modules working Param file in itself Real time alerts and granular level of logs

Anandh

Time used: Free Trial

Review Source: Capterra

3

Ease-of-use

out of 5
3

Value for money

out of 5
3

Customer support

out of 5
4

Functionality

out of 5

October 2016

Informatica Power Center

Product Met expectations. Could have better customer support and timely resolution of user queries.

Sri Ramani

Company size: 10,000+ employees

Industry: Information Technology and Services

Time used: More than 2 years

Review Source: Capterra

This reviewer was invited by us to submit an honest review and offered a nominal incentive as a thank you.
5

Ease-of-use

out of 5
5

Value for money

out of 5
4

Customer support

out of 5
5

Functionality

out of 5

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.

Anonymous

Company size: 10,000+ employees

Time used: More than 2 years

Review Source: Capterra

This review was submitted organically. No incentive was offered
4

Ease-of-use

out of 5
4

Value for money

out of 5
4

Customer support

out of 5
4

Functionality

out of 5

May 2019

One of the best ETL ( Extract, Transform, Load) Tools

Pros

1. Able to process a huge record size. In the latest project, we used Informatica to load approx 5 Million records daily. There were no performance issues due to the data size. 2. . PowerCenter has very easy to use drag and drop interface which can be used in integration with other applications. 3. Good tool to manage legacy data and to make compatible with modern applications. 4. PowerCenter also has other additional features like the ability to profile data, visualize graphical data flow etc. Data validation can also be done very easily using the validation feature.

Cons

There is a huge licensing fee which is worth it as the product is one of the best ETL tools, but projects which smaller budget find it challenging to justify the cost.

Popular PowerCenter Comparisons