Table of Contents


  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. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

ENCRYPT Statement

ENCRYPT Statement

The ENCRYPT statement controls whether PowerExchange uses encryption when moving data. In addition to an internal proprietary encryption method, PowerExchange supports AES encryption. The ENCRYPT statement provides an alternative to Secure Sockets Layer (SSL) authentication.
Informatica recommends that you use SSL authentication instead of the ENCRYPT statement. SSL authentication provides stricter security and is used by other Informatica products.
  • AES
    . PowerExchange encrypts data by using the Advanced Encryption Standard (AES) algorithm. You must specify the encryption level by coding the ENCRYPTLEVEL statement.
  • N
    . PowerExchange does not encrypt data.
  • Y
    . PowerExchange uses its internal proprietary encryption method to encyrpt data.
Default is N.
  • To avoid confusion, specify the same value in the ENCRYPTstatement in the DBMOVER configuration files on the client and PowerExchange Listener machines. Also, specify the same value in the ENCRYPTLEVEL statement in the DBMOVER configuration file on both machines. However, PowerExchange always uses the ENCRYPT and ENCRYPTLEVEL values in the DBMOVER configuration file on the client machine that initiates the connection to the PowerExchange Listener.
  • The ENCRYPT and ENCRYPTLEVEL statements control encryption of data that PowerExchange moves between the PowerExchange Listener and a client such as the PowerExchange Navigator or a PowerExchange utility. These statements also control encryption of data that PowerExchange moves between the PowerExchange Listener and the Integration Service for connections that have the default
    Encryption Type
    setting of
    . For connections with an
    Encryption Type
    setting of
    , the
    Encryption Type
    Encryption Level
    connection attributes override the settings in the DBMOVER configuration file.


We’d like to hear from you!