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 - HANA Statement

CAPI_CONNECTION - HANA Statement

The HANA CAPI_CONNECTION statement specifies a named set of parameters that the Consumer API (CAPI) uses to connect to the change stream and control CDC processing for SAP HANA sources.
Windows and Linux
SAP HANA
Yes for SAP HANA CDC
CAPI_CONNECTION=(NAME=capi_connection_name [,DLLTRACE=
trace_id
] ,TYPE=(HANA ,SERVER=[server_name|ip_address]:port ,DATABASE=database_name [,BUFFERSIZE=bytes] [,FETCHSIZE=records] [,LOGCLEAR=days] [,ONDATATRUNC=[WARN|FAIL]] [,SSL=[Y|N]] [,TIMEOUT=milliseconds] [,TRANSACTIONSIZE=records] [,VMOPTS=options] [,VMOPTSDEL=delimiter_character]) )
NAME=
capi_connection_name
Required. A unique user-defined name for this CAPI_CONNECTION statement.
Maximum length is eight alphanumeric characters.
DLLTRACE=
trace_ID
Optional. The 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.
TYPE=(HANA, ... )
Required. The type of CAPI_CONNECTION statement. For SAP HANA sources, this value must be HANA.
SERVER=[
server_name
|
ip_address
]:
port
Required. The server name or IP address of the database server that contains the source tables.
The default port is 39015. If you use a different port number, you must specify the port in the SERVER parameter.
DATABASE=
database_name
Required. The name of the SAP HANA database that contains the source tables for change data capture.
BUFFERSIZE =
bytes
Optional. The maximum size of the buffer for CDC records retrieved from the SAP HANA source. When the maximum buffer size is reached, PowerExchange flushes the buffer and commits changes to the log tables. Valid values are 64000 (64 KB) to 4000000 (4 MB).
Default is 64000.
FETCHSIZE=
records
Optional. The maximum number of records that can be returned from the SAP HANA source to the buffer at a time. Valid values are 100 to 10000.
Default is 1000.
LOGCLEAR=
days
Optional. The time interval in days after which PowerExchange purges the PKLOG table entries. Valid values are 0 to 366. A value of 0 means that the PKLOG table entries are not purged.
Default is 14.
ONDATATRUNC=[WARN|
FAIL
]
Optional. Indicates whether PowerExchange issues a warning message and continues processing or ends abnormally when it encounters a column where data would be truncated. Valid values are WARN or FAIL.
Default is FAIL.
SSL=[Y|
N
]
Optional. Whether the connection to the SAP HANA source uses the SSL/TLS protocol. This parameter only affects connections that use the JDBC driver. Connections that use an ODBC driver must specify the secure connection in the odbc.ini file.
Default is N.
TIMEOUT=
milliseconds
Optional. The time interval in milliseconds after which the change cycle ends if PowerExchange does not receive a response from the source table. Valid values are 1000 to 60000.
Default is 10000.
TRANSACTIONSIZE=
records
Optional. The number of records to process in a single transaction of the read cycle. Informatica doesn't recommend setting low values for production workloads but a lower value might be useful when testing. Valid values are 1 through 1000000.
If you adjust TRANSACTIONSIZE for a PowerExchange Navigator row test that contains UPDATE records, set the parameter value to 2 or greater. Otherwise, the test will only return rows up to the first UPDATE record.
Default is 500000.
VMOPTS=
option
;
option
;...
Optional. A set of one or more Java Virtual Machine (JVM) options, separated by semicolons. You can specify up to 20 options.
Default is a placeholder semicolon (;).
VMOPTSDEL=
character
Optional. Changes the separator character for the VMOPTS parameter. Valid values are any separator character on the system where the options will be overridden.
Default is a semicolon (;).