Informatica PowerCenter Reviews

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 the solution for businesses that wish to analyze their raw data. The solution allows us to do data cleansing and to transform the raw data into useful, insightful information.

Informatica PowerCenter is a very strong tool which offers a host of features. We can use heterogeneous data to easily merge and derive the useful information. Also, flag files processing is very useful.

An issue which should be addressed is that the solution only allows us to do structured, as opposed to unstructured, data processing. Also, the EPA related data processing should be improved. 

Processing capabilities should be streamlined.

I prefer a third party scheduler tool to that of Informatica scheduler, since the latter is not one which is very physical. The solution is not so helpful if one wishes to perform multiple tasks simultaneously. 

We have been using Informatica PowerCenter for nearly eight years.

Scalability could be improved, as it is of an intermediate level. 

We have plans to increase usage. 

Technical support is really great.

Deployment was simple and straightforward. 

Licensing costs are excessive and pose an obstacle to someone who lacks familiarity with the solution and wishes to have a proper understanding of it. 

We have a team of around 40 to 50 people who use the solution.

I would, for sure, recommend the solution to others, since I feel it to be a really strong tool. It is very robust and has complex capabilities. It allows one to accomplish tasks with ease. We are talking about a strong ETL for those who are undertaking ETL related tasks.

We are using Informatica PowerCenter for our data warehouse to generate reports from heterogeneous data sources from XML, JSON, or CSV databases. We then do some transformations to generate XML ISO standards to send to regulators in Europe and UK.

We have found the PowerCenter and B2B data transformation most valuable. Additionally, they have many native connectors, high performance, and a lot of support documentation.

The solution can improve by providing more connectivity by having native ODBC or JDBC connections available. It will be easier and more people could start using it.

I have been using this solution for approximately 10 years.

The solution is stable.

We have approximately 40 people using this solution regularly in my organization.

The solution is not as scalable as the cloud solutions, we will be releasing it in a few years.

The technical support has been responsive and we were in contact with them quickly. We were very satisfied.

The initial setup was easy. The full implementation took approximately two weeks.

Our internal technical team did the implementation and handles the maintenance of the solution. The maintenance team makes sure Informatica services are started and are up and running.

The solution is in the middle price range compared to other solutions. There are additional costs if you want other features. For example, more connectors or the use of other solutions, such as Snowflake.

I would recommend this solution to others.

I rate Informatica PowerCenter a nine out of ten.

We like that it is cloud-based and the performance is good. The number of docs has been reduced drastically, which is very good.

If you were migrating or connecting with multiple sources, initially there were issues that caused network latency. In the latest version, there are fewer bugs.

The real-time database connectivity when getting the real-time data using the VPN is an area that needs improvement.

Being able to generate reports on all of the status of the monitoring tools and the job qualities would be very helpful to provide to the operational team.

I have been working with Informatica PowerCenter for 12 years.

We are using version 10.4.1, which is the latest version.

It is very stable. It's a solution that has been in place for 20 or 22 years.

The initial setup is straightforward. It is very easy.

When compared with Linux or Windows, it was very easy and simple to install.

It takes two days maximum to implement one nanometer.

When compared with other ETL or ELP tools, Informatica PowerCenter is the best for connecting to multiple sources, which is better when you have large loads. 

I would definitely 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.

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.

This product is primarily used with an Oracle product called OBI EE, Oracle Business Intelligence. It is used for integration and data visualization.

This is the best tool that we have.

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

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.

We have been working with Informatica PowerCenter for about seven years.

I think that PowerCenter is pretty stable.

We have three different instances of this running. There is one for development, one for pre-production, and one for production. As far as having to scale linearly, we haven't had the need by putting additional nodes for high availability or load balancing. It's not something that we've necessarily needed. We have not scaled up, either. So, no vertical and no horizontal scaling. It was pretty much used out of the box.

We have two people who are using this solution and they are developers.

Oracle came in and they implemented a lot of the functionality that we needed. Beyond what we received from Oracle, there were very few times where we needed support.

Most of the time, the only thing we needed technical support was with Oracle patches and we ran into a problem, something broke.

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.

The initial setup is pretty straightforward. I don't think that there were any problems with it.

We had a lot of assistance from Oracle and the implementation took less than a week.

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

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 functionality out of it versus most other tools. 

With a lot of other tools, you have to do a lot of hacking in order to get things to work properly for you, whereas with Informatica, you have a lot of flexibility.

I would rate this solution an eight out of ten.