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_filename

Optional. The full path and file name of a parameter file that you create to specify optional JDBC connection properties and some optional PowerExchange parameters.

You can include JDBC connection properties, such as compress and encrypt, that are used for connections to the SAP HANA database. For more information about these properties, see https://help.sap.com/viewer/0eec0d68141541d1b07893a39944924e/2.0.04/en-US/109397c2206a4ab2a5386d494f4cf75e.html.

You can also include the following PowerExchange parameters:

MAXREADSIZE=
records
, which controls the number of records in each read cycle
PROGRESS=Y, which controls whether the cycle progress is detailed in the log file

The MAXREADSIZE and PROGRESS parameters can only be specified in this parameter file.

Additionally, you can include overrides for several parameters specified in the HANA CAPI_CONNECTION statement, such as BUFFERSIZE or FETCHSIZE.

In PowerExchange 10.5.3 and earlier, you must enter only the parameter file name and place the file in the PowerExchange bin directory. If the specified file does not exist in the bin directory, change capture fails. In PowerExchange 10.5.4, the parameter file can reside outside of the bin directory. You must specify the full path and file name in this parameter, even if the file resides in the bin directory.

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