Informatica PowerCenter Reviews

I use Informatica PowerCenter as the main integration tool in our organization.

The most valuable feature of the solution stems from the fact that it is good for big data, meaning it is a useful tool if there is a need for integration functionalities to manage a huge amount of data. The tool has many functionalities and options. The main valuable features of the product revolve around its flexibility and ability to deal with big data. The tool's components help my company in areas where integrations are required.

The price of the product is an area of concern where improvements are required, considering the fact that the present licensing charges of the tool are expensive.

In the future, there will be a need to develop the product's features related to integrations with APIs. Nowadays, the most popular integration features that products offer are mostly related to cloud-based areas. When users want to fetch data from the cloud and not do it with the help of an on-premises model, then how to deal with the part involving JSON format is something I want to be made available in the product's future releases.

Though I have experience with Informatica PowerCenter, my team members work specifically with it more than me.

It is a stable and trustworthy solution. Stability-wise, I rate the solution a nine out of ten.

I use the product in my company, which is in the business of shipping containers.

Presently, I don't see the product's scalability features since our company works with it, but any changes or improvements in our environment with the use of the existing tool that is installed have been seen. I have not experienced any changes recently in our environment with the use of the tool.

Three people from my team work with the product in my company.

My company does not plan to increase the use of the solution.

I rate the technical support a nine out of ten.

My company uses several tools for integration purposes.

There is a very strong side of usage in our company when it comes to Informatica PowerCenter. Informatica PowerCenter is good for B2B, while there are other tools my company uses to manage in-house integrations. In our organization, we use several types of integration tools, and it all depends on the targets of the users.

The product's initial setup phase is very easy.

I rate the initial setup phase a nine on a scale of one to ten, where one is a difficult setup process, and ten is a very easy setup phase.

The solution is deployed on an on-premises model.

The product's deployment process in our company doesn't take much longer to be completed since it is an easy process to prepare the object to be deployed. The product can be deployed in a few hours.

The licensing charges of the tool are expensive.

I rate the product's price a ten on a scale of one to ten, where one is a low price, and ten is a high price.

I recommend the tool to those who plan to use it, but there might be certain disadvantages attached with the product in the areas of pricing and its integration capabilities with APIs.

I rate the overall tool an eight out of ten.

We have several uses cases for Informatica PowerCenter. We ingest data from different sources, for example, from API or other databases. We also apply data transformations in almost all cases via Informatica PowerCenter, to aggregate the data. We also check the integrity of the data and improve the data quality by applying some rules. We specify and identify all the rules and the methodology to apply the rules. We also participate in rule setting, and also check the test cycles for businesses.

What I like most about Informatica PowerCenter is that it's the best tool in the market for data integration. Currently, I work in L'Oréal, where a new system from SAP is used. Informatica PowerCenter integration with SAP is very, very fast and very, very simple, so you have the server flow from SAP, and through Informatica PowerCenter, you can ingest the data and make that data available for the business more quickly.

What needs improvement in Informatica PowerCenter is the cloud experience because, nowadays, other companies, such as AWS, Azure, and Google, have more experience in the cloud. The pricing for Informatica PowerCenter on the cloud is also very expensive for customers, so some customers prefer open-source tools or lower-priced tools, such as Azure. From my point of view, Informatica must work on the pricing policy and review the policy on the cloud for Informatica PowerCenter or propose more tools with lower pricing.

Clients want the automatic integration of Informatica PowerCenter with other tools. Currently, the integration process is manual, and you have to add other tools to facilitate the integration, especially with the DevOps methodology. You need scripts and tools for the integration, and you'll need to use other integration tools if you want automatic deployment for Informatica PowerCenter, so this is another area for improvement in the solution.

What I'd like to see in the next release of the solution is for the integration with APIs to be simpler, because currently, the API integration feature of Informatica PowerCenter is very difficult. It's not intuitive. You have to facilitate API integration and the real-time streaming of messages in Kafka, for example, so that should be improved.

I've been using Informatica PowerCenter for ten years now.

Informatica PowerCenter is a stable product. For example, last year my team applied some hotfix to resolve some problems, but it's very rare to experience problems from the solution.

As we work on on-premise environments and the environments are fixed, we're unable to check how scalable Informatica PowerCenter is.

Informatica PowerCenter provides good client support. My team got in touch with support when there was an issue with the solution, and the Informatica PowerCenter support team communicated how to install the hotfix, and the issue was solved.

On a scale of one to five, I'm rating support a four. I didn't give it a five because sometimes, support isn't that qualified in terms of explaining the product and the problem. Informatica PowerCenter support is available, though. For example, I've worked with the support team last year, and I received a call two hours after opening the ticket. The support team answers quickly, but what can take time is understanding and explaining the problem and the solution. Sometimes, it could take three or four days before the problem is resolved because after working on the ticket, it would be escalated to another team, and so that takes time.

The initial setup for Informatica PowerCenter is complex, especially if you don't have a lot of experience with the solution. The deployment could take one day to complete, but in more sophisticated environments, it could take a week, so it depends.

We implemented Informatica PowerCenter through an in-house team.

The pricing for Informatica PowerCenter is expensive. Some clients have simple needs and only want to integrate and store data. Some clients have small needs, while some clients have bigger needs and focus more on performance and time. The licensing cost for Informatica PowerCenter isn't good.

In my project, if I remember correctly, the company pays €20,000 per year for the Informatica PowerCenter license. I'm not aware of additional costs that you need to pay for some features of the solution.

On a scale of one to five, I'm rating its price a three.

I've evaluated Azure, Talend, and Data Exchange, but I found Informatica PowerCenter to be better than others. It's just that Informatica PowerCenter needs to have more progress on the cloud side.

I'm an expert on Informatica and some cloud integration tools, such as AWS and Azure.

I have experience with Informatica PowerCenter, Informatica PowerExchange, and also some data quality and master data management tools.

I'm currently using version 10.4 of Informatica PowerCenter.

The solution is deployed on-premises, but I also have experience with its cloud version.

Informatica PowerCenter requires maintenance because you have to take care of the environment, clean the logs, and check some CPU metrics, for example, the memory. The solution also requires some maintenance, for example, you need to restart it when the service is down, so maintaining it uses up your time.

You can have a team dedicated to Informatica PowerCenter maintenance, but that depends on the client. Some clients have dedicated teams for it, while some ask that you take care of the maintenance of the solution.

My team has ten people working on Informatica PowerCenter, but I do know that other teams work on the solution as well, particularly in integration, but I don't have information on how many Informatica PowerCenter users those teams have.

My advice to anyone looking into implementing the solution is to work on it or develop step by step. You also need a good concept to develop complex flows and mapping. You need to develop and test simultaneously to safely deliver good mapping and good products for your clients. You have to test. You have to invest in testing.

I'd rate Informatica PowerCenter seven out of ten.

Our company uses Informatica PowerCenter as an ETL tool for data warehouse purposes.

Informatica PowerCenter has good user feedback. The developers can easily make mappings in the solution.

Informatica PowerCenter can improve its unstructured data handling part. Unstructured data handling is an important area with a shortcoming that needs improvement in the solution.

I have been using Informatica PowerCenter for fourteen years. Also, I am using the solution's latest version. My company has a partnership with Informatica.

It is a stable solution. Stability-wise, I rate the solution around an eight out of ten.

In my team, around 15 people, that includes engineers and developers, use the solution.

Scalability-wise, I rate the solution around a seven out of ten.

Informatica PowerCenter's technical support is responsive. I rate the technical support a seven out of ten.

Neutral

I have previously used Datastage, an IBM product, the support for which was not proper. Informatica had the provision for moving to the cloud.

The solution is deployed on the public cloud by Azure.

The solution does not require any installation to be done at my end.

Since the solution's cost is higher, I rate the pricing as a five out of ten.

There are no extra expenses in addition to licensing costs.

Currently, we moved to IICS.

Two engineers are needed for the maintenance of the solution.

I would recommend the solution to those planning to use it.

Nowadays, better products are coming into the market. If you ask something from five years ago, I would say it was fine back then. Better products are available at a cheaper cost, so the competition is high for Informatica.

Overall, I rate the product a seven out of ten.

We are using the on-premises version and are working towards moving into the cloud. I design ETL workflows.

I'm pretty focused on narrow processes, including realizing business requirements connected to particular workflows. 

The solution has been issue-free overall. 

The traceability has been extremely useful. You can see all of the workflows, and you can trace the data transformation very easily. Each column in the target can be easily traceable, and you easily can see all that data transformation on the path from the source to the target.

The setup is straightforward. 

It's stable.

The solution can scale a bit. 

Technical support is helpful. 

This product is not on the cloud yet. We need to move to the cloud. While on-premises is a better product, we really need to move to the cloud and need the cloud to be as robust as this product.

We'd like to see improved lookups in the future. This is a transformation feature that helps us find rows in the database. It would help if this were easier. 

I've used the solution for about one year. 

The stability is great. I'd rate it nine out of ten in terms of reliability. There are no bugs or glitches, and it doesn't crash or freeze. 

The scalability is okay. I'd rate the ability to extend seven out of ten. We have had problems with large volumes of data.

This is a very popular tool and is used quite extensively. I'm not sure if we plan to expand usage in the future. It would depend on the future development of Azure Data Factory. 

Technical support is helpful and responsive.

I previously used SSIS. I used that at another organization and switched jobs. This company uses Informatica.

We have found the initial setup to be very straightforward. I'd rate it eight out of ten in terms of ease of deployment. 

The future migration to the cloud will be a long process, and we're expecting the migration from on-premises to the cloud to take about half a year. 

I don't deal with pricing or licensing. It's not in my scope of work. 

I'm an end-user. 

The product is a very popular ETL tool. 

There are good courses available to help people learn the product, and it is a valuable tool to get to know. 

I'd rate the solution eight out of ten overall. It is easy to use and stable and offers good support. However, I'm not sure if it is ideal for smaller companies. Some of the hardware requirements may be difficult to fulfill. 

We use this solution for regular ETL access. All our warehouses are built through Informatica. We also use Informatica to build data marts.

It's very easy to use it to develop mappings and workflows.

Informatica are very rigid when it comes to cloud migrations which discourages customers in moving their solution to the cloud. I cannot simply move my code from on-premise to the cloud. There is a conversion process and that conversion process has to be done by Informatica. They charge a huge amount for their professional service. 

Informatica is not as mature when it comes to cloud solutions and cloud connectors and still they want to charge for cloud IACS adoption. If I compare Informatica with Oracle, Oracle provide almost double the licenses when we move onto a cloud solution, regardless of what on-prem license we have. The migration is free of charge.

In a future release, we would like to have cloud connectors.

We have used this solution for more than 15 years.

This solution is not scalable.

This solution is stable.

The customer support is not great. I would rate them a six out of ten.

Neutral

We have not previously used a different solution. We chose Informatica because we needed an enterprise solution. The problem with Informatica data capture is that it is not an end-to-end solution. We have a different automation solution called Oracle GoldenGate. 

The setup is straightforward but we have been doing it for 15 years. A good feature they offer is the backward compatibility which makes the setup seamless.

We did it in-house. 

I would rate the pricing for this solution a six out of ten. The exact pricing depends on various products that you have. We have various Informatica products and it varies from automation to automation.

Informatica is so rigid and so we were trying to look for other partners for our entire ETL process. Modern data solutions are more cost effective and mature with the latest data basis or cloud awareness. We are going to decrease our usage of Informatica.

If you already have Informatica and plan to move to the cloud solution, then you have to evaluate other solutions based on compatibility and do a thorough cost analysis. They have been the market leaders for more than 15 to 20 years. They could use their experience to make better products for modern cloud adoption. 

I would rate this solution a five out of ten.

I am using Informatica PowerCenter as a data integration tool, and for standardization and validations.

The most valuable feature of Informatica PowerCenter is data transformation and user-friendliness.

Informatica PowerCenter could improve the data threshold for large sets of data. Additionally, they should add real-time integration.

I have been using Informatica PowerCenter for approximately 11 years.

The stability of Informatica PowerCenter is good.

Informatica PowerCenter application can scale very well.

We have more than 100 users using this solution which includes a mixed variety of work titles or disciplines in the company.

I have used the support from Informatica PowerCenter.

I rate the support from Informatica PowerCenter an eight out of ten.

Positive

The initial setup of Informatica PowerCenter is easy. The full deployments can take approximately seven hours.

Informatica PowerCenter is worth the money to use for its benefits.

We are using an annual license for Informatica PowerCenter.

We did evaluate other options before choosing Informatica PowerCenter. We selected Informatica PowerCenter because it fits the feature requirements of our customers. Additionally, the customization and integrations are easy compared to any other tool.

My advice to others is for them to get used to using the tool and make sure near real-time integrations are less. If they want to keep the configurations and use batch mode data they can do so.

I rate Informatica PowerCenter an eight out of ten.

Informatica PowerCenter is a data extraction and data loading tool. We extract data from some sources and we load data to different source systems.

Improved the data integrity, data flow and data managment with consummption too made easy and ustainanble and scalable.

The most valuable feature of Informatica PowerCenter is the flow designer functionally. It is the best out of any ETL tool. Additionally, the solution is reliable and trustable in dealing with large data sources anytime. When we're using billions of data transactions, it's smooth. 

Informatica PowerCenter could improve on the documentation for the implementation. The documents provided are not very good for a new user.

In a future release of Informatica PowerCenter, they should add more flexibility on re-usability options. Reusing any setup developed on Informatica PowerCenter, more options to make it reusable, exporting the setup, or importing the setup to any project folder or anywhere in Informatica PowerCenter so that we can use it as a plug-and-play option.

I have used Informatica PowerCenter within the last 12 months.

Informatica PowerCenter is stable. We did not have any downtime.

Informatica PowerCenter could improve its re-usage strategies. There is a scope of improvement in the re-usability of their applications. They could make it more user-friendly for re-usage so that we can create plug-and-play options for different setups.

We have more than 100 people using this solution in my organization.

I have not used the support from Informatica PowerCenter.

Oracle data integrator to Informatica because of reliability and cloud benefits.

The initial setup of Informatica PowerCenter is of a moderate level of difficulty. The full implementation took approximately one day.

When evaluating other solutions we found Informatica PowerCenter to be the most stable.

We had a major banking client, and Informatica PowerCenter is the go-to option when we are dealing with any kind of banking client. It provides the stability and very trustability factor for any kind of banking client's requirements.

This solution has provided me with all functions that I need. I recommend others to use Informatica PowerCenter if they have a decent knowledge of how data migration and data integration works. If they have good knowledge about it and if they have used any other ETL tools previously, they will find it easier to use Informatica PowerCenter. 

If it is for a beginner, I would suggest they learn something about the basics of how data migration works, and then they can start using it.

I rate Informatica PowerCenter a nine out of ten.

We use the solution to extract and transform data from various sources into databases. Further, it helps us optimize data using Tableau dashboard to make business decisions.

The solution has proved to be an excellent ETL tool for our organization. It is also easier for our higher management to get an overview of the backend activity.

The solution's most valuable feature is its support service. The support team efficiently resolves any technical issues.

They should release new versions for the solution's on-premises setup. It is challenging for us to switch to on-cloud immediately.

We have been using the solution for more than eight years.

It is a very stable solution. We haven't come across any significant stability-related issues with it.

It is a scalable solution. But its licenses are costlier compared to cloud infrastructure.

The solution's support service is excellent.

The solution is straightforward to install and configure. The duration of the deployment depends on the project. In some cases, it takes time to procure machines. Once we get the devices, developing the required environment takes another three to four days. In scenarios where we have to build the solution in labs, installation takes around six to seven hours. Also, it requires maintenance at a repository level.

The teams required for deployment depend upon the use cases and specific requirements. We need multiple vendor teams to complete the process if we have various sources and databases to work with.

The solution's licensing is expensive in terms of scaling.

I advise others to consider the licensing part of the solution before making the purchase decision. If they have no cost-related issues, then it is the best tool. I rate it as a nine.