Informatica PowerCenter Reviews

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.

Informatica PowerCenter is used for data integration.

To me, what's most valuable in Informatica PowerCenter is the flexibility in building the integration pipeline. Usually, you need to have a platform to be able to integrate with different technologies, including legacy data such as the mainframe. The platform should also be rich enough to transform the data per your business requirement, with no restrictions.

Rich integration and rich transformation capabilities are the two key capabilities in Informatica PowerCenter. The solution also offers ease of use.

Another valuable feature of Informatica PowerCenter is the drag-and-drop integration because it's GUI-based, similar to IBM and Oracle.

Areas for improvement in Informatica PowerCenter include scalability and high availability or the clustering configuration because that's still very basic. The elasticity or scaling of the platform needs a lot of improvement. For example, when it comes to DR handling or building an active-active or active-passive cluster, Informatica PowerCenter is still not that powerful.

Automation also needs improvement in the solution. Improving automation leads to some improvement in the stability of Informatica PowerCenter and other aspects related to it.

What I'd like to see in the next release of Informatica PowerCenter is real-time capability because the solution is mainly for patches, and to have real-time integration, you need to count on some additional components from Informatica. I would expect more integration and a complete platform in terms of real-time capability or patching with minimal interventions or minimal components to be aligned together.

I've been using Informatica PowerCenter for six or seven years.

I'm still using it as my company has many solutions that leverage Informatica PowerCenter, though the solution isn't that active nowadays because Informatica has a different strategy to promote the cloud-based data integration offering.

Informatica PowerCenter is still in the market, and what my company is using is the on-premise version.

Informatica PowerCenter is a stable solution, and I would rate its stability seven out of ten. There's a small improvement needed in terms of stability because it's linked to the clustering and high availability. Somehow you'll need a lot of automation to get Informatica PowerCenter to handle the workload, and in certain situations, there could be failures.

I found the technical support for Informatica PowerCenter brilliant. I'm even giving it a rating of four out of five just because I can't give it a five. Informatica support is even awarded for customer satisfaction if I remember correctly.

The initial setup for Informatica PowerCenter was simple. It was a straightforward setup, and it wasn't complicated at all.

Pricing for Informatica PowerCenter isn't cheap, but if I compare it with IBM, it's as expensive as IBM, however, Informatica PowerCenter is more innovative, especially when compared to a giant company such as IBM that has thousands of products.

Informatica PowerCenter is limited only to data management, but it has new features that come out every quarter. Points for ease of use and flexibility go to Informatica PowerCenter, but price-wise, IBM and Informatica are equal because they're both expensive.

I evaluated Talend, which is an open-source data engineering and data integration platform. Comparing the two solutions, Informatica PowerCenter is still more robust and has an extendable platform. You can add other capabilities, such as data quality and so on, but if you'll be focusing only on data integration, Talend, especially coming from an open-source mindset, would be a good competitor.

My preference, because I had experience with IBM and Talend, would be Informatica PowerCenter because of the ease of use, flexibility, and features that come with it.

Informatica PowerCenter is an on-premise data integration solution, but two or three years ago, Informatica introduced a new, intelligent data platform. That new platform is the equivalent of Informatica PowerCenter in terms of capability, but the only difference is that it's a fully on-cloud solution.

Informatica PowerCenter is best for big enterprises. Technically, you can use it for any scale, but practically you will get the most output when you're dealing with high volumes and heavy processing. This is from a technical aspect. Price-wise, it's not a cheap platform, so only enterprises with a bigger data management budget will be able to afford to invest in a data management platform such as Informatica PowerCenter.

My rating for Informatica PowerCenter is eight out of ten. Eight is a fair rating because it's a very stable and very mature product.

My company has a partnership with Informatica and other vendors. I'm a system integrator.

In the company I work for, we provide a lot of solutions. I've been working with a lot of clients. The last client I worked with was a big hotel company, and we used this solution for integration.

It's a very powerful tool you can use to load data, get data, do the drawing between the tables, and put it into the packet in a very fast way.

So for this client, we are using the MDM (Master Data Management), and the PowerCenter will be very helpful in building data and merging all the data between the different systems they have. They have a lot of systems that contain the same information and we want to put that into a single place. This is the most valuable feature of this solution which has been of great help to us.

To be honest, we didn't find big issues with this tool. All the issues we found, we were able to fix. We don't have any issues with the tool so far.

I would like to see this solution change the way it creates workflows. In Alteryx, for example, it's easier to build the workflow because of the way it was built, while PowerCenter was built in a more complex way to be able to process a large number of roles. The way PowerCenter creates the workflows is much more complex than the others, but nothing big. It's just that it's the old way. It would be good to recreate the entire interface to make it easier for users to build workflows. This is what I'd like to see in the next release.

I've been using it for 10 years.

The solution is stable. No complaints.

I believe this solution is scalable.

That's a tricky question because it's always complex. For the business logic, it's complex. They had a lot of systems and we had to do the integration between the source. I've been working with this solution for a lot of years, so to me it's straightforward. So that's a tricky question. I would say that for professionals, it's straightforward.

I evaluated Alteryx.

It's Informatica PowerCenter I work with a lot of times, but I also have knowledge on Informatica Data Quality. Now on my last project, I'll be working with MDM, but I'm not an expert on MDM, as I've mostly been working with PowerCenter.

I've been working with this solution since 2010 on a lot of projects which I don't have on top of my head right now. I live in Brazil and I've been working for the government for healthcare where I used this solution. I also worked with PowerCenter for an insurance company. I used this solution during integration where we also created a web API. This is a feature in Informatica that can deploy and make APIs available for third parties or vendors so they can do acquisitions, restore API, and get data. These are what we created in PowerCenter as well.

All the projects were deployed on-premise. I never work on the cloud, but I would love to. Deployment took six months for this project.

We have 30 to 50 people using this solution. If the project goes well, if there are more resources to implement this solution, and more features to improve the analytics of the company, then we will plan to increase usage of this solution.

I'm a PowerCenter guy, so I'm rating this solution a 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. 

We are implementing our master data management integration solution. The idea is to have the data cleaned, and have a catalog set up so that we have a library we can consult to see what type of data is being used. At the same time, have a tool to provide a three hundred and sixty-degree view of our customer data. We will also have a unique repository and a data link that we're setting up in Azure.

We will be moving all of our storage to the cloud so that we have a single repository, and this data will be accessible by our tools such as Tableau, for integration with our reporting. 

Currently, we are in a hybrid-cloud environment, but our intention is to be cloud-based using Azure.

The two most important components are the building and integration. On top of that, you can clean and analyze your data to make sure that you don't have any corruption. In the end, you have structured, proper data for use in an integrated BI solution.

I would like to see the inclusion of a tool that allows you to report performance metrics. For example, it can determine whether the connectivity is correct, or how long it's taking the integration to move data from one place to another. This would allow administrators to govern the performance and better maintain the solution. Having a tool that can work is nice, but we're not sure if it works accurately without something to evaluate performance.

Integration with Artificial Intelligence would benefit this solution. The system should start to learn the behavior of your connections, and understand where your data is coming from to ensure that the process is being done correctly. As the system learns the stages, it will be able to easily identify problems. For example, if I have different databases where I want to store information, such as pictures in one and PDF files in another, it will be able to distinguish that.

We are still launching this solution so I cannot tell you if it is stable or not. We believe that with the support and resources we are getting, it will be. Our vision is to be as stable as possible, and we do not want to lose any data.

We performed some testing with our Asian platform and it was working fine. We are working in several countries at the same time, integrating their products, and we are hoping that it goes as smoothly as the one from Asia. This tool should allow us to scale, but we will have to wait and see.

We have between fifty and sixty people using this solution.

Informatica is assisting us with the implementation and they know what we are trying to accomplish. They have visibility as to what our company does, and having people like that helps a lot. Overall, at the moment we are very happy with the support and their contribution.

We did not have another solution in place before this. We knew that it was something that we needed to do. Since we are moving from on-premise to the cloud, we needed something to help us with the integration.

We hired somebody from Informatica to help us with the implementation. We have no complaints about their service.

Choosing this solution was a little bit complex for us because there are a lot of different vendors in that space. We had to do a proper evaluation and negotiation to get to the solution that we needed. Some vendors offer a certain package, whereas others offer another package, and there are certain components from one vendor that we needed in the other one. There is where the complexity came from. In the end, we choose the one that we thought was the proper solution for us.

There is a lot of competition in the space, and the vendors want to get good companies where they can implement their solution. It doesn't mean that every product fits every organization. My advice for anybody researching this type of solution is to meet with all of the vendors, discuss the proof of concept based on what the company has, and see if the solution is really the proper one for them. The vendors need to be honest in evaluating whether the product can really fit the needs, and they should be able to justify it.

Overall, we are satisfied with the product so far, as well as the support. In any tool, there's always something to chase and always something that can be done better.

I would rate this solution a seven out of ten.

Informatica PowerCenter is a data integration tool.

The most valuable features of Informatica PowerCenter are the ease of use, and development, and is simple to find resources.

Informatica PowerCenter could improve by having a single interface because half of the system is still in the legacy interface and many other elements are moved to the developer client. It would be good if there was a single interface for the end user and developers.

In the next release, Informatica PowerCenter would be beneficial to have run time column propagation. Other solutions have this feature but it is missing in this solution.

I have been using Informatica PowerCenter for approximately 18 years.

Informatica PowerCenter is stable.

The scalability of Informatica PowerCenter is good.

We have approximately seven people using the solution.

The support is good from Informatica PowerCenter and they have been responsive.

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

Positive

The implementation of Informatica PowerCenter is easy.

The price of Informatica PowerCenter is expensive, but it does give value.

This is an amazing solution. If I ranked it in terms of all of the data integration solutions, I would rank it first.

I rate Informatica PowerCenter a seven out of ten.

We use Informatica PowerCenter primarily for its processes. We derive dashboards, functionalities and graphs with the information it provides. We create reports, generate excels, and data scientists use the information to generate reports in Tableau, Power BI or other tools.

It is UI friendly and has all the advantages of an ETL tool. In addition, integration is possible between Oracle and SQL.

It is also relatively expensive but is worth the price because the software provides a good experience. The resources we need exist, and the people are available.

We have been using this solution for about six months. It is private on Oracle but available at our data centre.

It is a stable solution, and there are no significant issues. In addition, it is a relatively easy solution for any beginner or intermediate-level person using it. The only problem is that it is moderately expensive, which is essential to emphasize.

Everything in the market is shifting to the cloud, namely Oracle, Azure, and any other cloud. If a company has a solution on a license, they will use something with the cloud on Google, Azure or AWS. It would be good if Informatica collaborated with Oracle, Azure or AWS, allowing for greater functionalities and benefits.

I believe it is a scalable solution, but I do not have all the details on scalability. For example, in AWS, there are databases like PostgreSQL, SQL and Oracle. So, it would be good if, for a specific price, Informatica PowerCenter could be available in Azure or have the ability to use Azure in the ETL tool.

About six to seven developers use Informatica PowerCenter in my company.

The technical support is helpful.

The setup was easy. However, the solution could have better documentation on basic steps or blocks that specify what to do. For example, a particular topic could be described at length in a video so people can understand it.

Installation is also relatively easy, but when we tried to include data warehousing, extraction or ETL functionality, we needed specific configurations and capacity. That is a pain point for users, developers and architects. However, it became easier after several periods.

In terms of costs, it is moderately expensive, but I am unsure of the exact price. It would be good if Informatica PowerCenter incorporated free trails or learnings to help beginners use the solution. There should also be more campaigns similar to other ETL tools.

My advice would be for Informatica to decrease the price. Generally, companies have more customers when prices are lower. So even if the company grows with a lower margin, the number of users would be higher, which would be beneficial.

I rate this solution an eight out of ten. Regarding advice, it is important that ETL functionalities are readily available and that it is GUI friendly.