Installing the AlwaysOn availability groups feature

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.

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.
   Information noteWarning: 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.

      Information noteWarning: 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.
   Information noteNote: 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.