One of our major Customers, Poste Italiane (Account id: 1130105) would like to configure debezium CDC on SQL Server configured in Always On mode.
A hard requirement of this project is to have automatic failover of a SQL Server database to a standby server in case the primary server becomes unavailable. Therefore, in production environment, they need to enable the "Always On" mode which will basically expose a listener address instead of direct Hostname address to its clients.
This option does not appear to be tested. There is a mention of it, in the community documentation https://debezium.io/documentation/reference/2.1/connectors/sqlserver.html#sqlserver-always-on-replica.
Database version: SQL Server 2017 Product: 14.0.3356.20 CU22
Use Debezium Connector with SQL Server in HA.