Informatica PowerCenter Reviews

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.

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.

Informatica PowerCenter is purely an ETL tool used for data integration.

Informatica PowerCenter has many features compared to Talend, DataStage, and Airflow. Among all the solutions I have used, I found Informatica PowerCenter to be much more stable in terms of application. Also, one won't face issues related to bugs when using Informatica PowerCenter.

Compared to solutions offering similar functionalities, Informatica PowerCenter is not very flexible regarding customized integrations. It's not a very customizable solution.

I have been using Informatica PowerCenter for approximately nine years. So, I work for different consulting companies, and their customers use it. My job role is of a consultant and architect.

Since one does not have to face sudden issues while using the solution, I would say that it is a stable solution compared to similar solutions in the market.

It is not a very scalable solution. It is usually used in enterprise-sized organizations.

The solution is easy to deploy and manage. I also usually help my customers to implement and configure the product. The time taken for the implementation process depends upon how big of an implementation process has to be carried out. So, for a single customer, it took around three days to deploy the solution. However, three months were required for the customization part. The solution gets deployed on-premises and on the private cloud.

I rate the overall product a 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.

Our company has requirements to move from legacy systems to new cloud systems. This helps migrate the data. We have complex logic and integrations on some of the systems, and Informatica makes migrations possible.

The cloud version is very useful.

The features provided are great.

It is stable and reliable.

Technical support is quite helpful.

The setup is very simple. 

There are a lot of cloud connectors missing on the on-premises. These do exist on the cloud, however.

We'd like better integrations with ServiceNow and Splunk. It's not so integrated with the infrastructure. We need more compatibility and more detailed information on operational insights. 

The solution does not scale.

I've used the solution for more than ten years. 

The stability is great. There are no bugs or glitches. I'd rate it nine out of ten. It is extremely reliable. 

PowerCenter is not scalable, however, the cloud is very scalable. 

We have 100 developers on the solution. 

Technical support is very helpful. We are very satisfied with the assistance we get.

Positive

I have previously used several other tools. However, PowerCenter is very stable. 

PowerCenter is very easy to install. I'm not sure about the cloud deployment, however. 

The deployment and configuration might take about three hours. 

If the environment is small, you only need one or two people for deployment and maintenance; however, if the environment is bigger, you likely will need more. 

We did not need any help from a third party. We have teams that can install the solution in-house. 

I'm not sure about the details of licensing, however, we pay for the license yearly. 

I am a customer and end-user.

I'm not sure if I would recommend PoerCenter. However, I would definitely recommend the cloud.

I'd rate the solution eight out of ten. Unfortunately, it doesn't scale and lacks some cloud connectivity.

PowerCenter performs well during data transformation and optimization. 

PowerCenter could integrate better with cloud applications. We had to do a lot of configuration work using API integrations to connect with cloud applications. Informatica Cloud Data Integration has a generic connector that you can use directly, so it's much easier. 

I used Informatica PowerCenter for around five years.

PowerCenter is stable. 

I rate Informatica PowerCenter 7.5 out of 10 for scalability. It has limited options for connecting with real-time applications, such as IBM and cloud applications. 

Setting up PowerCenter isn't easy. It requires some in-depth knowledge and specialists who know how to deploy the solution. Deployment takes a couple of days. We did everything in-house with one or two people. 

Informatica is beneficial if your data is advanced, structured, and optimized and if you are generating reports to use in decision-making.

The license is baased on the number of users and connectors. A medium-sized organization has few applications and connectors, whereas a massive organization needs many more licenses. It needs to connect all the enterprise business applications, like Salesforce, SAP, Oracle, etc. 

I rate Informatica PowerCenter seven out of 10. It's a good product that many organizations in banking continue to use because it isn't easy to migrate to something else. 

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.

I'm working for a casino, and we use this solution in our company to replicate different databases, such as from Oracle to Teradata. Most of the time, it is used for replication, but sometimes, it is also used for doing some calculations, additions, or unions for ETL.

It is currently deployed on-premises, but we will be moving to a cloud solution by the end of the year. We are currently doing a proof of concept and evaluating a cloud solution from Informatica.

The support is valuable. There are also open-source ETL products, which work very well, but there is no support. When we face a production problem, being able to get support is valuable, and it brings efficiency. With an open-source solution, we can't engage anyone to resolve the problem as quickly as possible.

Its stability is high, and it is also scalable.

Some of the conversions are done inside the product. We use work tables that are created by the engine itself, but the names of the work tables are very long, and they don't have any meaning, which makes it a bit difficult to understand and follow exactly what is happening inside.

We would like to be able to communicate with our Google Cloud platform. This feature probably exists, but I'm not sure if we tested it. 

It is very stable.

It is scalable. There are no problems. It is only a financial matter. You just need to have more machines. The price changes depending on the number of CPUs that are involved. 

We have 24/7 support because it belongs to the production environment. We just have to open a case, and somebody takes up the case and provides an answer. They also call back, and there is also a knowledge base.

We had Sybase ETL, but it was not exactly for the same use. We also had some homemade solutions between Db2 and Teradata. We switched because to deal with more databases, it was easiest to use a real ETL solution.

It isn't complex. In the beginning, we have to test and try different parameters. Once that is complete, it is done for all the processes. If we have some trouble, we can call support, and most of the time, we can find people to help us in choosing the right parameters from different parameters.

The complete implementation—which includes doing the proof of concept, understanding how it works and what work has to be done, migrating all existing workflows—took over six months.

We implemented it ourselves.

I would rate it an eight out of 10. It works.