Supported datatypes - 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 supports a significant subset of the column datatypes of the DBMSs it supports. This section describes the supported datatypes as well as the rules that govern the compatibility between source and target datatypes.   

Connect CDC has restrictions on the datatypes that can be distributed as well as restrictions on which sending table datatypes can be mapped to which receiving table datatypes. Connect CDC Director enforces the restrictions by applying the conversion rules discussed in this section.

In addition, the Connect CDC component that prepares the actual data, applies formatting rules before sending the data to the target. The target DBMS has its rules for handling data, which must be considered in cases where the column data does not fit the column definition.

Note: Connect CDC cannot replicate database column values longer than 2 GB.

The topics in this section are: