Table of Contents


  1. Preface
  2. Introduction to PowerExchange
  3. DBMOVER Configuration File
  4. Netport Jobs
  5. PowerExchange Message Logs and Destination Overrides
  6. SMF Statistics Logging and Reporting
  7. PowerExchange Security
  8. Secure Sockets Layer Support
  9. PowerExchange Alternative Network Security
  10. PowerExchange Nonrelational SQL
  11. DTLDESCRIBE Metadata
  12. PowerExchange Globalization
  13. Using the PowerExchange ODBC Drivers
  14. PowerExchange Datatypes and Conversion Matrix
  15. Appendix A: DTL__CAPXTIMESTAMP Time Stamps
  16. Appendix B: PowerExchange Glossary

Configuring a Parameter File for SAP HANA CDC

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=
}] [
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
You can also include the following optional PowerExchange parameters, which can only be specified in this parameter file:
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.
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:
  • SSL
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" ;


We’d like to hear from you!