Table of Contents

Search

  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. PowerExchange Globalization
  12. Using the PowerExchange ODBC Drivers
  13. PowerExchange Datatypes and Conversion Matrix
  14. DTL__CAPXTIMESTAMP Time Stamps
  15. PowerExchange Glossary

Preface

Preface

The
PowerExchange Reference Manual
provides reference information related to configuring and using Informatica® PowerExchange®.
The manual includes information about configuring the DBMOVER configuration file, PowerExchange security, and the PowerExchange ODBC driver. The manual also contains information that you need to use PowerExchange in certain environments. For example, if you have nonrelational data sources, the manual describes the SQL that PowerExchange supports to access that data.
Use this manual in conjunction with the
PowerExchange Installation and Upgrade Guide
,
PowerExchange Bulk Data Movement Guide
, and PowerExchange CDC guides to gain a complete understanding of the product.
This manual pertains to the following operating systems and databases that PowerExchange supports:
  • DB2 for i5/OS and flat files on i5/OS
  • Linux, UNIX, and Windows data sources:
    • DB2 for Linux, UNIX, and Windows
    • Flat files on Linux, UNIX, and Windows
    • Microsoft SQL Server
    • MySQL
    • Oracle
  • z/OS data sources:
    • Adabas
    • CA Datacom
    • CA IDMS
    • DB2 for z/OS
    • IMS
    • VSAM and sequential data sets