Connect CDC Director datatype verification - connect_cdc_mimix_share - 5.8

Connect CDC System Reference Guide

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
Connect > Connect CDC (MIMIX Share)
Version
5.8
Language
English
Product name
Connect CDC
Title
Connect CDC System Reference Guide
Copyright
2024
First publish date
2003
ft:lastEdition
2024-02-12
ft:lastPublication
2024-02-12T15:11:59.486869

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.