Informatica PowerCenter Reviews

We use this solution for ETL and data transformation and we are customers of Informatica. 

This is an old and reliable product. I like the visual tool for data mapping and the workflow manager.

I think the UI could be improved, it's a little outdated. Configuration is  complicated and could be simplified; it requires experience, and not many people have that. 

I've been using this solution for one month. 

Our data engineers are dealing with big data and large files which Informatica is capable of dealing with.

I know that support is available but I've never contacted Informatica. I go to the documentation supply tool to solve any issues.

The initial setup is dependent on the requirements of an organization. Sometimes it's more complicated. It requires and administrator who does everything, and eventually testers are brought in for specific workflows. Each environment requires a different deployment. Maintenance is carried out in-house. 

PowerCenter requires some discipline in terms of the implementation process, and because it is dealing with databases, there are several layers of protection and authorization. 

Informatica PowerCenter is outdated and would benefit from modernization. They should have a very good migration strategy from Informatica PowerCenter to AACF. Informatica PowerCenter there is no point in using it, you have to use a cloud version.

I have been using Informatica PowerCenter for approximately 17 years.

The technical support for Informatica PowerCenter is good.

I rate the support from Informatica PowerCenter a four out of five.

I would not recommend anyone use this solution.

I rate Informatica PowerCenter a one out of ten.

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.

We use this solution for ETL processes.

It has a very good graphical interface.

It has the possibility to intervene in the automatic ETL. 

It has a lot of components. 

It has a Data Catalog that uses the Model repository.

The pricing could be improved.

I have been providing Informatica PowerCenter since 2005.

Informatica PowerCenter is a very stable product.

Technical support could be faster.

The latest versions are easy to install because it's cloud-based. You needed approximately four hours to install the older versions.

It's quite expensive.

Our customers pay a licensing fee yearly.

I would recommend this solution to others. It is also a question of the purpose and how big the company is. It's an investment.

I would rate Informatica PowerCenter a nine out of ten.

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.

It is easy to use, and it is quick for developing things. It is fairly powerful, and it can integrate with a lot of different platforms without much hassle.

Its interface can be modernized. It is an old product. I have been working with it for 14 years, and it still looks the same. It hasn't been modernized much. 

It also needs to handle more modern formats, such as JSON files. It works with the old text files and databases, but it does not always work with the newer, modern stuff. You need to make your own programs to support that kind of stuff.

Support is also a kind of difficult with Informatica. They don't do direct support and rely on using their distributors around the globe for support, which means that you kind of have to go through this layer of different companies before you get help.

I have been using this solution for about 14 years.

It is stable.

It has a cluster repository kind of thing where you can add multiple server nodes.

That's actually one of the parts that are kind of difficult with Informatica. They don't do direct support. They rely on using their distributors around the globe for support. In Norway, there is a specific company that has the license to sell Informatica, and they also provide the support, which means that whenever there is a problem, you kind of have to go through this layer of different companies before you get help.

It requires consultants. I won't be able to do it by myself. I would need some help to do it.

Whenever we need to do an upgrade, we need to call a consultant to do it. It takes about a week for the preparation and all other stuff.

I would recommend this solution to others depending on whether they are on-prem based or cloud-based. If most of their data is on-prem, I would recommend this solution. If they are not on-prem, I would recommend looking for another tool that is more suitable.

I would rate Informatica PowerCenter an eight out of ten.

This solution is really the backbone of what we do. Informatica PowerCenter is one of the most used platforms for data governance in the banking and insurance industry. It's quite expensive so it's not used much outside the industry, but it's very reliable and strong in everything connected to data management and data governance strategy. For our industry, that is crucial. We are customers of Informatica and I'm the head of big data and solution architecture. 

From my point of view, the solution has two valuable features. It has the ability to manage a huge quantity of data along with a high level of reliability from a performance point of view. Secondly, it has all the tools and features within the platform to establish a real data governance strategy. That includes lineage data preparation, ETL, ELP, everything regarding monitoring and processes that are implemented in the platform. It's quite feature full in that regard.

The solution currently requires quite an established data center in place because there is no option for software as a service so the best option to install the platform is on-prem. I know Informatica is thinking about it because they are introducing a brand new platform for big data management, but it doesn't yet have the same level of features as PowerCenter. This is something they can improve on. There are some significant differences between the two platforms.

The other issue is price. I understand this is a high-level professional tool designed for big companies that have a great need for managing huge amounts of data and I understand these kinds of tools are quite expensive, but sometimes the cost is too high. Their focus is obviously a high-level market but I think there would be other companies who would want to use it but it's too expensive for them. 

I'd like to see improved on-prem support like Cloudera which is very oriented towards traditional databases, like Oracle, SQL Server and others. 

We've been using this solution for five years. 

It is clearly a stable solution, otherwise it would not be used in industries such as banking and insurance. Technically speaking, it's very stable and reliable. In my opinion, it's one of the most stable and reliable platforms for data governance.

Technical support is good and a lot has improved over the years. 

Most of my customers use solutions in the cloud so I've used Azure in AWS and GCP. There are lots of services, platform services, or software as a service, tools that are used for the same purposes or objectives, like data governance, data preparation, data integration. It's hard to compare because the environment is completely different and they have different issues. PowerCenter is quite a traditional technology. A product like Hadoop, for example, for storage and process management, has the same objectives but they are fulfilled in a completely different way.

The initial setup is not so easy but once it's been deployed it's quite reliable from a performance point of view.

My advice for this product is to be aware of what's involved and be sure about deploying and using it because it's a very technical tool, something you cannot buy and install in some weird brutal machine. It requires planning and has to be managed, not only in terms of using it, but also economically speaking, because of the cost.

I would rate this solution a nine out of 10. 

What I like the most is that we have to deal with less while writing the queries.

The unstructured data can now be imported into Informatica PowerCenter. This is an achievement for them.

I would like to see it be able to import data from NoSQL.

I have been using Informatica PowerCenter for approximately three months.

It's a stable product.

We are using this solution for seven to eight hours per day. We are using it frequently.

Informatica is scalable, it's perfect. There are no changes required for this solution.

We have not had any issues with technical support. They are fine.

I started coding in SQL, then looked up Informatica directly.

The initial setup is not that complex.

It takes less than a day but more than an hour to deploy this solution.

We are satisfied with the pricing. The licensing is on a yearly basis.

I would definitely recommend this to my friends as well as anyone who is interested in using this solution.

I would rate Informatica PowerCenter a ten out of ten.