Informatica PowerCenter Reviews

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.

Informatica PowerCenter is a very good ETL tool. 

The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella. 

Informatica PowerCenter's technical support varies. 

Neutral

I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now. 

I rate Informatica PowerCenter a six out of ten. 

We are using Informatica PowerCenter to process the data of the files in the landing zone. These files contain a huge amount of data, and Informatica PowerCenter is the source for us to push the data to Azure Synapse. We are using its latest version.

Using Informatica PowerCenter, we can create workflows, tasks, and more. Performance is improved while developing ETL solutions and mappings can be done easily because of the UI features.

Informatica PowerCenter is very good for integrating a huge amount of data in a very short duration, such as a minute.

It is also very easy to use. After you provide the source and the target, mappings are automatically done, which makes it easy to use for the development team.

Its scalability can be improved. It is not scalable.

I have been using this solution for one year.

We have not experienced any technical challenges with this solution.

It is not scalable. Currently, we have three users of this solution.

We have not experienced any technical challenges with this solution.

Positive

I have used the Microsoft Business intelligence for developing SSIS packages for ETL development and Azure has more advantages where ETL development reporting and analysis can be done in a single  environment using synapse analytics 

There is no installation. After they provide the URL, you just log in. You just need the server details, and you can just log in with your Windows credentials.

Our client has purchased the license, and we are using it.

I've only used Informatica PowerCenter.

I would recommend this solution to others. I would rate Informatica PowerCenter an eight out of ten.

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.

We are using Informatica PowerCenter for data integration in a health insurance company.

The most valuable aspects of Informatica PowerCenter are the many features, ease of use, and user-friendliness.

The performance of Informatica PowerCenter could improve.

I have been using Informatica PowerCenter for approximately five years.

Informatica PowerCenter is a stable solution.

I have found Informatica PowerCenter to be scalable.

I have not used the technical support from Informatica PowerCenter.

We have used Data Quality, EDC, Axon, and Metadata Manager.

The initial installation of Informatica PowerCenter was straightforward. The amount of time it takes for the process depends on the deployment site, and how many maps, workflows, and tables there are.

The time it took used for the deployment was approximately two hours.

For the implementation of Informatica PowerCenter, we used one or two developers and one person from the DBA team.

I did not evaluate other options.

I rate Informatica PowerCenter an eight 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 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.