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.

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.

We use it for ETL. We have multiple systems, we extract the data, and create a report from it. 

If the systems get migrated or upgraded, the amount of resources required are very minimal. We can change the connections and establish a new connection. It's very helpful.

We need another tool for monitoring. It would be easier if all the features were consolidated into one tool.

I have been using PowerCenter for two years. 

We don't have any problems with scalability. You can increase the nodes and it has good performance. 

We have around 25 users. 

We have two to three employees for maintenance. 

I haven't had much experience with Informatica's support. We haven't had any issues that we needed their help for. 

The initial setup was complex. It depends on the security you're working on. There are no pre-defined rules. We have to create the rules and then start working on it. 

It's very expensive. We have other tools that are more reasonably priced. PowerCenter is very costly. 

I would recommend PowerCenter depending on the use case. 

I would rate it a seven out of ten. 

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.

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. 

Integration between different applications, such as Hospital Information Systems built on AS400 and in-house legacy. It is old data structure file based as opposed to relational. Therefore, it was very difficult to connect and integrate with other new applications. We used Informatica to read from our Hospital Information System and transform the data into a relational model in order to speed up reporting and do cleansing of the data. We also used Informatica to integrate SQL Server based applications with our Oracle applications.

Ease and speed of building integrations, especially integrations between different applications, such as our Hospital Information System. 

The GUI.

10 years.

No.

Its maintenance is expensive.

Yes, we evaluated SSIS and IBM. We also looked at additional features in Informatica.

Our primary uses of the solution are for data integration and to build a warehouse model.

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 integrated business intelligence solution.

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 the mapping. With those solutions, we can see data and transformation and how it's affected by our expressions or anything we do. In Informatica PowerCenter, we cannot see any data in the transformation until the end or you may need to do some debugging, and it is very confusing for some people. They need to enhance their viewer so we can see data within the transformation and show the affected data. 

I haven't had a problem with Informatica PowerCenter's stability until recently. Sometimes it's very slow. I don't know why, but recently, the development has been very slow. I'm not sure if this is related to stability, however.

The solution is good for scalability because it can be supplemented by a Data Quality solution ,Also, if our organization needs the scale increased, Informatica can satisfy this need, because it can deal with different types of sources and a huge amount of data. The features in partitioning and data optimization that Informatica uses make it very powerful.

Technical support has been very helpful. Whenever we have a problem, they are able to solve it.

Informatica platform installation was straightforward, just If the prerequisites checks done successfully, it will be very easy to do.

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.

We use this solution for ETL of a US Law Enforcement agency's data sources to a data warehouse.

Using this solution has given us better performance than just purely using PL/SQL.

The most valuable feature is the new Data Lake feature, which provides the basic capabilities needed.

I found it is kind of weird that not all of the mapping changes are treated as true changes.