Informatica PowerCenter Reviews

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.

I use this solution for everything from real-time processing to complex, high-volume batch workflows. 

In terms of performance improvement and tuning, there should be a bit more guidance and documentation. I would also like to see improvement on some of the installation, especially to the adapters. The setup for the SAP adapters is a bit complex.

I have been using this solution for the past eight years.

The solution is stable. 

The solution is scalable. Around 50 employees are using the solution every day at our company. We would like to continue using it and also evaluate using the cloud version.

I would rate the technical support as a four out of five. 

Positive

The initial set up was easy. It wasn't cumbersome. 

Deployment took about a day, and we handled it ourselves. 

I would recommend that others considering the solution go ahead and use it for any batch and high volume loads with complex transactions. Informatica performs very well. I would rate it as an eight out of ten. 

Informatica PowerCenter is a data integration tool. We use it as an extract, load, transform tool and we can transfer data from production to test or to any other environment.

We have several use cases. For example,  we use it to create data warehouse applications, which are used for analytics and to help generate business value.

Another use case is to modify a test environment such that it is compliant with GDPR regulations. We can use it to transfer production data to a test environment for the purpose of facilitating our testing. Another use case is that if we are working on a data warehouse application, it can be used to extract data from different sources to load into the target environment.

The most valuable features are that it is quick and easy to use. Anybody can master it in a short time.

The interface is very clean and clear.

This tool integrates with distributed systems.

I would like to see improvements made to the custom transformations. It should be more open for users that want to write their own code and use cases. As it is now, writing custom transformations is not user-friendly.

I have been working with Informatica PowerCenter for approximately two years.

This is a stable product.

Informatica PowerCenter is scalable.

We have one person in the company in charge of administration. 

I am part of a seven-person team that uses it, although there are a lot of other applications in the company that make use of PowerCenter. The number of users overall is huge.

We plan to increase our usage in the future.

Our admin team is from Informatica, and if we have any problems then we contact them. For example, the tool that I work on directly interacts with PowerCenter, where PowerCenter works as a backend for my application. If I have connectivity issues or need special access to PowerCenter, I contact the admin team and they help me to sort out the issues.

Prior to PowerCenter, I used an open-source tool called Talend. It was not very good.

The installation is not complex. It is easy to do because you just need one database, such as Oracle, set up as the backend, and some executable files.

I was not involved in the deployment. Another team in our company was responsible for it.

The licensing fees are paid on a yearly basis.

In summary, this is a good tool and I definitely recommend it. It integrates with distributed systems and if the use cases involve data ETL then this is the best tool to use.

I would rate this solution an eight out of ten.

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.

• Able to access heterogeneous databases: It can work with any kind of database available in the market. In fact, it can be applied to NoSQL databases as well.
• SQL override allows users to write simple to complex queries inside mapping for performance tuning the load process, pre and post SQL can help control the load process to get desired outputs.
• Error handling techniques: Informatica provide a suite of options to handle errors. From logging error in database tables to e-mail notifications with log files, to decision/assignment tasks for data control, it can handle error at every stage of workflow. Restart options for batched work-flows.
• Debugging, is one other feature I found extremely useful. Before running a full load, you can run a subset of data from source-target and check for values generated from logic at every transformation.
• While in debugger mode Target tables do not load any physical data. The best part of debugging in Informatica is that, in the debugger mode, you can alter logic in expression transformation and check for the value generated from the logic. This will allow you to change logic if it's needed later.
• Transformations - the types of transformations (SQL Logics) provided are unmatched to any other ETL tool out there. When it comes to using transformations, even a beginner can understand with minimal effort, how to use them or what the expected output will be using that particular transformation. Most of them are self-explanatory, and provide the desired output. Especially Expression Transformation (which is the heart of any mapping).
• Can be used to build any type of logic with flexibility giving the number of logical functions (date/time/string etc...). Functions have a syntax that is very easy to understand.
• Informatica provides all the functions indexed in a proper fashion in expressions editor with syntax to allow users to build logic with ease.
• Version control, as check-in and check-out are easy and allow space for adding comments. These comments can come in handy during deployment when writing queries.

Our organization had to import data from AS400, implement a sales cost analysis and load data into Data Mart, which was further consumed by QlikView. This was done with data from five different countries in different time zones. From the point of developing mapping, replicating them for other countries given their respective databases to loading the data, everything was automated and scheduled with notification about the loads. It changed the way we did business. Customers orders, modification, and tracking was all smooth. Every morning, we would receive one e-mail with consolidated load statistics and it all starts with one e-mail.

There are three areas where they can make a significant improvement:

1. Live feeds, where if a database object changes then object definitions should automatically get refreshed as well. This would avoid re-import of objects. Auto refresh will effect all the short-cut objects, but ultimately if the object in the database has changed, then the mapping will fail or provide incorrect data given the position of the column or name of the column doesn't exist anymore.
2. The GUI Interface. Instead of having to open a separate window for Designer, WF Manager and WF Monitor. If these three windows could be merged into three separate tabs or built into the hierarchy of building sub-tasks, for example, workflow opens a session, and the session opens a mapping unlike opening only mapping properties currently, that would be nice. SAP BODS has that structure and I would like to see something along those lines, where I don't have to refresh the mapping and session every time something changes
3. Version rollback, where version control is a blessing and boon. While the version control is a good feature, sometimes it becomes a huge burden of the database and the Repository should have a way to rollback keeping most current object and purge all other versions.

Starting with version 7.1, I have been using Informatica for 7+ years.

Deployment can get complicated depending on Queries. Adding proper labels and comments during version control can make Deployment very smooth. I did not come across any technical issues using deployment. Rollback feature adds a lot of value to deployment. With a single click, you can rollback all the objects if you notice any discrepancy with objects between environments.

Informatica is very stable tool. Only a few times, where Informatica server is remotely based, connectivity can be slow at times. I have had a few instances when expression editors gets grayed out when using RDP or Docking Laptop but editing "regedit" file resolved this issue. Otherwise this is a very stable, powerful and robust tool.

Informatica can handle extremely large volumes of data very well. With features like CDC, Incremental Load, Mapping Parameters and variables, dynamic look-up, pre and post SQL, Informatica provides flexibility in handling huge volumes of data with ease. Certainly a lot depends on optimized mappings and work-flows (batching and performance tuning).

We've only had to contact customer service twice in 6+ years, and they were very good with their responses and were very professional.

I would say 9/10. For what I needed, technical support was able to resolve it in timely fashion. I also appreciate their follow-ups.

We were using a conventional RPG programming tool to do analysis, but every time you add more tables for data analysis, profiling, quality, manipulation, it was turning into pages and pages of code. A user friendly GUI interface like Informatica solution, provided the right kind of solution and was easy to migrate from programming to Informatica.

The initial setup was a conventional data warehouse pattern. Later on, when we started implementing CRM, SCM and ERP it started getting a bit complex. However breaking down projects into multiple data models and organizing

We had a boot-camp training and an Informatica expert onsite for a few months. Later, we picked up a fair amount of technology and started implementing it in-house.

Informatica is 100% value for money. The kind of flexibility and stability it offers in dealing with heterogeneous data is amazing.

It is not an economical software, but if you are planing for a long term robust end-to-end enterprise level tool that can handle any kind of data, and any type of task relating to BI or data warehousing, it does not require a lot of thinking. You can bank on Informatica for your solutions.

• Data Stage

• Ab Initio

• MicroStrategy

Informatica is a great product. If you can spend a good amount of time researching what you want,have a proper SDLC in place, and work with the technicality of Informatica, I am sure most of the projects can roll out into production in a timely fashion and produce results. In my experience, not having proper road-map in place, and not auditing change requests, business analysts will struggle with their requirements. This causes more bottlenecks and rework than an actual development. Having said that, no project is a walk in the park, but Informatica can be the icing on the cake if the foundation is good.

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 are a solution provider and this is one of the products that we implement for our clients.

The most valuable features are the monitoring tools and the reporting manager.

Integrating new tools can be tricky and challenging.

I have been working with Informatica PowerCenter for more than five years.

I have not seen any issues with respect to stability. 

We have been in frequent contact with the Informatical help center. It is not only me but other people in the company. They have been very good at supporting us.

We were using the cloud version of PowerCenter with one of our clients, but they have since moved to MuleSoft.

Usually, the initial setup for PowerCenter is straightforward. The is nothing complex about it. However, if you are integrating new tools or if you are putting in an adapter for a product like the Amazon Cloud Service or RedShift, it will be challenging.

The price of this solution is high.

With an interval of every couple of years, they upgrade to a new version and stop supporting the previous versions. At this point, you need to acquire a new license. 

If you are looking to add a new adapter then it will be more costly.

My advice is that if you are looking for a traditional on-premises service, PowerCenter is a good option to stick with. If on the other hand, you want a cloud-based service then there are better options.

In summary, this is a good product, and other than integrating with other tools, I don't face any challenges.

I would rate this solution a seven out of ten.

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.