MS SQL Server requirements - 7.3

Talend Change Data Capture Installation Guide

Version
7.3
Language
English
Product
Talend Change Data Capture
Module
Talend Change Data Capture
Content
Data Governance > Third-party systems > Database components (Integration) > Change Data Capture
Data Quality and Preparation > Third-party systems > Database components (Integration) > Change Data Capture
Design and Development > Third-party systems > Database components (Integration) > Change Data Capture
Last publication date
2023-10-05
  • A VM or physical machine with 2 cores or more, 4GB RAM or more, an OS >Windows 2008R2 (not necessarily the server type), and 32 or 64 bits.
  • The installation must be performed with an administrator profile on this machine.
  • A Microsoft native ODBC driver for MS SQL Server with a 32-bit version must be installed.
  • Requirements to capture an MS SQL Server source:
    • Express version is not supported.
    • The transactional replication component needs to be installed.

      To test the installation of the component, enter the following command:

      EXEC sp_MS_replication_installed

      If the component is installed, the answer is: Command(s) completed successfully.

      Tables to replicate must have a Primary Key (Microsoft constraint).

    • You need to install on the VM or physical machine the SQL Server 32-bit client (ODBC 32-bit Native client driver). During the installation, the system MS SQL Server password (sysadmin right) is needed.