Informatica PowerCenter

Informatica was founded in 1993, went public in 1999 and was acquired in 2015 by Permira and Canada Pension Plan Investment Board (with both Microsoft and Salesforce as strategic investors). Informatica is one of the few companies totally focused on Data Management, providing a broad and integrated set of facilities for all aspects of Data Management, especially focusing on data integration and exchange, data quality, master data management, data governance, data security

Today Cloud, AI and Data Governance is driving mainly the development of the portfolio and we see a lot products evolving in this area. Informatica’s vision is to provide a single platform to integrate and provide all data across the hybrid enterprise. For that Informatica is working on the Informatica Intelligent Data Platform as a microservice-oriented framework that should bring together all the modules and tools on one integrative foundation. The foundation provide central modules for connectivity, data engines, tools for managing and monitoring. CLAIRE extends the framework with supportive AI functionality. Next to the technical integration the Informatica Data Catalog (Enterprise Data Catalog, AXON) is designed to collect additional information and semantics about enterprise data and make those accessible. Nevertheless, Informatica PowerCenter is and remains the integrative core component for most Informatica product bundles as well as the strategic data integration tool.

Informatica PowerCenter is one of the best-known data integration tools and supports developers worldwide in their data management tasks. PowerCenter takes various data from almost anywhere in the enterprise and integrates it, cleans it and inspects it with regard to business rules before delivering it to wherever it is needed (e.g. a data warehouse or a data lake).

Informatica PowerCenter is a client-server-based data integration platform. The tool supports developers in the development of data pipelines primarily for BI and analytics. Additional modules extend Informatica PowerCenter, such as data profiling or data cleansing, or complement the tool, such as data preparation, master data management, or a data catalog. The web-based UI offers extensive support for development (e.g. debugging, preview, sampling, profiling, …) and offers functions for the graphical design of logical data processing processes as well as workflows. The logic is stored and managed in the form of metadata (e.g. versioned) and is used as an instruction for the specialized engine, which can execute the data manipulation processes simply or in parallel.

Operation is monitored by supplied administration and monitoring functions. The abstraction of process logic in metadata also allows the engine to be changed. For example, logic that has been created can theoretically also run on Hadoop clusters (depending on the functions used and environment specifics, and optimize in special Hadoop edition of Informatica PowerCenter).

PowerCenter can be run on-premise, in the cloud on AWS or Azure. We also see that PowerCenter functions are migrated to cloud services, such as Informatica Cloud Data Integration.

User & Use Cases

Informatica PowerCenter is a data integration tool that, in the eyes of participants, is foremost used to manage data mart and data warehouses. 71 percent of respondents use it to manage data quality and 43 percent to manage an enterprise DWH. This may be due to the availability of industry-specific solutions based on marts based on Informatica technology. 43 percent of users consider functions for data cleansing and 36% master data management to be tasks of integration. Data quality, sometimes even consistent master data, have been major challenges in the DW environment for years. Less frequently, 7 percent of those surveyed use Informatica PowerCenter for additional tasks besides classic data warehousing. These include data virtualization, real-time processing, data cataloging and sandboxing.

Informatica PowerCenter is an expert tool that primarily supports technical developers to design and operate data handling processes. This requires a high level of expertise that typically few employees in the company have.

Current use

N=28

Percentage of employees using Informatica PowerCenter

N=28

Number of users using Informatica PowerCenter

N=28

Company size (number of employees)

N=32

Informatica PowerCenter

Peer Groups Data warehousing automation products, ETL products, Global vendors (data management)
VendorInformatica
Number of responses32
ProductPowerCenter
OfficesOffices in 82 countries
Employees4,200+
Customers9,000+
Revenues (2018)€ 1 billion
Websitewww.informatica.com