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