Informatica PowerCenter Reviews

Our primary use is to implement our data warehouse, including moving data between FTP, flat file and relational databases, and Domain/Integrated Service designs.

Informatica PowerCenter has been implementing mapping design, data flow, and workflow execution for years. Informatica administrators are in the scope of daily operations.

• Import from PowerCenter
• Copy Text between Excel and the Developer Tool
• Logical Data Object Read and Write Mapping Editing
• DDL Query
• Profiles

• XML processing
• Scheduler
• Non-limit SQL qualifier embedded (right now 32K limitation)

The Integrated Reporting service should be more smoothly transitioned from view to function to be in sync with the main design.

We are using it to source data from Sybase database and flat files so as to load to the target Greenplum Database. The facility to do parallel load on Greenplum using gpload feature is valuable for us. Also, the ability to scale through partitions helped us to improve the performance.

We used Informatica PowerCenter for a re-platforming project where the earlier application was using an in-house Java-based ETL, that suffered in terms of the performance and scalability issues. With Informatica PowerCenter, we were able to overcome all the performance bottlenecks and we were able to standardize the ETL layer. The re-platformed application was able to complete the high volume batch data load in minutes, compared to the long hours it took in the old application. In addition, the year-end volume spikes are easily handled by Informatica.

In our implementation, for the initial conversion, we had to take on a large volume of data from the legacy Sybase system. This was taking a very long time, i.e., more than a day. We were trying to improve it with partitions to gpload, but we were told that we can't go more than four partitions. This was a limitation then and I am not sure if this has already been improved.

I have used this solution for four years.

Not many stability issues were experienced.

Not many scalability issues were experienced.

Technical support is good; also, we had engaged professional services during the application development.

The legacy solution was using an in-house Java-based ETL, that had huge problems in scaling for high volume batches. As part of the re-platforming exercise, we switched to Informatica so as to get a more stable and standard solution.

With knowledgable developers, the setup was not complex.

We evaluated the Pentaho solution.

It is a good, scalable solution, provided the infrastructure is taken care of.

Our primary use case is to collect data from different sources and to build it for the house or data hub, or to fill already built-in appliances like Cloudera and Teradata. 

It has helped us meet our monetization needs. 

Real time is amazing. If you have AI use cases, you can predict if it's a threat or if it's a positive or negative transaction. You can use real time with PowerExchange to write data directly to Kafka, to consume, write, or parse data using an AI algorithm to detect if the data is positive or negative and to define what use cases you want. 

It would be nice to move from Windows tools (like Developer, Designer, or Manager) and have everything in one place like DATAQ developer, which is eclipse-based and user-friendly. 

CDC needs more improvement. It's stable and has good features, but it's only easy to develop if you are familiar with Linux. 

Sometimes a new monitor will not be accurate in logging or you'll open a log and get a misleading error message. The connection parameter is sometimes inaccurate, or the parameter will not load. Proactive Monitoring doesn't work very well with all of the Informatica processes. The latest version came out five years ago and there has been no enhancement since then. It doesn't make sense for a product to be ranked number one but have no enhancements. The product hangs and you can lose control for several hours. It works, but it hangs. 

I have been using PowerCenter and PowerExchange for around 7 to 8 years. 

It's stable and we rarely have any issues. During the setup, when developers tried to connect, there were some issues, but it ran smoothly once it was configured and fixed. Sometimes, there is conflict between servers (like Analytics, Data Quality, or PowerCenter) and we have problems with loading libraries.

It's easy to scale, but it has a limit. For high availability or for service on the grid, it's okay, but it has a limit. If we had the option to enable scalability based on big data architecture, like Adobe or MongoDB, it would be easier. In Enterprise Data Catalog (EDC), you can extend them by adding nodes to the cluster, but currently, to maintain scalability in both centers, you'll add a node, join the domain after that to distribute work, but fortunately, this works well. We also got a complaint, when adding a node, that the session failed without recovery. 

For technical support, there are levels. The first level of support is called TechAccess and it's between Informatica and other vendors. TechAccess takes time and their response is often delayed. After that, we escalate and go to the Informatica level of support. Once we reach them, they proceed to explain the solution. 

We've tried SSIS and DataStage, but we prefer PowerCenter for stability and monitoring. 

The set-up was simple and I did it myself. If you try it one time, it'll be easy the next time. The one product that does need improvement in installation is Enterprise Data Catalog, EDC. It's very difficult and all my colleagues hate communicating with and installing EDC.

I implemented it myself and with my team. We have expertise, so there was no need to engage Informatica Professional Services. 

The pricing is a little expensive, but in the same range as IBM and other competitors. There is not a big difference in pricing between its main competition. The pricing is mostly the same between other vendors. 

PowerCenter is good for large enterprises and good for ETL purposes, but not for ELT. If you need to go with ELT, Informatica has another package called Data Streaming that's more stable and recommended for a larger environment. 

I would rate Informatica an eight out of ten. 

Our primary use cases of PowerCenter are database regulatory reporting cases. Both sides are suitable for us to net trace metadata and it's easy to develop or hedge, after production as well. It's also easy to understand the steps or ETL. 

I'm working with the latest update, and it's deployed on-prem. 

One of the most valuable features for us is the metadata repository because it can easily understand the lineage of first target mapping. My company and I also find Informatica really easy to use—when a consultant joins our company, in just a few days to a few weeks, they can understand how to use it—so we prefer to use this ETL tool. 

PowerCenter could be improved by having more big data components. Normally, we prefer Informatica as a relational database, but nowadays, companies are trying to understand and use big data components. I think it would be useful if we had more chances to create a hub ecosystem because customers try to use some data integration tasks by SQL, Spark and Spark codes, and Scala, but at the end of the day, the company will understand that we need to trace all the steps. An ETL tool is a must for that company, if we're talking about the regulated industries like finance, telcos, etc. If Informatica's biggest ecosystems feature were okay, I would prefer to use it. 

I have been working with PowerCenter for more than seven years. 

The stability and performance of PowerCenter are good. 

The scalability is fair enough. 

PowerCenter is suitable for large companies. The pricing could be an issue for some companies who want to implement and develop with PowerCenter.

I haven't been in touch with technical support in the last few years, but before that, I contacted them many times. I remember that when we were using PDW, the previous version of Microsoft APS, we contacted Informatica support teams a few times to handle connection problems with the driver of PDW, and they solved it. I was satisfied with the support. 

The initial setup of PowerCenter is a simple process. The first development took just a week—a few days is enough. 

We provide implementation services to customers. We are a consultant company, so we use it for our customers on the customer's side, but we don't have a business relationship with Informatica. 

Compared to other tools, I think PowerCenter is a bit expensive. When I compare it to Oracle, if you want to use Oracle databases, you can easily get an ODI tool, so it's easier to handle. Informatica is a standalone tool—it's an independent company—and there are no databases around them, so it's quite expensive to use. 

Generally, large companies use PowerCenter because of the price. If companies want to expand their usage areas, they try to consider if it's easy to implement and easy to understand the pricing. I think the pricing is a barrier for Informatica. 

I rate PowerCenter a nine out of ten. To those looking into implementing PowerCenter, I would advise evaluating whether they have a large company. If their first criteria is not pricing, I totally recommend Informatica as their first ETL tool, but if there are pricing, performance and support, etc. requirements, maybe they can evaluate ODI and Informatica together. If you have an Oracle ecosystem, I think you can get Oracle or ODI cheaper than Informatica, but if you don't, I think Informatica could be a leading option. It depends on what the customer has. 

We use it for data integration. It's a great tool.

It reduces a lot of legacy coding.

It works with any multi-database, so it works with Sybase, SQL Server. Also, the performance is really good and it is easy to use.

It has everything we want. We were looking for a feature but they have already it in Informatica 10. We are using Informatica 9.6.1 but they added the feature we were thinking about in 10.1.

The stability is great.

Scalability, durability, everything. It is the leader in the market.

We are using technical support every year, it's part of like maintenance we get from Informatica. Year by year they are improving. They're up to the mark.

The initial setup is not straightforward. You need expertise to do it.

Licensing is a one time cost. But maintenance costs depend on what you want, how long you need it. Maintenance is a kind of insurance. With health insurance, you don't know whether you will get sick or need to go to hospital or not but you have to have insurance. It's the same thing with support.

If you have that expertise in resolving issues, if you have enough experience in your IT department, I would say you don't need the support. But in practice, they recommend you go with the support. If you want support you have to pay for it.

When you want to convert all your company products into Microsoft, the equivalent to the Informatica product in Microsoft is SSAS. That's where the decision was made to go with the SSAS as the primary option, going forward.

If you are a small company it depends on how much data integration you need. I cannot blindly say you should always go with Informatica because it depends what your needs are and whether you can afford Informatica or not.

I would give Informatica a 10-plus out of 10 because it satisfies all our requirements, it is robust and scalable.

Informatica PowerCenter is a very good ETL tool. 

The solution's commercial cost is very high. Other open-source tools can do the tool's functions for free. The world is moving to the cloud, but the solution hasn't updated its drivers. I presume that its downfall will start soon. The tool is trying to cross-sell or upsell without helping customers derive benefits from the existing products. They have multiple tools and licenses. It is better to bring the smaller tools in one umbrella. 

Informatica PowerCenter's technical support varies. 

Neutral

I rate the solution's pricing a four out of ten. The price is very high, and it doesn't understand the market now. 

I rate Informatica PowerCenter a six out of ten. 

Informatica PowerCenter is being used for data warehouse development, using ETL and ELT, e.g. Informatica PowerCenter for ETL and Informatica Cloud Data Integration for integration between systems, e.g. with their downstream systems.

What I like most about Informatica PowerCenter is that it enables integration and connection with multiple new systems, both structured and semi-structured. I also find its adapters for multiple source systems valuable. Its features meet industry standards. It is a proven high-performing enterprise-scale ETL solution.

Though I wasn't able to explore all features of Informatica PowerCenter, it would be good if Informatica can also have connectivity with NoSQL compliant, unstructured data sources, e.g. Microsoft Azure Data Factory or Talend.

The cloud-based solution mostly focuses on continuous data stream processing, but not on batch processing. If Informatica enhances this cloud-based solution to also do the batch processing of data, and also integrate semi-structured and unstructured data processing, that will be more beneficial.

I've been working with Informatica PowerCenter for 15 years.

I find this solution very stable.

Informatica PowerCenter is easy to scale.

The support team is responsive. They're able to address our issues.

The initial setup for Informatica PowerCenter was straightforward.

Implementation for this solution was in-house. It was done by our own team.

I evaluated Oracle Data Integrator, Talend, and Microsoft Azure Data Factory.

We are using these solutions: Oracle Data Integrator with different versions, Informatica PowerCenter, Informatica Cloud Data Integration, and Talend. Matillion, we explored, but we don't use it for our company. We are a consulting partner. We are an implementation partner, so our consultants use these to implement solutions to many of our customers. We are an indirect partner through Oracle, and not a direct partner of Informatica.

Informatica PowerCenter is deployed both ways: on-premises and on cloud, but on cloud very recently. In the past two years, we have been using the cloud version. Deployment for this solution could take one to two days, if the person doing it is knowledgeable.

We have a team of 70 members who are data engineers and data analysts, but for the actual installation, setup, and configuration, we have another team made up of system/application administrators. We have a shared service model with 50+ associates who take care of this service. They will take a day or two to complete the deployment. Given all the infrastructure details available from the customer, it wouldn't take more than a day or two, worst case two days on average to set up and start the system, for it to be ready for working on and developing the ETL.

To maintain this solution, in a shared service model, e.g. not dedicated, it requires two to three people, but if it is dedicated, then one person can handle the maintenance.

There are two ways we are using this ETL solution. Number one: as part of Oracle's prepackaged solution, and number two: as an independent solution.

I don't deal with the licensing, but as part of Oracle's pre-packaged analytics solutions, we did use them. There's a one-time fee plus yearly support. That is their model, but I don't know the costs associated.

My advice to new customers of this solution is that if they are looking for an enterprise scale data warehouse and data management solution, Informatica PowerCenter is one of the go-to proven tools. Its limitations are on these two areas: one is that it needs to enable the cloud-based version to do batch processing, e.g. heavy data loads, and two is that it needs to enable connectivity to the NoSQL compliant and unstructured data sources.

Keeping the two product limitations out, e.g. the cloud version has limitations for batch processing and is unable to process unstructured and semi-structured data, my rating for Informatica PowerCenter is an eight out of ten.

We use this solution for ETL and data transformation and we are customers of Informatica. 

This is an old and reliable product. I like the visual tool for data mapping and the workflow manager.

I think the UI could be improved, it's a little outdated. Configuration is  complicated and could be simplified; it requires experience, and not many people have that. 

I've been using this solution for one month. 

Our data engineers are dealing with big data and large files which Informatica is capable of dealing with.

I know that support is available but I've never contacted Informatica. I go to the documentation supply tool to solve any issues.

The initial setup is dependent on the requirements of an organization. Sometimes it's more complicated. It requires and administrator who does everything, and eventually testers are brought in for specific workflows. Each environment requires a different deployment. Maintenance is carried out in-house. 

PowerCenter requires some discipline in terms of the implementation process, and because it is dealing with databases, there are several layers of protection and authorization.