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]
			  [,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 on 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.

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 (;).