Table of Contents

Search

  1. Preface
  2. Summary of PowerExchange New Features and Changes
  3. PowerExchange Installation and Upgrade
  4. PowerExchange Agent
  5. PowerExchange Client for PowerCenter
  6. PowerExchange Condense
  7. PowerExchange Listener
  8. PowerExchange Logger for Linux, UNIX, and Windows
  9. PowerExchange Navigator
  10. PowerExchange Monitoring and Tuning
  11. PowerExchange Utilities
  12. PowerExchange for Adabas
  13. PowerExchange for CA Datacom
  14. PowerExchange for DB2 for i
  15. PowerExchange for DB2 for Linux, UNIX, and Windows
  16. PowerExchange for DB2 for z/OS
  17. PowerExchange for CA IDMS
  18. PowerExchange for IMS
  19. PowerExchange for Microsoft SQL Server
  20. PowerExchange for MySQL
  21. PowerExchange for Oracle
  22. PowerExchange for PostgreSQL
  23. PowerExchange for VSAM and Flat Files
  24. PowerExchange ODBC

SQL Server CDC with a PowerExchange Listener on Linux

SQL Server CDC with a PowerExchange Listener on Linux

In a PowerExchange CDC environment with Microsoft SQL Server sources, you can now run the PowerExchange Listener on a Linux system. The PowerExchange Listener uses the DataDirect ODBC driver that PowerExchange supplies to connect to the SQL Server system.
If you run the PowerExchange Listener on a Linux system, configure the following DBMOVER statements:
  • In the DBMOVER configuration file on the Linux system where the PowerExchange Listener runs, define a MSQL CAPI CONNECTION statement that provides connection information for the SQL Server source distribution database.
  • In the DBMOVER configuration files on the PowerCenter Integration Service machine and the PowerExchange Navigator system, define a NODE statement that points to the PowerExchange Listener system.
Alternatively, you can still run the PowerExchange Listener on a Windows system. You cannot run the PowerExchange Listener on a UNIX system.
For more information, see the "Microsoft SQL Server CDC" chapter in the
PowerExchange CDC Guide for Linux, UNIX, and Windows
.

0 COMMENTS

We’d like to hear from you!