Informatica PowerCenter Software Reviews

Filter by:Reset all filters
industry
Loading...
Filter Unavailable
Company Size
Loading...
Filter Unavailable
Job Level
Loading...
Filter Unavailable
rating
Loading...
Filter Unavailable
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»

If you previously used a different solution, which one did you use and why did you 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»
Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: October 2019.
371,062 professionals have used our research since 2012.
AmanyEldaly
Real User
Data Engineer at a tech services company with 51-200 employees
Jul 29 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.

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 in mapping, we cannot see the flow of our transformation until we run reports. It is not like Informatica Developer or IDQ, where we can see every step of what we're doing and the… 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.
Vijaya Saduvuv
Real User
Lead Application Developer and Informatica Administrator at a healthcare company with 501-1,000 employees
Jun 06 2018

What is most valuable?

It works with any multi-database, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use.

How has it helped my organization?

It reduces a lot of legacy coding.

What needs improvement?

It has everything we want. We were looking for a feature but they have already it in Informatica 10. We are using Informatica 9.6.1 but they added the feature we were thinking about in 10.1.

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

Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick… more»

What other advice do I have?

If you are a small company it depends on how much data integration you need. I cannot blindly say you should always go with Informatica because it depends what your needs are and whether you can… more»

Which other solutions did I evaluate?

When you want to convert all your company products into Microsoft, the equivalent to the Informatica product in Microsoft is SSAS. That's where the decision was made to go with the SSAS as the primary… more»
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.

If you previously used a different solution, which one did you use and why did you 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.
Suneel Mopuri
Consultant
Integration developer at a tech services company with 10,001+ employees
Jan 24 2018

What is most valuable?

* Big Data connectivity, Data Integration solutions, and Data Quality solutions. * Easy to code and understand solutions in Informatica.

How has it helped my organization?

We are trying to implement both Finance and Operations modernization with the help of Informatica. This tool is mainly used in data ingestion, where we bring different sources into a Hadoop environment.

What other advice do I have?

Good product if you are trying implement data quality, data integration, and data management projects. We have a good relationship with the vendor. We get notifications related to new products for user validation and beta release. We have given user experience feedback for Operational Insights tool.

Which other solutions did I evaluate?

There are a lot of other data integration tools available in the market. Based on our needs we have to choose which is applicable: Talend, SSIS, Ab Initio, DataStage, ODI (Oracle Data Integrator).
See 4 More Informatica PowerCenter Reviews

Articles

User Assessments By Topic About Informatica PowerCenter

Find out what your peers are saying about Informatica, Microsoft, Oracle and others in Data Integration Tools. Updated: October 2019.
371,062 professionals have used our research since 2012.

Informatica PowerCenter Questions

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
Sign Up with Email