Informatica PowerCenter Reviews

PowerCenter is the market leader, so more organizations use it than other tools. It's a feature-rich solution, so that's why it's at the top of the market.

PowerCenter has three clients. I wish they would consolidate everything into one GUI, not three. Also, we had a persistent issue with the Informatica Developer tool but it was solved when we migrated to the newest one. 

We've been using PowerCenter for about three years.

I think PowerCenter is stable. Organizations that try Informatica stick with it for a long time. No one uses Informatica and quickly switches to something else. It has been the leader in the market for many years.

Any feature that PowerCenter doesn't provide can be found in IDQ. IDQ covers any missing options, so I think it's PowerCenter's scalability is fine.

There were a few times when Informatica support took a while to solve the issues, but they always fixed the problem in the end. There was only one ticket that took a long time to solve. I rate their support eight out of 10. 

I rate PowerCenter eight out of 10 for ease of deployment. 

I rate Informatica PowerCenter eight out of 10. It provides everything I need. Nothing is missing. PowerCenter is a good tool for on-premise databases. If you're going to implement PowerCenter, you need to think about your requirements to determine what tools to use.

For example, I need the repository to auto-refresh. When I make changes to a project, workflow, mapping, or session, I want everything to refresh automatically. Otherwise, you must disconnect from the repository and reconnect for the changes you made to be reflected in your project.

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

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.

Our primary use case for this solution is at a Russian bank.

The goal was to integrate DWH with a banking core system that used Pervasive SQL 2000 DB. The bank as our client in the field of Data Warehousing asked us to extract data from their core banking system and build a Data Mart for preparation of regulatory reports.

Informatica PowerCenter moved forward the technology level of ETL-process management of the bank with visualization and standardization of ETL development instead of a huge volume of scripting used previously. Moreover, the task of integration of systems based on different technology platforms was successfully solved.

The most complex task, in this case, was to read and transform BLOB data, and Java transformation in Informatica Power Center was a great solution. The second task that was solved with Java transformation was the correct transformation of the Amount field (each amount in PSQL 2000 is stored in three different fields). These tasks were solved by using PSQL 2000 Java SDK library imported to Informatica PowerCenter Java Transformation.

I hope that the next release of this solution will:

• Work with HADOOP and other BigData solutions.
• Have an ability to compile code to run it quicker.
• Include new features for parallel job execution.
• Include more instruments for LOGs analysis, interpretation, and job corrections.

It works stably but needs a dedicated professional admin in the project team.

It's scalable and can be supplemented by a Data Quality solution.

We used the vendor's distant support and the expertise was excellent.

As we are a consulting and data management company, the instruments we have to use during the project are chosen by our customers.

The initial setup of this solution was straightforward.

We implemented this solution at the customer's site as consultants. 

We are also using IBM DataStage, Oracle Data Integrator, SAP Data Services. From project to project it's up to the customer.

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.

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.

Data Integration: Integrates heterogeneous source platforms data into the unified data warehouse.

Easy, scalable, robust platform to integrate heterogeneous source platform's data into the unified data warehouse.

Data Integration. The UI-based ability to create data mapping. Also, reusable definition of data sources and the out-of-the-box availability of a large number maplets for common transformation functions.

Cost! 

Also, BI features. While Informatica is great for data-integration, it does not have any analytics features. Thus, organizations have to always look for another product for their BI needs.