PowerCenter

A market-leading, scalable, and high-performance enterprise data integration platform that promotes automation, reuse, and agility.

Key Features

PowerCenter forms the foundation for all your data integration initiatives, including analytics and data warehousing, application migration, or consolidation and data governance.

Business and IT Collaboration

Business and IT collaborate via role-based tools and agile processes, enabling business self service and delivering timely and trusted data to your business.

Rapid Prototyping, Profiling, and Validation

Analysts collaborate with IT in rapidly prototyping and validating results quickly and iteratively.

Reusability, Automation, and Ease of Use

Users benefit from graphical and code-less tools that are easy to use, which provide automation and reusability, and which leverage a whole palette of pre-built transformations.

Universal Connectivity

Users seamlessly access and integrate data from all types of sources, using high-performance, out-of-the-box connectors.

Metadata Management

Graphical, intuitive, metadata-driven views of data flows, impact analysis, and lineage provide better governance, auditability, and change management.

Business Glossary

PowerCenter offers a business-friendly user experience for authoring and managing business terms, for enhanced collaboration between business and IT

Scalability, Performance, and Zero Downtime

Support for grid computing, distributed processing, high availability, adaptive load balancing, dynamic partitioning, and pushdown optimization.

Automated Data Validation Testing

Validation testing of data that has been moved or transformed, using a script-free automated, auditable, and repeatable process across development, test, and production.

Proactive Monitoring—Operations and Governance

An “Early-warning system” proactively monitors, alerts, handles production issues, and enforces coding best practices to prevent costly damage control later on.

2014 Gartner Magic Quadrant for Data Integration Tools

Download the report

Bloor Research Comparative Costs and Uses for Data Integration Platforms

Download the report

Add-On Packages

Real Time Integration

Exchange data among operational applications in real time, near real-time, or batch.

Data Virtualization

Create a common, trusted data-access layer across diverse data sources without physically moving the data.

Advanced Data Transformation

Transform any source data type regardless of format, complexity, or size to fit the target system.

PowerCenter Editions

  PowerCenter Standard Edition PowerCenter Advanced Edition PowerCenter Premium Edition
High Performance ETL/Batch Data Integration
Role-based Tools for Business/IT Collaboration

Centralized Administration and Management

Rapid Prototyping for Agile Data Integration

Basic Profiling and Validation by Business

Metadata Manager

 

Business Glossary

 

Enterprise Grid  
High Availability  
Partitioning  
Pushdown Optimization  
Proactive Monitoring: Operations, Governance

 

 

Data Validation: Testing, Production    

Related Products & Solutions

Connectors (PowerExchange)

Provides out-of-the-box, high-performance connectivity to all enterprise data, eliminating the risk and cost of hand coding.

Data Quality

Provides all your projects and initiatives with clean, high-quality data regardless of its size, data format, platform, or technology.

Big Data Edition

Provides a safe, efficient way to integrate all types of data on Hadoop without ever having to learn Hadoop.

Data Integration Hub

Delivers an innovative, publish-and-subscribe hub approach for elegant, alternative point-to-point integrations.

PowerCenter Express

Entry-level data integration and profiling for your department or small to mid-market business.

Customer Success Stories

M.D. Anderson Cancer Center

Informatica empowered scientific and clinical collaboration at this renowned cancer center by turning data into knowledge and facilitating self-service business intelligence

Lexis Nexis

Informatica gives Lexis-Nexis the power to shape the world with information and technology.

Fannie Mae

Informatica helped Fannie Mae ensure clean and correct data is collected and integrated from 100+ data sources