Managed Routing Load and Workloads with Data Synchronization | Teradata Unity - Managed Routing Load and Workloads Requiring Data Synchronization - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Continuous Availability
Teradata Unity
Release Number
September 2020
English (United States)
Last Update
Product Category
Analytical Ecosystem

Managed routing is a form of Unity connectivity 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 Unity recovery log, so if any system is unavailable or encounters an unexpected error Unity 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. They can run using SQL multicast or Change-data-multicast (CDM), if it is enabled on the Teradata systems. Managed routing parses the incoming request to identify what tables and rows are affected by the request, and whether the query is deterministic. If the query is non-deterministic, it can run the request on one system first, and then replicate the change using CDM.
Changes performed on DBC user are never replicated using CDM.