Connect CDC Director prevents as many configuration errors as possible during model definition and validation by verifying the following:
-
Datatype of each source column
If a source column’s datatype is not supported, Connect CDC Director does not display the column in the list of available source columns when defining a mapping for a target column. The datatypes supported for each DBMS are specified in the DBMS-specific sections in these pages.
-
Datatype of each target column
If a target column’s datatype is not supported, Connect CDC Director displays the column but does not allow any mapping to be defined to the target column.
-
Compatibility between source and target columns
Connect CDC Director prevents mapping between incompatible source and target datatypes. Connect CDC Director issues warning messages and allows mappings between source and target datatypes that may be problematic.
To determine whether datatypes are compatible, the Connect CDC Director uses a matrix of generic categories instead of comparing every pair of DBMS SQL datatypes. For more information about Connect CDC datatype categories and conversion rules, see Datatype Conversion Rules.
In most cases, if a datatype compatibility check fails in the Connect CDC Director due to a violation of the rules defined for each DBMS type, Connect CDC Director validation returns an ERROR level severity. The EDMM cannot be committed. However, for the following cases, the Connect CDC Director returns a Warning level, and the EDMM can be committed (depending upon the Allow commit of models containing: option you choose on the Model Properties dialog box):
-
CHARACTER or LONG CHARACTER datatypes in a sending column to either character datatype in a receiving column, where the sending column length is greater than the receiving column length.
-
NUMERIC datatype in a sending column to character datatype in a receiving column, where the sending column length is greater than the receiving column length.