Informatica PowerCenter Software Reviews

Informatica PowerCenter is the #2 ranked solution of our top Data Integration Tools tools. It's rated 4.1 out of 5 stars, and is most commonly compared to SSIS - Informatica PowerCenter vs SSIS

Filter by:
Industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
Rating
Loading...
Filter Unavailable
Considered
Loading...
Filter Unavailable
Order by:
Loading...
  • Date
  • Highest Rating
  • Lowest Rating
  • Review Length
Search:
Showingreviews based on the current filters. Reset all filters
Ricardo Pedro
Real User
Solutions & Achitecture Data Analyst Specialist at a construction company with 10,001+ employees
Aug 01 2019

What is most valuable?

The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated… more »

What needs improvement?

I would like to see the inclusion of a tool that allows you to report performance metrics. For example, it can determine whether the connectivity is correct, or how long it's taking the integration to move data from one place to another… more »

Which solution did I use previously and why did I switch?

We did not have another solution in place before this. We knew that it was something that we needed to do. Since we are moving from on-premise to the cloud, we needed something to help us with the integration.

What other advice do I have?

There is a lot of competition in the space, and the vendors want to get good companies where they can implement their solution. It doesn't mean that every product fits every organization. My advice for anybody researching this type of… more »

Which other solutions did I evaluate?

Choosing this solution was a little bit complex for us because there are a lot of different vendors in that space. We had to do a proper evaluation and negotiation to get to the solution that we needed. Some vendors offer a certain package… more »
MohamedKhamis
Reseller
Data Scientist at IME
Aug 07 2019

What is most valuable?

There are two valuable features. The first is the main typical functionality that the PowerCenter gives, that is the ETL. The ETL is able to extract transform load from/to a variety of sources, like Oracle, Microsoft's SQL Server, and Big Data. The second is the capabilities of the GUI interface… more »

How has it helped my organization?

Informatica PowerCenter satisfies our customers need; thus making Extract Transform Load from data base to data warehouse based on specific business rules.

What needs improvement?

The licensing cost for Informatica is very high. Other all-in-one solutions offer much lower prices. Also, sometimes with data capture, the solution doesn't support some data types so you must find an alternative, Informatica Data Replication, for instance. You end up buying two very expensive… more »

What other advice do I have?

Our company has many locations, in the Middle East and Africa, but we're mostly based in Cairo, and have about 100 engineers using the solution. In terms of advice, I would give to others considering using the solution, I'd say this: they should start with a datasheet of every product on… more »
Learn what your peers think about Informatica PowerCenter. Get advice and tips from experienced pros sharing their opinions. Updated: October 2020.
441,672 professionals have used our research since 2012.
Real User
Data Architecture/Management at a consultancy with 10,001+ employees
Sep 30 2020

What is most valuable?

The most valuable features are the metadata repository and the data warehouse application console.

How has it helped my organization?

This is the best tool that we have.

What needs improvement?

The only problem with this product is the level of complexity with the number of levels of transformation that you have to go through. I would say that's the biggest issue.

What's my experience with pricing, setup cost, and licensing?

It's much more expensive, almost three times more expensive than most other solutions.

Which solution did I use previously and why did I switch?

Initially, we were doing a custom PL/SQL ETL type of procedure. We just decided to go to an automated tool, something that was more visual.

What other advice do I have?

Oracle put Informatica into their product line. They use Informatica fo do the integrations. The one benefit is that you reduce your administrative overhead by implementing this tool, and you get more… more »
AmanyEldaly
Real User
Data Engineer at a tech services company with 51-200 employees
Dec 30 2019

What is most valuable?

The solution is a very helpful product for data integration. The partitioning and optimization to help enhance our development is a very valuable aspect of Informatica PowerCenter. There are multiple transformations for service consumers to publish and use web services as well,In addition to the ability to implement ETL and ELT n a very easy way and finally, you have structured data for use in an… more »

What needs improvement?

The multiple interfaces in Informatica PowerCenter are not great for the user experience. Because of this, I think it can cause confusion for any beginner developer. When we are dealing with multiple transformations and mapping, we cannot see the flow of our transformation until we run reports. It is not like Informatica Developer, where we can see every step of what we're doing and the flow of… more »

What other advice do I have?

I'm working with a lot of Informatica products. I use Informatica PowerCenter and IDQ as well as Informatica Axon. In terms of Informatica Powercenter, we're not using the cloud. We have it running on our own servers. Overall, I find that it's a very helpful product and a powerful tool compared to other products. I would rate this solution eight out of ten.
Reseller
Director of Innovation & Development Department at a tech services company with 51-200 employees
Jul 21 2019

What is most valuable?

The solution has the best user interface and it's the most user-friendly of all data integration tools.

What needs improvement?

Now they are migrating to a new version, and they have something that is called Informatica Developer. Previously, they just had PowerCenter. Now, when they move everything to Informatica Developer it's not as good or stable like it was… more »

What's my experience with pricing, setup cost, and licensing?

Price-wise, it's more expensive than SSIS, but it's a better tool, so it has more features. Licensing is on a yearly basis.

What other advice do I have?

We have some projects on call. I work for a professional services company, so we have different clients that have different types of infrastructure. For us in our region, most of the clients have an on-premise infrastructure. Usually, we… more »

Which other solutions did I evaluate?

We looked at IBM DataStage, Microsoft SSIS, and Oracle Data Integrator.
Kirill Slivchikov
Real User
Owner at 7Spring Consult
Oct 18 2019

What is most valuable?

The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of… more »

How has it helped my organization?

Informatica PowerCenter moved forward the technology level of ETL-process management of the bank with visualization and standardization of ETL development instead of a huge volume of scripting used previously. Moreover, the task of… more »

What needs improvement?

I hope that the next release of this solution will: * Work with HADOOP and other BigData solutions. * Have an ability to compile code to run it quicker. * Include new features for parallel job execution. * Include more instruments for LOGs… more »

Which solution did I use previously and why did I switch?

As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.

Which other solutions did I evaluate?

We are also using IBM DataStage, Oracle Data Integrator, SAP Data Services. From project to project it's up to the customer.
Real User
Senior ETL Developer at Office of State Revenue
Aug 01 2019

What is most valuable?

The features I find most valuable is that the solution is very user-friendly and the graphical design is very easy to understand.

What needs improvement?

I would like to see an improvement in the digital adoption. It would be nice if they could be cheaper, because the training is very expensive as they do everything online.

Which solution did I use previously and why did I switch?

We previously used a Microsoft solution but that was not very scalable. That is why we switched to Informatica, as it is much more scalable.

What other advice do I have?

I rate this solution an eight out of ten and I will recommend others to use it, even though it is a little expensive, compared to other solutions.
Hassan Emam
Reseller
Regional Manager at a tech services company with 201-500 employees
Aug 05 2019

What is most valuable?

The stability of the solution is one of its best features. The user interface is also very good.

What needs improvement?

The cost and set up of the licenses could be improved. You need a lot of different licenses, depending on your setup, and it gets expensive. For example, we're connected with Oracle, be we need licenses for that plus the core server, Terradata, etc. It gets costly. There's also a feature that exists on IBM DataStage called CDC. It's not on Informatica PowerCenter, but if they could add a feature… more »

What other advice do I have?

We use the on-premises version of the solution. I'm a consultant, and I largely work with enterprises. I would recommend the product for integration. It's one of the best tools in the integration field. I would rate this solution nine out of ten.
See 5 More Informatica PowerCenter Reviews

What is Informatica PowerCenter?

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

Also known as
PowerCenter
Informatica PowerCenter customers

University of Texas MD Anderson Cancer Center, LexisNexis, Rabobank

Read Archived Reviews