Average Ratings

23 Reviews

  • 4.5 / 5
    Overall

  • 4 / 5
    Ease of Use

  • 4 / 5
    Customer Service

Product Details

Vendor has not completed this information.


About PowerCenter

Enterprise data integration platform to help organizations access, transform, and integrate data from a variety of systems.


Spotlight media placeholder

PowerCenter Features

Vendor has not completed this information.


PowerCenter Reviews Recently Reviewed!


Ease to use

Mar 05, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 10.0/10 Not
Likely
Extremely
Likely

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.

Overall: Ease to work

Awesome Tool

Jun 08, 2017
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

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.

Informatica Powercenter

Oct 24, 2016
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

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.

Overall: 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.

Recommendations to other buyers: Its one of the most widely used ETL tool out there and it can be relied upon to meet simple to complex requirements.

Strong ETL Tool for your data warehousing need

Jul 03, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

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.

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

Nov 21, 2016
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

2 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

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.

Overall: 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.

Recommendations to other buyers: Although the application has two IU to develop (Designer and Developer), our experience to manage a big amount of data/target source is better in the Designer IU.

Capterra loader

Informatica PowerCenter ETL Tool

Oct 23, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Informatica PowerCenter is a user friendly tool.

Cons: The price of Informatica PowerCenter tool is a bit high

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

Capterra loader

Good ETL tool

Oct 10, 2018
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

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.

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

Capterra loader

good but with flaws

Dec 12, 2018
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 6.0/10 Not
Likely
Extremely
Likely

Pros: powerful, it is possible to manage the data flow in many ways

Cons: the interface is really counterintuitive, really not user friendly

Informatica Power center

Nov 18, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

5 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

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.

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

Informatica Powercenter Experience

Oct 07, 2016
4/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: Ease of Use

Cons: Too many tools

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

Recommendations to other buyers: Good ETL Tool

Powerful ETL Tool with Steep Learning Curve

Dec 16, 2016
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Comments: Informatica is known to have a love/hate relationship with the majority of its users. The main reason for this is the steep learning curve of its vast amount of features. A lot of the features are very "hidden" without a knowledge both deep and wide of the software. Other than with lengthy experience, it is very hard to understand how to tackle a lot of specific problems. However, the majority of the solutions it can provide are very straight forward and can be created very quickly. There is very good customer support provided with the product but the code Informatica is built on is old and a lot of features that the community desires cannot be added. This does not necessarily take away from the functionality but more the overall quality since the product will someday be too out of date. In conclusion, it is one of the best ETL tools and is great value but its main issue is the steep learning curve that will still hit you every couple months.

Power Center Brazilian. Experience

Nov 28, 2018
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Value for Money
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: Transformation of data by Any kind of e trance (from csv filés, txt, from bank tables).

Cons: The Source Qualifier filters and debugger Mode.

Overall: At my company we work with maps for each transformation Mode, maps for extraction, transformation and load. It's good to learn well each one. From The ETL softwares I've worked with, Power Center is The easier tô learn.

Excellent ETL tool with support for Data Integration with multiple systems.

Apr 28, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Pros: 1) Stable ETL tool with excellent Monitoring and Workflow Logging Capabilities

2) Excellent support and Forums to clarify any queries.

Cons: 1) Licensing cost is high as compared to other ETL tools

2) Need to enhance support for Big Data Components

Senior Developer

Oct 27, 2016
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

2 / 5
Customer Support

4 / 5
Value for Money

Comments: We have been using Informatica for over an year. This is a very powerful tool and is massive helpful in integrations but when it comes to Customer Support, this is so poor

informatica

Oct 06, 2016
5/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

4 / 5
Customer Support

4 / 5
Value for Money

Comments: informatica cloud has Data Replication and Data Quality service and on top of it has also Full load and CDC incremental ;load which helps to reploicate al customers data.

Awesome information for my sales team

Oct 07, 2016
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Comments: My sales team relies heavily on the right information for an account based selling strategy. In order to deliver the right lead, we need the right information.

Informatica cloud

Oct 05, 2016
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money

Comments: informatica works so well with our ETL requirement with Salesforce. The customer support is pretty. The people are responsive and very helpful.

Informatica Review

Oct 06, 2016
4/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

Comments: We use informatica for ETL process and the results so far have been great. Its easy to integrate across platforms and work on

informatica review

Oct 04, 2016
4/5
Overall

4 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

4 / 5
Value for Money

Comments: used to one-time migrate accounts, contacts and cases, as well as co-exist sync, is very effective at two way sync

Awsome tool to migrate and sync data

Oct 04, 2016
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Comments: We have used informatica cloud to migrate and do co- exist betwen 2 applications.

It was easy and intuituve.

Excellent integration

Nov 05, 2018
5/5
Overall

5 / 5
Ease of Use

5 / 5
Features & Functionality
Likelihood to Recommend: 8.0/10 Not
Likely
Extremely
Likely

Pros: The integration has been seamless its been better than expected

Cons: We should have got it sooner there are no real negatives

ETL made easy

Nov 02, 2018
4/5
Overall

5 / 5
Ease of Use

4 / 5
Features & Functionality
Likelihood to Recommend: 9.0/10 Not
Likely
Extremely
Likely

Pros: This software is a power packed bundle of tools needed foe ETL purpose

Cons: Can be made a bit more attractive for the users

Informatica Power Center

Oct 06, 2016
3/5
Overall

3 / 5
Ease of Use

4 / 5
Features & Functionality

3 / 5
Customer Support

3 / 5
Value for Money

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

A very powerful tool in ETL

Feb 04, 2018
5/5
Overall

4 / 5
Ease of Use

5 / 5
Features & Functionality

5 / 5
Customer Support

5 / 5
Value for Money

Pros: I have used Informatica to get Returns on Investment and trust me Informatica can make data so much more useful with its powerful transformations. Best ETL tool in the market.

Cons: It is a heavy software and the setup itself is ~10Gb. Requires a good configuration machine, but thankfully they also provide cloud services.