PowerExchange for Databases and Data Warehouses

Real-time access to enterprise data

PowerExchange provides fast, unified access to all major enterprise database systems and data warehousing environments. A simple interface allows databases to be accessed and brought into PowerCenter for sophisticated transformation or for cleansing by Informatica Data Quality. When processing is complete, PowerExchange can apply any desired updates to the data store of choice, whether operational, such as DB2 or Oracle, or to stand alone data warehouses or data marts.

Key Features

Change Data Capture (CDC) provides real-time updates from operational data stores

• Distills changes from background data
• Captures changes once and routes them to multiple applications
• Optionally condenses multiple updates and presents only the latest version of each
• Supports push and pull models for user-selectable latency

Streamlined access to mainframe, midrange, and open systems data

• Provides a uniform interface for accessing all supported sources and targets
• Requires no specialized programming skills to access mainframe-based data, including pre-relational databases and file systems

Optimized for each specific data store

• Honors the security model of supported data stores
• Uses native interfaces and high-speed data loading APIs
• Automatically leverages the data store's metadata to speed development

Benefits

Improve data capture timeliness
Reducing the latency of data capture allows an organization to provide better customer service, lower costs, and improve internal operations. By augmenting PowerExchange's batch extraction capabilities with the timely data access afforded by CDC, data can be delivered in real-time or on any chosen schedule for downstream data quality processes, data warehouse construction, or any other data integration needs.

Reduce Development Costs
Developing database access code is time-consuming, error-prone, and ultimately costly. Even a simple SQL script typically takes more time to develop, debug, and implement than it does to make a few selections in PowerExchange. More complex access-especially to the pre-relational systems commonly used on mainframes-requires much more time to build, and the necessary development skills are becoming scarcer and more costly every day. Some access mechanisms, such as using complex vendor APIs or building home-grown CDC technology, are typically cost-prohibitive to build locally, preventing many organizations from taking advantage of the operational improvements that more timely data capture can provide.

Reduce machine resource requirements
As data volumes increase and processing windows shrink, it is an advantage, and sometimes a necessity to process only the changes. This reduces hardware resource requirements, helping to contain costs and even defer the point where hardware upgrades are needed. When administrative and other costs are included, the savings incurred with change data capture can be considerable.

Supported Databases and Interfaces

Operational Data Stores	Source	Target	CDC
Adabas			*
Binary Flat Files
C-ISAM
Datacom
DB2 for i5/OS
DB2 for Linux, UNIX and Windows
DB2 for z/OS
Essbase
IDMS			*
IMS DB
Informix Dynamic Server
ODBC
Oracle
SQL Server
Sybase
VSAM

Data Warehouse Environments	Source	Target	Interfaces Supported
Netezza Performance Server			Bulk Loading Interface, ODBC
Teradata			TPT, ODBC

"Informatica's data integration solutions have enabled us to better manage our business each day and to enhance its overall performance. The visibility we now have, thanks to daily sales reports that are produced by consolidating immense volumes of data, gives our business the ability to function more effectively and be more profitable." - Brian Ganly, Data Warehouse Architect The Carphone Warehouse read the full story

Productliteratuur