Reference Manual

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"
;

Rename Saved Search

Table of Contents

Reference Manual

Reference Manual

Configuring a Parameter File for SAP HANA CDC

Configuring a Parameter File for SAP HANA CDC