CDC Guide for Linux, UNIX, and Windows

10.5.5
- 10.5.6
- 10.5.4
- 10.5.3
- 10.5.2
- 10.5.1
- 10.5
- 10.4.1
- 10.4.0 HotFix 1
- 10.4.0

Back Next

Configuring a Parameter File for SAP HANA CDC

You can create a parameter file that contains optional JDBC connection properties and certain optional PowerExchange parameters. Specify the path and file name for this parameter file in the PARMFILE parameter of the HANA CAPI_CONNECTION statement in the dbmover.cfg file.

The parameter file has the following format:

[JDBCPROPS=property1=value&property2=value&...]
[MAXREADSIZE=records]
[PROGRESS={Y| N}]
[pwx_parameter_overrides]

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 optional PowerExchange parameters, which can only be specified in this parameter file:

MAXREADSIZE=records: The number of SAP HANA records to process in a read cycle. You can use this parameter to reduce the size of a UOW and to improve the throughput of large source tables.
PROGRESS={Y| N }: Controls whether the cycle progress is detailed in the log file. To show the cycle progress, specify Y.
Default is N.

Additionally, you can specify override settings for the following HANA CAPI_CONNECTION parameters:

FETCHSIZE

LOGCLEAR

LOGLEVEL

ONDATATRUNC

SSL

TIMEOUT

TRANSACTIONSIZE

If you use the parameter file to override existing parameter settings in the HANA CAPI_CONNECTION statement, the log file shows both the override and original parameter values.

Example parameter file:

Enter the PowerExchange parameters and JDBC properties under the OPTIONS statement. Also include an empty DATABASE statement. Each statement must end with a semicolon (;). For example:

DATABASE
;
OPTIONS
/*  MAXREADSIZE=55
  PROGRESS=Y
  JDBCPROPS="autocommit=false&emptyTimestampIsNull=true&connectTimeout=6000&traceFile=traceFile.txt&traceOptions=CONNECTIONS"
;

Configuring the dbmover Configuration File

Download Guide

Watch

Comments

Communities

Knowledge Base

Success Portal