Informatica PowerCenter Reviews

One of my use cases is integrating personnel data from multiple systems.

Once you have learned Informatica, it is very easy to use.

The feedback that I have received from team members is that they found it easy to work with.

It is very difficult to learn.

The documentation could be improved. For example, if they were to create a system like SAS Books or IBM Redbooks that includes books on how to install, and how to troubleshoot problems, then it would be great.

I would like to see a centralized dashboard that can be used to access all of the Informatica products, rather than having a set of fragmented applications. A consolidated system with everything in a single platform would make it easier for technicians, as well as when it comes to purchasing it. That would be amazing.

I have been using Informatica PowerCenter for two years.

This is a stable product that has been around for a long time.

We have approximately eight people who use Informatica in the organization.

The customer service is good but they can't move you through the entire installation and troubleshooting process.

I also have experience with solutions from IBM, SAS, and other vendors.

My IT team was responsible for the deployment. Our team has approximately 12 people and they are responsible for installation and maintenance, including upgrades.

I consider this to be an expensive product.

In summary, Informatica is a good product that is very difficult to learn but once you learn it, it's very easy to use. It is a product that I can recommend using.

I would rate this solution an eight out of ten.

We use the solution primarily as an ETL.

It helps with the automation process. We have a lot of requests from the user to create for them data alerts. We have had some success using Informatica. 

It is an excellent tool. It covers our needs. 

The solution is used mostly to handle our daily data loads in our data warehouse. We've been successful so far using it. 

It provides monitoring and we can therefore be aware of what is happening when we are handling jobs. 

The ETL and monitoring tools are the most useful for us.

The transformations we need to do, to comply with user requests, is very easy with this product.

The solution is stable.

It can scale. 

We also have a data integrator, and if we were to compare the software together, the one thing Informatica doesn't have is the ability to create the script inside the solution. We need to rely on Unix or Windows. We can't do the scripting in Informatica itself. We need better integration potential. 

The FTP tools that the solution has are limited. 

If you want to transfer a ZIP file, it is a pain. You need to use Command-Line. Sometimes we just want to transfer a file. It should be easy to move them from A to B.

I want to eliminate interdependencies on the script. If Informatica could do everything, it would be a more powerful tool.

We'd like to have all of the capabilities available in the cloud available also on PowerCenter.

The solution is expensive. 

I've been using the solution for four years. 

Sometimes we have problems, however, the problems are in the database, not Informatica. The solution is very stable. It's reliable. I'd rate it ten out of ten. 

We're in the process of moving to the cloud. 

PowerCenter itself can scale. 

I've never contacted technical support. Typically, I will Google an answer to my questions. It's easy to find what I need on their website or online. 

I did not use a different solution. This is my first experience working with a data center. I did use the ETL from Microsoft that came with the SQL server. 

I didn't handle the installation. I did practice installing on my workstation to practice, and it was easy. However, for the entire company, it was handled by a third party. 

While it is on-premises right now, we have plans to move everything to the cloud in the short term. We are working on that right now.

The installation process is done by a third party.

I don't deal with licensing and have never seen an invoice. I am aware it is expensive, however. It's as expensive as Oracle. When you want to use the best brands, you have to pay.

I did not evaluate other solutions. By the time I came to the company, this solution was already in use.

When I was in another bank, we selected Informatica which was a recommendation of a consultant. Informatica at that time was one of the best ETL tools, even though it was expensive. 

I'm an end-user.

The solution is very popular. I'd rate it ten out of ten. It is an excellent tool.

The product is primarily used for building the data warehouse as an ETL tool for our hospital.

In general, it is a great tool. 

The initial setup is not very complex. 

There are many features available. It has very rich transformation tools. You can have union integration. There are many kinds of set operators, aggregators, and plate operators. 

Graphically you can define a lot, and you can also inject variables too. If you define one transformation, you can replicate it with several sources. 

It has very good monitoring and process monitoring. 

There is an excellent scheduler. 

The integration capabilities are pretty good. 

We've found the solution to be very stable. 

It's a product that scales well.

It doesn't have the change data capture feature. That's why we have been exploring some alternatives.

The licensing is difficult. It prevents us from accessing all of the features.

Since I haven't used the latest version, it's hard to comment on what needs to be added. 

I've been using the solution for more than ten years. 

It's a stable product. I'd rate the stability at five out of five. There are no bugs or glitches. It doesn't crash or freeze. 

You can easily scale the solution if you need to.

I'd rate the ability to scale 4.5 out of five. 

We have around 100 or more sources using the solution. 

We don't really use technical support. However, we did initially find it quite good. 

We did not previously use another solution. 

The solution is pretty straightforward to set up. It is not complex.

We got some training on the transformations and the ETL process itself; however, the implementation of the things was done by then. The strategy was to have teamwork on the building and accumulating data from the hospitals and then build a data warehouse around it. 

The full deployment took two months for us. We had two engineers working on the implementation. 

Our team handles the maintenance. One or two people are handling it. Other than running some interim tasks, everything is scheduled, and then some operational monitoring is required. Otherwise, there are no other maintenance jobs to worry about.

The deployment was handled in-house. We did not need any installation help from integrators or consultants. 

Licensing is frustrating as you have to pay for some additional features. It would be ideal if it were all under one cost.

We usually have a license that lasts a year or two.

We do not pay for technical support. You have to pay for it separately every year.

At the time, around ten years ago, we compared the product with the Oracle Data Warehouse builder, however, PowerCenter was a much better tool.

Many of its current competitors came into the picture after we installed this tool.

We're end-users.

We are not using the latest version of the solution. We are using one of the previous versions. It's around version 10. I don't know the EMEA number.

I'd rate the solution nine out of ten. 

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.

Informatica PowerCenter is basically used for data integration and ETL processing, data extraction from different heterogeneous sources, and putting that data into different relational databases.

PowerCenter has proven to be the most beneficial for our data integration tasks. Informatica PowerCenter provides multiple transformations in one particular toolset. You don't need to apply any coding. 

Those transformations are the most valuable thing in Informatica PowerCenter, which helps to do the data integration part easily.

Error handling capability:

Error handling capability is quite good in Informatica PowerCenter because it provides a very detailed session log, which is really helpful to identify the errors. 

In addition, there are KB articles, which are published by Informatica, that are really helpful. Even if you face any issues or errors, we can resolve that issue. 

If the error is not at all possible to solve with Informatica PowerCenter, we can raise a case with Informatica, and their support team helps us to address that particular issue. If it is not possible to solve with that particular version, they consider it and try to solve it with the next patch or hotfix.

AI Capabilities:

Informatica PowerCenter doesn't fit into AI-related things because it's an on-premise tool, which doesn't have any significant role in the field. It is just an ETL on-premise tool. 

Basically, in the AI field, Informatica PowerCenter is not going to be that impactful. Informatica has launched IICS and IDMC (Informatica Data Management Cloud). Their AI comes into the picture there, but for Informatica PowerCenter, AI doesn't come into the picture at all.

Instead of using SQL queries, Informatica PowerCenter is very helpful when extracting data from multiple sources. That is one of the valuable things. 

Other than that, we can do multiple transformations in Informatica PowerCenter.

For data integration tasks, Informatica PowerCenter provides multiple transformations in one toolset. You don't need to apply coding or other things. The transformations are the most valuable thing in Informatica PowerCenter, which helps to do the data integration part easily.

I have had performance issues with this product. When I deal with very large amounts of data, performance issues arise.

Improvement is needed in terms of some new transformation because API integration and all those things are very critical nowadays. Some level of transformation, new transformation, if they introduce that, would be helpful, other than that, the performance and scalability related things that they need to improve. 

If they are launching another Informatica PowerCenter with a new version, I'm not sure about it because they are promoting IDMC, they are not promoting Informatica PowerCenter.

I've been working in Informatica PowerCenter for around eight plus years.

It is an on-premise environment, so it's not as scalable as compared to Informatica Cloud.

There are around ten-plus developers and around four administrators using this product.

The approximate volume of data we process varies from project to project; on average, it is eight to nine gigabytes of data.

I have experience in Informatica Cloud, IDMC (Informatica Data Management Cloud), Azure Data Factory, and a little bit of Fivetran.

Informatica PowerCenter is a very robust tool. You can implement any kind of complex business logic with it. However, Informatica PowerCenter is a very traditional ETL tool that came into the market very early in the 2000s. They have a very good hold on the market and are able to handle all the complex data problems and business data integration use cases.

Whereas, other tools that came new into the market are less complicated to learn, execute, and create data pipelines. But sometimes, I feel that if some complex business problems arise, then we need to jump into the coding part. And there are not as many transformations available.

The initial setup is not at all easy. Setting up PowerCenter is not at all easy, especially when you are installing your server on Linux machines. It's very complicated, especially the upgrade part, if it is a multi-node cluster environment with high availability.

I would recommend using it. But currently all things are moving to the cloud. Informatica PowerCenter is a little bit lagging behind, and now everybody is moving to the cloud.

So, Informatica itself is promoting the use of IDMC and cloud instead of Informatica PowerCenter. But some clients, like banking and pharmaceutical clients, still prefer traditional on-premises ETL tools. So, in that case Informatica PowerCenter is definitely one of the best and unbeatable tools for enterprises.

Overall, I would rate the solution an eight 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.

I am using Informatica PowerCenter to upskill and learn to use new tools.

I found the map links, work links, and workflows valuable. They are important features.

It would be better if I could do all the work within a single window. If I'm working on any mapping and if I have to switch to sessions, I have to open a new window altogether. If I have to get into workflows, I have to open a new window. It was also very expensive. In the next release, I would like it to be more user-friendly.

I have been using Informatica PowerCenter for over two years. 

Informatica PowerCenter is a stable solution.

Informatica PowerCenter is a scalable solution. Expanding is easy, and we can execute multiple workflows based on events. I don't see any constraints, and it looks pretty good. We have approximately 50 or more people supporting or developing applications for various clients.

I have experience with SSIS, and I compared the features. They are different, especially on the navigation front and the user interface. The SQL server integration service is always handy in Azure. Most of the time, you'll be using Microsoft products, so their interface is very user-friendly. But in Informatica, it'll be completely different, especially on the mapping side. When you map from the first to the next target, you have to know how to connect the source and targets. But in SSIS, it's easy for a layperson to understand how the data flows.

The price could be better. It's very expensive.

On a scale from one to five, I would give Informatica PowerCenter's price a one.

On a scale from one to ten, I would give Informatica PowerCenter a nine.

We primarily use the solution for the ETL.

They know what they're doing, and it's a more mature tool compared to Talend. They really think about every scenario. For example, if you want to write a data cleansing algorithm and all that is probably rules. It's just easier. There are a lot of provisions in PowerCenter. In terms of the transformation algorithms and all that, there are a lot of operations. It's great.

The solution is stable.

It's a scalable product.

PowerCenter seems to be a little bit higher side of cost. Customers are thinking about alternatives. Talend seems to be a pure Java-based thing, however, there are some technical hiccups there. There are a few finance companies are probably started using Talend as a competition tool for Informatica. Most of the smaller companies are trying to build open-source-based ETL tools.

It should be more cloud-centric than on-prem-centric. That is where the problem with Informatica.

We've used the solution for a couple of years. 

It's a stable product. There are no bugs or glitches. It doesn't crash or freeze. It's reliable.

The solution is scalable. 

We have three or four clients we are working with in terms of Informatica.

In terms of technical support, there is plenty of information is available online, however, their tech support is okay.

Snowflake is something that is surfacing. Every customer is now started asking about Snowflake. They're thinking of it being a viable option. When it comes to data warehousing, it's the kind of a solution that you want to deal with huge among this data processing. 

Most startups and probably smaller companies thinking of building a custom open-source pipeline. It could be Pulsar-based, or Kafka-based. And that is what they're looking at. In enterprises, they don't want to go with a hundred percent, the open-source solutions. They like Informatica or probably Talend or probably some of the ETL tools that are available.

It's not a simple setup. It requires a bit of a learning curve, no doubt about it. For example, if you want an index, a three or four-year engineer would need to handle that. If you want to make them as a utility engineer, there is a learning curve involved. 

It took us three to four months to deploy the solution. 

We have 12 to 14 people working on the deployment and maintenance of the solution. 

The pricing could be a bit better. 

For example, if you look at Snowflake, companies are thinking of innovative ways of reducing the price and then transferring the benefit to their customers. 

In terms of innovation, creativity is not there in this solution. It is still an on-prem ETL tool. Informatica is one of the best options today and no doubt about it. However, is it cloud-ready? I don't think so. Therefore, I'd rate the solution a five out of ten.

Beyond cloud readiness (or lack thereof), pricing is an issue. It's relatively high compared to other products on the market. We all have to move from IBM thinking. You sell the customer and then penalize them with the pricing, pricing, pricing. That is where IBM has today become a dead man walking underneath, has become two different companies now. This company should learn from IBM. Pricing cannot be the only way of making money and probably comes with innovation, creativity, making it cloud-ready, and then transferring those benefits in order to sell more licenses.