CDC Guide for Linux, UNIX, and Windows

10.5.5
- 10.5.8
- 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 JDBC on Windows or Linux

PowerExchange SAP HANA CDC requires JDBC access in addition to ODBC access.

PowerExchange installs the following .jar files for the SAP HANA CDC:

log4j-api-2.17.1.jar

log4j-core-2.17.1.jar

PWXHANACDC.jar

commons-codec-1.15.jar (PowerExchange 10.5.4 and later)

SAP HANA CDC also requires access to the JDBC client ngdbc.jar file. To provide access to this .jar file, complete the following steps:

Copy the ngdbc.jar file to the jars subdirectory in the PowerExchange installation. By default, the installation directory also includes the .jar files installed with PowerExchange.

By default, PowerExchange expects the ngdbc.jar file in the jars directory. If the file is named differently or placed in a different directory, either rename the file to ngdbc.jar or move the file to the jars directory. Add a HANA_CLASSPATH statement in the dbmover.cfg file to point to all of the required .jar files. Use the separator appropriate for the environment between each file name. The following example shows the HANA_CLASSPATH statement on Windows:

HANA_CLASSPATH="<install_directory>\jars\PWXHanaCDC.jar;<install_directory>\jars\log4j-api-2.17.1.jar;<install_directory>\jars\log4j-core-2.17.1.jar;<install_directory>\jars\ngdbc.jar"

The following example shows the HANA_CLASSPATH statement on Linux:

HANA_CLASSPATH="<install_directory>/jars/PWXHanaCDC.jar:<install_directory>/jars/log4j-api-2.17.1.jar:<install_directory>/log4j-core-2.17.1.jar:<install_directory>/jars/ngdbc.jar"

PowerExchange looks first for dependent jar files in the HANA_CLASSPATH statement. If the HANA_CLASSPATH statement is not present, PowerExchange uses the path defined in the PWX_HOME environment variable. If you do not include the HANA_CLASSPATH statement or the PWX_HOME variable, PowerExchange uses a path relative to the location where you initiate the CDC process.

Rename Saved Search

Table of Contents

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Configuring JDBC on Windows or Linux

Configuring JDBC on Windows or Linux