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]]
     [,PARMFILE=
path\
filename.cfg]
     [,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 this 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 bytes (64 KB) to 4000000 bytes (4 MB).

Default is 64000 bytes.

FETCHSIZE=

records

Optional. The maximum number of records that can be fetched from the SAP HANA source and written to the buffer at a time. Valid values are 100 to 10000.

Default is 1000.

LOGCLEAR=

days

Optional. The number of 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 will be truncated. Valid values are WARN or FAIL.

Default is FAIL.

PARMFILE=

path_and_filename

Optional. The path and file name for the PowerExchange CDC for SAP HANA configuration file, relative to the current working directory. You can use this parameter to override the default path and file name or to explicitly specify a user-defined file name. The SAP HANA configuration file must reside in the PowerExchange bin directory. If the specified file does not exist in the bin directory, change capture fails.

The default value is

pwx_bin_directory

\.pwxhana.cfg.

The configuration file contains the MAXREADSIZE=

records

and PROGRESS=Y parameters, which control the number of records in each read cycle and whether the cycle progress is detailed in the log file. You can also use the configuration file to override several parameters specified in the HANA CAPI_CONNECTION statement, such as BUFFERSIZE or FETCHSIZE. For more information, see GUID-06F37E45-D769-42F7-B2EF-147506F8A99B.

SSL=[Y|

N

]

Optional. Controls 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. One or more Java Virtual Machine (JVM) options, separated by a semicolon (;) or by an override character specified in the VMOPTSDEL parameter. You can specify up to 20 options.

VMOPTSDEL=

separator_character

Optional. Specifies a delimiter character that separates the JVM options specified in the VMOPTS parameter. You can use any separator character that is valid on the system where the options will be overridden.

Default is the semicolon (;).