Support for SQL Server Always On Availability Groups
Support for SQL Server Always On Availability Groups
PowerExchange 10.1.1 can capture changes that are written to an availability database in a SQL Server Always On Availability Group. An Availability Group consists of primary and secondary replica databases on multiple nodes in a Windows Server Failover Clustering (WSFC) cluster. Only the following configuration has been tested and certified for PowerExchange CDC:
The distribution database is installed on a node outside of the Always On Availability Group cluster, which is consistent with SQL Server requirements.
PowerExchange is installed on a node outside of the Always On Availability Group cluster.
When you create a registration group for the SQL Server Always On Availability Group source, you specify the Availability Group listener name in the
Database Server
field.
If you need to use another configuration, contact Informatica Global Customer Support. Informatica will try to accommodate your request.
After CDC processing is running, If the primary database fails over to a secondary replica database on another node, PowerExchange can continue to capture change data from the distribution database without data loss.