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. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  15. Appendix B: PowerExchange Glossary

CAPI_CONN_NAME Statement

CAPI_CONN_NAME Statement

The CAPI_CONN_NAME statement specifies the name of the CAPI_CONNECTION statement that PowerExchange uses by default for all data source types when you do not supply a CAPI connection override.
All
CAPI_CONNECTION and CAPI_SRC_DFLT
No
CAPI_CONN_NAME=
capi_connection_name
For the
capi_connection_name
variable, enter the name of the CAPI_CONNECTION statement that PowerExchange uses when you do not specify a CAPI_CONNECTION override value.
  • Optionally, you can use the CAPI_SRC_DFLT statement to provide a source-specific default connection. A source-specific default is useful if the DBMOVER configuration file contains many CAPI_CONNECTION statements.
  • Informatica recommends that you always specify an override CAPI_CONNECTION statement for a PowerExchange operation, instead of relying on default connection definitions. You can define the following overrides, based on the type of PowerExchange operation:
    • For CDC sessions, specify the
      CAPI Connection Name Override
      attribute on the PWX CDC application connection.
    • For PowerExchange Condense, specify the CONN_OVR statement in CAPTPARM configuration file.
    • For the PowerExchange Logger for Linux, UNIX, and Windows, specify the CONN_OVR statement in pwxccl.cfg configuration file.
    • For the generation of restart tokens with the DTLUAPPL utility, specify the CONN_OVR statement in the DTLUAPPL control statement.
    • For CAPXRT database row tests in the PowerExchange Navigator, specify the
      CAPI Connection Name
      value in the
      Advance
      dialog box.
    • For the generation of restart tokens during a database row test in the PowerExchange Navigator, specify the CONNAME parameter.
    • For PowerExchange ODBC connections, specify the DTLCONN_OVR parameter in the odbc.ini file or the DTLCONNOVR SQL escape sequence override.