 |
Home | Solutions | Informatica PowerExchnage
Informatica PowerExchange
Unlock Complex Data. On Demand.
Informatica PowerExchange, based on a services-oriented architecture (SOA), provides on-demand access to data in all critical enterprise data systems, including mainframe, midrange, and file-based systems. Available as a standalone service or tightly integrated with Informatica PowerCenter, PowerExchange helps organizations leverage mission-critical operational data by making it available to people and processes without requiring manual coding of data extraction programs. Its SQL access to native database APIs provides high-performance extraction, conversion, and filtering of data without intermediary staging and programming. Shared services offer data delivery options that enable IT organizations to flexibly and efficiently manage processing demands.
Organizations today demand immediate access to accurate information for quick decision making and high-speed operations. At the same time, the volume and variety of data is exploding, stretching the capacity of IT resources and infrastructures. To leverage the full value of their information, organizations must be able to integrate data from a wide variety of transactional applications and systems for easy access and "right time" delivery.
PowerExchange provides on-demand access to immediate, accurate, and understandable data. With Informatica PowerExchange you can:
- Access and deliver data in "right time"
- Extend existing IT investments
- Unlock complex systems without coding
Access data on demand
PowerExchange offers several options for capturing data and making it available to a range of targets. It can capture data from relational and non-relational data sources either as whole data sets or as incremental changed data, in real-time or in a scheduled batch process. PowerExchange enables organizations to schedule data delivery to multiple targets weekly, daily, hourly—even at the sub-second. Informatica PowerExchange provides a single architecture that allows a seamless transition from batch and bulk, to batch and changed data capture, to real-time changed data capture delivery. PowerExchange also eliminates the need for multiple-step processes with extraction, file transfer, and load scripts for batch data processing.
Extend existing IT investments
Based on an extensible, service-oriented architecture, PowerExchange supports a variety of platforms. As a business decides to make more of its data sources available to other applications across the enterprise, it can add platforms easily. SQL access to native database APIs delivers high performance: PowerExchange extracts, converts, filters, and makes data available to target systems without intermediary staging and program coding.
Unlock complex systems without coding
Unlocking the value of legacy systems once meant costly new system development and data migration, or complex hand coding to access critical data. Informatica PowerExchange significantly reduces the time and resources required to leverage existing investments, streamlining access to legacy systems and delivering data to a range of business applications. It masks the complexity of source systems from developers and offers an intuitive GUI with SQL-like access, eliminating the need for lengthy training and implementation.
PowerExchange Architecture
Fig 1. Informatica PowerExchange Product Architecture
Click to view full-screen
PowerCenter is available in two editions:
- PowerCenter Standard Edition —The industry's leading software for accessing, integrating, and delivering data, PowerCenter Standard Edition cost-effectively leverages data from any system, to any system. PowerCenter Standard Edition allows installation in under thirty minutes.
- PowerCenter Advanced Edition — In addition to all the features of PowerCenter Standard Edition, PowerCenter Advanced Edition provides broad enterprise data integration with a single platform, robust metadata analysis and data-ready reporting , cost-effective grid computing and team-based development capabilities. With PowerCenter Advanced Edition, organizations can realize the benefits of a unified platform that addresses the full data integration lifecycle-helping to drive productivity, lower maintenance costs, and gain a substantial cost advantage with a rapid out-of-the-box experience. PowerCenter Advanced Edition allows installation all from one CD, all in under an hour.
Supported Platforms
Informatica PowerExchange supports the following platforms for batch, change and real-time options.
PowerExchange Supported Platforms
| ADABAS |
 |
* |
| Datacom |
|
|
| DB2 |
|
|
| Flat Files |
|
|
| IDMS |
|
|
| IMS |
|
|
| IBM & BMC IMS & DB2 Backup Extract |
|
|
| MQSeries |
|
|
| VSAM |
|
|
| AS/400 DB2 |
|
|
| Flat Files |
|
|
| MQ Series |
|
|
| ADABAS |
|
* |
| C-ISAM |
|
|
| DB2 UDB |
|
|
| Flat Files |
|
|
| Informix |
|
|
| MQ Series |
|
|
| Oracle |
|
|
| SQL Server |
|
|
| Sybase |
|
|
* change only
|
|
