Table of Contents

Search

  1. Preface
  2. PowerExchange Installation and Upgrade Overview
  3. Installation Planning
  4. Upgrade Planning
  5. Installing and Upgrading PowerExchange on IBM i
  6. Installing and Upgrading PowerExchange on Linux and UNIX
  7. Installing and Upgrading PowerExchange on Windows
  8. Installing and Upgrading PowerExchange on z/OS
  9. Appendix A: Upgrade Considerations
  10. Appendix B: PowerExchange Environment
  11. Appendix C: Manual Installation on IBM i

Installation and Upgrade Guide

Installation and Upgrade Guide

Supported PowerExchange Sources and Targets for Other Informatica Products

Supported PowerExchange Sources and Targets for Other Informatica Products

PowerExchange can provide data to the following Informatica products for processing:
Data Engineering Integration
This product can access the following types of PowerExchange bulk data sources and targets:
  • Adabas
  • Db2 for i (i5/OS)
  • Db2 for z/OS
  • Flat file
  • IMS
Data Quality
This product can access the following types of PowerExchange bulk data sources:
  • Adabas
  • Db2 for i
  • Db2 for z/OS
  • Flat file
  • IMS
  • VSAM
Enterprise Data Integration - PowerCenter
This product can access the following types of PowerExchange sources and targets for batch processing and CDC:
  • Adabas (batch sources and targets, CDC sources)
  • Datacom (batch and CDC sources only)
  • Db2 for i (batch sources and targets, CDC sources)
  • Db2 for z/OS (batch sources and targets, CDC sources)
  • Db2 LUW (batch sources and targets, CDC sources)
  • Flat file (batch sources only)
  • IDMS (batch and CDC sources only)
  • IMS (batch sources and targets, CDC sources)
  • Microsoft SQL Server (batch sources and targets, CDC sources)
  • MySQL (CDC sources only)
  • Oracle (batch sources and targets, CDC sources)
  • PostgreSQL (CDC sources only)
  • SAP HANA (CDC sources only)
  • VSAM (batch sources and targets, CDC sources)
PowerCenter can access both sources and targets for bulk data and only sources for CDC.
Data Integration Hub
This product can access the following types of PowerExchange sources and targets:
  • Adabas (batch sources and targets, CDC sources)
  • Datacom (batch and CDC sources only)
  • Db2 for i (batch sources and targets, CDC sources)
  • Db2 for z/OS (batch sources and targets, CDC sources)
  • Db2 LUW (batch sources and targets, CDC sources)
  • Flat file (batch sources only)
  • IDMS (batch and CDC sources only)
  • IMS (batch sources and targets, CDC sources)
  • Microsoft SQL Server (batch sources and targets, CDC sources)
  • Oracle (batch sources and targets, CDC sources)
  • VSAM (batch sources and targets, CDC sources)
Data Integration Hub can access both sources and targets for bulk data and only sources for CDC.
PowerExchange CDC Publisher
This product can access the following types of PowerExchange sources for CDC only:
  • Adabas
  • Datacom
  • Db2 for i
  • Db2 for z/OS
  • Db2 LUW
  • IDMS
  • IMS
  • Microsoft SQL Server
  • MySQL
  • Oracle
  • PostgreSQL
  • SAP HANA
  • Batch VSAM and CICS/VSAM
Informatica Intelligent Cloud Services - PowerExchange CDC Connectors
The Data Integration PowerExchange CDC connectors provide access to change data that PowerExchange captures from the following sources:
  • Db2 for i CDC
  • Db2 LUW CDC
  • Db2 for z/OS CDC
  • Microsoft SQL Server CDC
  • MySQL CDC
  • Oracle CDC
  • PostgreSQL CDC
  • SAP HANA CDC
  • VSAM CDC
Secure Archiving (formerly Data Archive)
This product can access the following types of PowerExchange bulk data sources:
  • Adabas
  • Datacom
  • Flat file
  • IDMS
  • IMS
  • VSAM
Secure Archiving uses PowerExchange ODBC to access sources.
Data Centric Security
This security solution can access the following types of PowerExchange bulk data sources and targets:
  • Adabas
  • Db2 for i
  • Db2 for z/OS
  • Flat file
  • IMS
  • VSAM
Secure Testing - Test Data Generator
This Secure Testing solution can access the following types of PowerExchange bulk data targets:
  • Db2 for i
  • Db2 for z/OS
Secure Testing - Test Data Management
This Secure Testing solution can access the following types of PowerExchange bulk data sources and targets:
  • Adabas
  • Db2 for i
  • Db2 for z/OS
  • Flat file
  • IMS
  • VSAM
Test Data Management accesses sources and targets through PowerCenter.
Secure Testing - Test Data Warehouse
This Secure Testing solution can access the following types of PowerExchange bulk data sources:
  • Db2 for i
  • Db2 for z/OS

0 COMMENTS

We’d like to hear from you!