Informatica PowerCenter

Founded in 1993, Informatica is a US-based data management provider with headquarters in Redwood City, California. The company currently has more than 5,200 employees and 43 office locations in 24 countries, with a strong footprint in the United States and Europe. As the numbers suggest, it is one of the biggest providers in the data management area with over 5,000 customers. The company’s main audience is in financial services, healthcare and public sector organizations. Informatica cooperates with more than 500 partners (e.g., technology partners) and provides educational services (e.g., Informatica University, training, certification, webinars, etc.).

The PowerCenter product helps companies access, explore and integrate data from different sources. It is available on-premises or can be hosted on Amazon Web Services (AWS) or Microsoft Azure. PowerCenter is an ETL tool designed to move data from the data source to the specific target and to build enterprise data warehouses. For this purpose, a graphical user interface is available to generate metadata and store it in a repository. After that, sessions and workflows are generated and physical connections to source and target systems are assigned.

PowerCenter has some overlapping functionality with Informatica’s Intelligent Data Management Cloud (IDMC) platform in areas such as data integration, data governance and data security. To understand this, we need to look at the history of the two products. PowerCenter is the old on-premises solution, which was initially supplemented by IDMC as a cloud solution and will probably be replaced by it in the future, as Informatica itself is promoting migration from PowerCenter to IDMC. This is leading to some confusion in the product range, as the reorganization has not yet been completed and there are currently redundancies in the products. This also poses a challenge to the many customers who still use PowerCenter. Many have adjusted their infrastructure and set up their processes accordingly and now do not want to simply tear down this functioning system and integrate something new.

Informatica PowerCenter is available in three different editions (standard, advanced and premium), which differ in terms of functionality and pricing. Informatica uses machine learning to monitor and manage PowerCenter deployments across domains and locations. The product can be used for data integration, data warehousing, data analytics, application migration and data governance.

User & Use Cases

78 percent of the companies surveyed use Informatica PowerCenter as a ‘data warehousing/BI’ solution and, as expected, 78 percent use it for ‘data integration’, including various styles of data integration patterns. All other use cases are not nearly so widely seen. Surprisingly, 11 percent said they use it for ‘data virtualization’. PowerCenter is an ETL tool and not suitable for data virtualization.
Informatica can be used in small to highly complex scenarios. The majority of customers use the tool either company-wide or in several divisions. Customers are typically larger companies (67 percent have more than 2,500 employees). This can certainly be attributed to the fact that Informatica for a long time tended to favor complex integration scenarios in large companies, before mid-market offerings were reintroduced a few years ago. With its usage-oriented cloud offering today, the picture could change again in the direction of better support for medium-sized companies.

Use cases

n=27

Extend of usage in the company

n=18

Total number of users per company

n=27

Total number of developers per company

n=18

Company size (number of employees)

n=27

Want to see the whole picture?

BARC’s Vendor Performance Summary contains an overview of The Data Management Survey results based on feedback from Informatica PowerCenter users, accompanied by expert analyst commentary.

Contact us to purchase the Vendor Performance Summary

Informatica PowerCenter

Peer Groups Data Pipelining Products, Products to Support DW Automation
VendorInformatica
Number of responses27
ProductInformatica PowerCenter
Offices43 offices in 24 countries
Employees5,200+
Customers5,000+
Websitewww.informatica.com