Informatica PowerCenter Reviews

We use Informatica PowerCenter to extract the data from legacy products and load it into new applications. We're using it for this purpose only. Apart from that, we use the Data Quality tool for data quality issues. We use this solution to extract and load.

I like the automated scheduling feature. Suppose we want to automate data anonymization, we have tools within PowerCenter for that. In terms of the capability of data loading features, Informatica products are better.

Support could be better. Technical support's friendly, but we should be able to get responses from them more quickly.

We found PowerCenter to be stable. When comparing the tools within the Informatica PowerCenter and IDQ, we felt that PowerCenter was more stable for data quality and extraction purposes. Through the command mode, we can do many things for loading purposes, and for all that, PowerCenter is better.

Informatica PowerCenter is highly scalable. Whether it's 4000 records, one million records, or ten million records, we did all these use cases, and it was fine.

Technical support is fine, but we got some delayed responses or didn't get proper responses in certain cases. But overall, it's okay.

We have used some other tools, but we found this solution when we had a huge dataset. We felt that PowerCenter was capable of doing the extraction and loading better than other products. We were also using Microsoft SQL Server DTS in the previous year.

It's easy for me to install Informatica. But for configuration and domain creation with multiple nodes, it will take time. If you have to do it multiple times, it'll take even more time. 

For a simple installation, it's straightforward. Otherwise, it will take three to four hours for multiple nodes under multiple services. For example, if you're doing it for only an integration service, it's very simple. But for our data integration service and other services, it will take more time.

I implemented this solution by myself. 

I would recommend it to potential users.

On a scale from one to ten, I would give Informatica PowerCenter an eight.

On-premises

I have worked with Informatica PowerCenter in different companies for different projects.

We use Informatica PowerCenter for ETL. We need it for our data integration project.

It's quite suitable for our needs.

It's a complete package, which is why we use this solution.

We have not had any issues with this solution.

There is some room for improvement in terms of pricing.

I have been working with Informatica PowerCenter for four years.

Informatica PowerCenter is a stable solution.

Informatica PowerCenter is a scalable product.

We haven't encountered any problems that would require assistance from the technical support team.

We did however contact technical support about pricing for the implementation of the site.

I have been working on ODI (Oracle Data Integrator), but we prefer Informatica.

The initial setup is quite easy. It is easy to handle and debug as well.

Normally, it doesn't take long, but it depends on the issues we face.

I was unable to locate any pricing information on the website. I made an appointment to meet with a representative through the internet.

According to what I've heard and read on various blogs, it's quite expensive when compared to similar competitive products.

Based on what I've read, I believe the price can be customized.

There are several products, but we recommend using this solution.

I would rate Informatica PowerCenter an eight out of ten.

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

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 when it was PowerCenter, though it has some nice features. 

I would like the solution to offer better metadata management. 

I've been using the solution for more than 10 years.

The solution is really stable. 

For scalability, all you have to do is buy licenses for more cores, so it's about licensing. If you want to add more CPU cores you have to pay more licensing. All of the providers of ETL tools have different licensing models, and it's something that is typical. So, if you have to process more data then you have to pay for more licenses. That's natural. 

We have about 50 users and they're developers and consultants.

Technical support is great. It's one of the reasons we really like them. When you compare support from IBM and support from Informatica. Informatica is much better.

Initial setup is very easy. It's straightforward. They have really good manuals. They have a great installation manual. They have user manuals as well, so you just have to follow instructions. Everything is fine.

Usually, we have system administrators do the implementation.

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.

We looked at IBM DataStage, Microsoft SSIS, and Oracle Data Integrator.

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 have on-premise deployments.

I would recommend this solution to others.

I would rate this solution nine out of ten. It's almost perfect.

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.

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

More than five years.

Yes, we had stability issues, mostly with JVM size.

Yes, there can be scalability issues. Huge amounts of data ingestion will impact performance.

I rate tech support seven out of 10.

Straightforward.

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

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.

Our primary use case of this solution is for building data warehouses for clients with data visualization tools. We need to pull data from other sources so we use Informatica as the ETL. The solution is generally deployed on-prem but sometimes on cloud. 

The solution provides good performance with an easy to use interface and reasonable documentation.

One of the things that I found lacking is that there should be some sort of a calculator where you can input your requirements regarding the number of data switches required, number of users, and the number of data switches in order to get a general idea of cost. It would save me time rather than having to run to the company to get the information. 

The solution is stabl. 

It's a scalable solution. 

I haven't had any issues with technical support. 

This is an expensive solution.

I would rate this solution an eight out of 10. 

On-premises

Once you figure it out, it is a powerful and simple ETL tool. Its stability has been very satisfactory.

Like any other ETL tool, it collects business information for centralized reporting and analytics.

The UI is outdated and old-fashioned, at least in our current version. Also, we have experienced some stability issues with the Workflow Monitor application.

Our company has used it since 2002, I started using it in 2009.

The integration service itself is very stable. The applications suffer from minor stability problems.

The product scales very well, beyond our needs.

The technical support team is eager to help but the problems that we have faced were usually too complex. However, there has always been a workaround.

Our company has always used this solution.

I was personally not involved with the initial setup, but from what I have heard, it was fairly straightforward.

We have found the pricing very cost-effective. The licensing is CPU and data source-based.

In the new version, it is supposed to allow a variety of data sources with the standard license.

I was not involved with choosing the product.

Choose the right tool for the right job.

For the purpose that this product was designed, I believe it is still the best in the market.

• The possibility to create a data profiling mapping automatically from any imported source.
• The client installation includes a macro that can be imported into Excel. This will contains standard documents for technical design and documentation in general. The technical design developed in Excel can be directly imported into Powercenter using Powercenter Repository Manager and the corresponding mapping is automatically created. This can save a lot of development time for simple or not very complex mappings. This feature is called Mapping Analyst for Excel.
• The default error handling, automatically created, is quite good for those architectures that don't have a proper one or a budget for a custom one.

As all ETL tools in general, it does not include a good data reporting feature. Another one is the component called "Union" which includes some bugs:

• Adding new groups, the field-names are lost
• Adding new fields, the field type should be reset for all fields in the "Union" or the mapping validation will fail.

There is no possibility of handle non matching records in a "joiner" as in DataStage.

4-5 years, different versions.

No

No

No

I used other tools like IBM DataStage. The final decision is made by my clients but what I see is that clients using DB2 prefer to use DataStage over Informatica as both (DB2 and DataStage) are IBM products.

Very straightforward.

In-house