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

SQL Server CDC Prerequisites

SQL Server CDC Prerequisites

PowerExchange has the following prerequisites for SQL Server CDC:
  • PowerExchange requires an edition of Microsoft SQL Server 2008 or later that supports transactional replication. You must configure and enable transactional replication on the source system to do CDC.
  • The Microsoft SQL Server Agent and Log Reader Agent must be running on the Windows machine from which change data is extracted. Usually, the SQL Server Agent remains running after it is initially started. For more information, see your SQL Server documentation.
  • Each source table registered for change capture in the publication database must have a primary key.
  • The PowerExchange Listener can run on a Windows system or Linux system. However, the PowerExchange Listener cannot run on a UNIX system.
  • If you use the PowerExchange Logger for Linux, UNIX, and Windows, you can run it on the system where the PowerExchange Listener runs or on another Linux, UNIX, or Windows system for which you configure remote logging.
  • On the PowerExchange Listener and PowerExchange Navigator machines, ensure that you have a license.key file that contains a key that authorizes use of Microsoft SQL Server CDC.

0 COMMENTS

We’d like to hear from you!