How to Use Wildcards in Routing Rules | Teradata Unity - 17.00 - Using Wildcards in Routing Rules - Continuous Availability - Teradata Unity

Teradata® Unity™ User Guide

Continuous Availability
Teradata Unity
Release Number
September 2020
English (United States)
Last Update

You can use a wildcard character (*) to define routing rules when more than one Teradata system is managed by Unity. Use of a wildcard creates a Preferred routing rule because it automatically includes multiple systems and a preferred order for Read/Writes and Failover.

You can use a wildcard character (*) for the userid and accountstring in user mappings. Unity recognizes four types of userid pattern matching and four types of accountstring pattern matching.
Pattern Description Example
Exact match Exact name match and exact account string match are always first choice in mappings. patriciadarrell syssd1
Trailing wildcard match Field must start with the pattern. pat* syssd*
Leading wildcard match Field must end with the pattern. *darrell *sd1
You cannot use a wildcard character (*) within a string. Use wildcards only at the beginning or end of the string.
When using wildcards, be careful with overlapping wildcards. A userid and accountstring could match multiple entries in the routing file. Unity uses the user mapping with the lowest ordinal value that matches the userid and accountstring.