PowerCenter Options

Expanding the Scope of Enterprise Data Integration

PowerCenter Options extend the enterprise data integration platform’s core capabilities. Most options are available with version 8.5 of either PowerCenter Standard Edition or PowerCenter Advanced Edition.

Data Cleanse and Match Option provides powerful, integrated cleansing and matching capabilities. This option corrects and removes duplicate customer data to maximize the business value of all data assets.

Data Federation Option provides virtual data federation services or Enterprise Information Integration (EII) capabilities. Combining traditional physical and virtual data integration approaches in a single platform, this option creates a powerful tool for delivering holistic data quickly, easily, and cost-effectively.

Data Masking Option protects sensitive, private information by masking it in flight to produce de-identified but realistic-looking data, reducing the risk of data and compliance breaches. This option ensures randomization while preserving data’s referential integrity.

Data Profiling Option provides comprehensive, accurate information about the content, quality, and structure of data in virtually any operational system.

Enterprise Grid Option provides scalability within a grid computing environment. This option reduces the administrative overhead of supporting a grid. It also delivers optimal performance by automatically load balancing in response to runtime changes in data volumes or node utilization rates.

High Availability Option provides high availability and seamless failover and recovery of all PowerCenter components. This option minimizes service interruption in the event of a hardware and/or software outage and reduces costs associated with data downtime.

Mapping Generation Option automatically generates PowerCenter data integration mappings from best practice templates. It also reverse-engineers existing mappings into reusable template form. This option increases developer productivity, reduces time-to-results, and simplifies the data integration lifecycle.

Metadata Exchange Options coordinate technical and business metadata from data modeling tools, business intelligence tools, source and target database catalogs, and PowerCenter repositories. This family of options helps IT organizations leverage the time and effort already invested in defining data structures.

Partitioning Option executes optimal parallel sessions by dividing data processing into subsets which run in parallel and are spread among available CPUs in a multi-processor system. This option helps IT organizations maximize their technology investments by enabling hardware and software to jointly scale to handle large volumes of data and users.

Pushdown Optimization Option enables data transformation processing, where appropriate, to be “pushed down” into any relational database. This option saves hardware costs by making better use of existing database assets and helps organizations cost-effectively scale to meet increased data demand.

Real Time Option extends PowerCenter's capabilities to transform and process operational data in real time. This option helps IT organizations integrate real-time operational data with historical information stored in enterprise data warehouses, powering business processes and accelerating decision-making.

Team-Based Development Option extends PowerCenter SE’s capabilities to facilitate cross-functional collaboration by creating and managing multiple versions of a reusable development asset, controlling the development lifecycle, tracking changes, and migrating specific groups of assets from one repository to another.

Unstructured Data Option expands PowerCenter’s data access capabilities to include unstructured data formats. This option provides virtually unlimited access to all enterprise data formats, creating a powerful tool to help IT organizations achieve a holistic view of data, increase productivity, and ensure regulatory compliance.

Product Literature

PowerCenter Brochure