The UNIQUEIDENTIFIER datatype is designed for storing system-generated, globally unique identifiers (GUIDs).
In Connect CDC hierarchical configurations, UNIQUEIDENTIFIER columns may be replicated or copied to MS SQL Server UNIQUEIDENTIFIER columns and to CHAR or VARCHAR columns or their equivalents in any Connect CDC target DBMS.
In bidirectional configurations, UNIQUEIDENTIFIER columns may be replicated or copied only to UNIQUEIDENTIFIER columns.
UNIQUEIDENTIFIER targets must have a UNIQUEIDENTIFIER source.
The UNIQUEIDENTIFIER values are stored in MS SQL Server databases in a 16-byte binary format, and Connect CDC reads and sends the values as hexadecimal-digit character strings (length 36) in the form:
xxxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx
where the 32 x’s are hex digits and the hyphens are included. For example:
6F9619FF-8B86-D011-B42D-00C04FC964FF
UNIQUEIDENTIFIER source columns may be distribution keys and may be part of an expression if the target column is a character type.