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 

What Debezium connector do you use and what version?

2.1.4

What is the connector configuration?

connector-config

Which use case/requirement will be addressed by the proposed feature?

Use Debezium Connector with SQL Server in HA.