Table of Contents

Search

  1. Preface
  2. Part 1: PowerExchange CDC Introduction
  3. Part 2: PowerExchange CDC Components
  4. Part 3: PowerExchange CDC Data Sources
  5. Part 4: Change Data Extraction
  6. Part 5: Monitoring and Tuning
  7. Appendix A: DTL__CAPXTIMESTAMP Time Stamps

CDC Guide for Linux, UNIX, and Windows

CDC Guide for Linux, UNIX, and Windows

Preparing the SAP HANA Server for PowerExchange CDC

Preparing the SAP HANA Server for PowerExchange CDC

The configuration tasks for PowerExchange CDC depend on whether the SAP HANA source database resides on Linux or Windows:
  • If the SAP HANA database is on Windows, download the appropriate ODBC driver from https://tools.hana.ondemand.com/#hanatools. In the ODBC Data Source Administrator, configure the Data Set Name (DSN) with the host name or IP address and the port number.
  • If the SAP HANA database is on Linux, download the appropriate ODBC driver from https://tools.hana.ondemand.com/#hanatools. In the odbc.ini file, configure the DSN. For example:
    [ODBC Data Sources] HANADB1=HDBODBC [HANADB1] DRIVER=/dtl/qa/hana/hdbclient/libodbcHDB.so DriverUnicodeType=1 SERVERNODE=11.22.333.444:39015 DATABASENAME=HAN1 DBType=1 Location=local
  • Download and install the SAP HANA client and JDBC driver from https://developers.sap.com/tutorials/hana-clients-install.html.
For more information about using PowerExchange ODBC connections, see the
PowerExchange Reference Manual
.

0 COMMENTS

We’d like to hear from you!