Managed routing is recommended for data synchronization. Use a managed routing rule for load, ETL, or ELT processes that write permanent data to the Teradata systems to synchronize it across a set of Teradata systems.
Managed routing sessions are logged to the Business Continuity Manager Recovery Log, so if any system is unavailable or encounters an unexpected error, Business Continuity Manager can automatically replay the request when the system becomes available.
Managed routing also performs continuous consistency checking on the responses to any write performed to the database systems, to make sure all systems produce the same results.
Changes made in managed routing sessions can be synchronized in two ways. You can use SQL Multicast or CDM, if it is enabled on the Teradata systems. Managed routing parses the incoming request to identify the affected tables and rows, and whether the query is deterministic. If the query is non-deterministic, it can run the request on the active system first, and then replicate the change on the standby system using CDM.
Changes performed on DBC users are never replicated using CDM.