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_CONNECTION - ORAD Statement

CAPI_CONNECTION - ORAD Statement

The ORAD CAPI_CONNECTION statement specifies a named set of parameters that the Consumer API (CAPI) uses to connect to the change stream and control PowerExchange Express CDC for Oracle processing for Oracle data sources.
Linux, UNIX, and Windows
Oracle
ORACLEID, ORACLE_CAPTURE_TYPE
Yes, for PowerExchange Express CDC for Oracle
CAPI_CONNECTION=([DLLTRACE=
trace_id
]  ,NAME=
capi_connection_name
 ,TYPE=(ORAD     [,EPWD=
database_encrypted_password
]      ,ORACOLL=
collection_id
    [,PARMFILE=
express_cdc_configuration_file
]     [,PASSWORD=
database_password
]     [,USERID=
database_user_id
]      ) )
DLLTRACE=
trace_id
Optional. User-defined name of the TRACE statement that activates internal DLL tracing for this CAPI.
Specify this parameter only at the direction of Informatica Global Customer Support.
NAME=
capi_connection_name
Required. Unique user-defined name for this CAPI_CONNECTION statement.
Maximum length is eight alphanumeric characters.
TYPE=(ORAD, ... )
Required. Type of CAPI_CONNECTION statement. For PowerExchange Express CDC for Oracle sources, this value must be ORAD.
EPWD=
database_encrypted_password
Optional. An encrypted password that PowerExchange uses to connect to the Oracle source database for PowerExchange Express CDC for Oracle. If you specify the USERID parameter in this statement, you must also specify either the EPWD or PASSWORD parameter.
This encrypted password overrides the EPWD parameter value in the DATABASE statement of the PowerExchange Express CDC for Oracle configuration file and the
Password
value in the CDC session connection attributes. To use one of these other encrypted passwords, do not include the EPWD parameter in the ORAD CAPI_CONNECTION statement.
ORACOLL=
collection_id
Required. The collection identifier for the Oracle instance. This value must match the collection ID in the first positional parameter of an ORACLEID statement in the same dbmover.cfg file.
Usually, this value also matches the collection ID that you specify in the registration group for the Oracle instance. If you specify a different collection ID in the registration group, the registration collection ID overrides this ORACOLL value.
PARMFILE=
path_and_filename
Optional. The path and file name for the PowerExchange Express CDC for Oracle configuration file, relative to the current working directory. You can use this parameter to override the default path and file name or to remind PowerExchange users of the default path and file name.
If this parameter is not specified, PowerExchange uses
pwx_home_directory
\pwxorad.cfg by default. The default path is the path in the PWX_HOME environment variable, or if this environment variable is not defined, the default path is the path to the PowerExchange bin directory. If the pwxorad.cfg file does not exist at the default location and a PARMFILE override is not defined, PowerExchange issues error messages PWX-09951 and PWX-00268 and change capture fails.
PASSWORD=
database_password
Optional. A clear text password that PowerExchange uses to connect to the Oracle source database for PowerExchange Express CDC for Oracle. If you specify the USERID parameter in this statement, you must specify either the EPWD or PASSWORD parameter.
This clear-text password overrides the PASSWORD parameter in the DATABASE statement of the PowerExchange Express CDC for Oracle configuration file and the
Password
value in the CDC session connection attributes. To use one of these other passwords, do not include the PASSWORD parameter in the ORAD CAPI_CONNECTION statement.
USERID=
database_user_id
Optional. A user ID that PowerExchange uses to connect to the Oracle source database for PowerExchange Express CDC for Oracle. If you specify the USERID parameter in this statement, you must also specify either the EPWD or PASSWORD parameter.
This user ID overrides the USERID parameter in the DATABASE statement of the PowerExchange Express CDC for Oracle configuration file and the
User Name
value in the CDC session connection attributes. To use one of these other user IDs, do not include the USERID parameter in the ORAD CAPI_CONNECTION statement.
  • You can specify multiple ORAD CAPI_CONNECTION statements in the dbmover.cfg file to capture change data from more than one Oracle instance or to use different parameter settings for the same Oracle instance.
  • Define the ORAD CAPI_CONNECTION and ORACLEID statements on the PowerExchange system that must connect to the Oracle source database for change data capture. Usually, the PowerExchange Logger for Linux, UNIX, and Windows runs on this system.
  • You cannot define both ORAD CAPI_CONNECTION and ORCL CAPI_CONNECTION statements in the same dbmover.cfg file. If you use PowerExchange Express CDC for Oracle, define ORAD CAPI_CONNECTION statements. If you use PowerExchange Oracle CDC with LogMiner, define ORCL CAPI_CONNECTION statements. If you need to run both PowerExchange Express CDC for Oracle and PowerExchange Oracle CDC with LogMiner sessions against the same Oracle instance, use separate dbmover.cfg files, PowerExchange Listeners, and PowerExchange Loggers.
  • The database user ID and password or encrypted password can be specified in multiple locations. If you do so, PowerExchange uses the following order of precedence:
    1. The USERID value and the EPWD or PASSWORD value that are specified in the ORAD CAPI_CONNECTION statement in the dbmover configuration file
    2. The USERID value and EPWD or PASSWORD value that are specified in the DATABASE statement in the PowerExchange Express CDC for Oracle configuration file, pwxorad.cfg.
    3. The
      User Name
      and
      Password
      values that are specified in the Oracle application connection attributes for the PowerCener CDC session