Installing the AlwaysOn availability groups feature - 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

This section describes the installation of Talend Change Data Capture when the source databases are organized in availability groups (or clusters) that include databases and their replicas on primary and secondary nodes.

Before you begin

Follow section Preparing your installation and install Talend Change Data Capture according to section Installing the Manager GUI on Windows NT Server. Also make sure the license is installed (see section Under 7.16.1 version: fields completion) on the server machine.

About this task

In this configuration, Talend Change Data Capture Manager connects to one source engine (= one availability group) at a time. The Always On service needs to be activated in the Manager.

Procedure

  1. Run the setup executable file to add the first source engine. A screen called What do you want to do? is displayed. Click Add a new SQL Server source instance. In the Server field, enter the availability group listener DNS name and click Ok.
    Warning: Do not enter a private IP address assigned to a node of the group.
  2. From your database management tool, add DD_USRDATA to the Availability databases group of the AlwaysOn High availability group.
    Example on MS SQL Server:

    Make sure that DD_USRDATA is replicated on primary and secondary nodes of the group.
  3. Activate the AlwaysOn feature:
    1. Go to Windows Services and stop the SQLServer service.
    2. Now go to Registry tab and select the server instance name under DD_for_SQLServer directory. Details are displayed on the right part of the screen.
    3. To activate the AlwaysOn service, double-click the AlwaysOn label and change the value to 1.
    4. Restart the MS SQL Server service.

      Go to Options and check the service is running correctly in ddmsgq.ddm tab (if the message: No valid license key found is displayed, see section Under 7.16.1 version: fields completion).

    5. Start the Manager. Click File > Source subscribe.
      In the IP field, enter the listener address of the availability group.
      Warning: Do not enter a private IP address assigned to a node of the group.
      In the Instance or Server name field, enter the listener DNS name (the same as entered when installing the source engine at step 1).
  4. If you work on a Windows NT Server machine, you need to prepare the journalization process.
    Note: When creating the destination directories, make sure you have one subdirectory per database (you can use the source engine names).
  5. If you need to add other source engines, repeat steps 1 to 4.
  6. When using the Manager, if you need to switch nodes within the same availability group, click the connection button: the current node is disconnected.
    Click on the button again: the connection is automatically made to the available node.