MS SQL server datatype support - connect_cdc_mimix_share

MS SQL Server Source Datatype	Supported Targets
BIGINT	DB2 (includes IBM i and UDB) BIGINT DECIMAL FLOAT INTEGER NUMERIC REAL SMALLINT
	Informix FLOAT INTEGER SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL FLOAT INTEGER MONEY NUMERIC REAL SMALLINT SMALLMONEY TINYINT
	Oracle NUMBER (38) NUMBER (p,s) VARCHAR2 (L), if L <= 18, Connect CDC Director warns.
BIGINT	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER REAL SMALLINT
	Sybase BIT DECIMAL FLOAT INTEGER SMALLINT TINYINT
	Teradata BIGINT BYTEINT DECIMAL FLOAT INTEGER LONG VARCHAR NUMBER NUMERIC REAL SMALLINT
	All Platforms CHAR (L) VARCHAR (L) if L <= 18, Connect CDC Director warns.

MS SQL Server Source Datatype	Supported Targets
BINARY	IBM i BLOB CHAR FOR BIT VARCHAR FOR BIT DATA UDB CHAR FOR BIT VARCHAR FOR BIT DATA
	MS SQL Server/SQL Azure BINARY IMAGE VARBINARY VARBINARY(MAX)
	Oracle BLOB LONG RAW RAW
	PostgreSQL BYTEA
	Sybase BINARY IMAGE VARBINARY

MS SQL Server Source Datatype	Supported Targets
BIT	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) FLOAT INTEGER TIMESTAMP
	Informix DECIMAL (p,s) FLOAT SMALLFLOAT INTEGER
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL (p,s) FLOAT SMALLINT TINYINT
	Oracle NUMBER NUMBER(38) NUMBER (p,s) VARCHAR2 (L), where L >= 1.
	PostgreSQL BOOLEAN DECIMAL INTEGER SMALLINT
BIT	Sybase BIT DECIMAL (p,s) FLOAT INTEGER SMALLINT TINYINT
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER LONG VARCHAR NUMBER SMALLINT
	All Platforms CHAR (L), where L >= 1. VARCHAR (L), where L >= 1.

MS SQL Server Source Datatype	Supported Targets
CHAR	IBM i CHAR. (Unicode) CLOB DBCLOB. (Unicode) GRAPHIC. (Unicode) VARGRAPHIC. (Unicode) UDB GRAPHIC. (Unicode) VARGRAPHIC. (Unicode)
	Informix
	MS SQL Server/SQL Azure TEXT
	Oracle CLOB LONG VARCHAR2
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

MS SQL Server Source Datatype	Supported Targets
CHAR	IBM i CLOB DBCLOB
	Informix
	MS SQL Server/SQL Azure TEXT
	Oracle CLOB LONG VARCHAR2
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

MS SQL Server Source Datatype	Supported Targets
DATE	DB2 (includes IBM i and UDB) DATE TIMESTAMP. Time generated as all zero's.
	Informix DATE DATETIME. Ideal mapping is to DATETIME (YEAR TO DAY). For other target columns, data is padded or truncated to fit the target. Time generated as all zero's.
	MS SQL Server/SQL Azure DATE DATETIME. Time generated as all zero's. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME. Time generated as all zero's.
	Oracle DATE TIMESTAMP. Time generated as all zero's. VARCHAR2 (L), where L >= 8. Format of target value is YYYYMMDD.
	PostgreSQL DATE TIMESTAMP
	Sybase DATETIME. Time generated as all zero's. SMALLDATETIME. Time generated as all zero's.
	Teradata DATE LONG VARCHAR (L), where L >= 8. Format of target value is YYYYMMDD. TIMESTAMP. Time generated as all zero's. TIMESTAMP(P). Add several timestamps with different precisions
	All Platforms CHAR (L) VARCHAR (L) where L >= 8. Format of target value is YYYYMMDD.

MS SQL Server Source Datatype	Supported Targets
DATETIME	DB2 (includes IBM i and UDB) TIMESTAMP. Time generated as all zero's.
	Informix DATE DATETIME. Ideal mapping is to DATETIME (YEAR TO DAY). For other target columns, data is padded or truncated to fit the target. Time generated as all zero's.
	MS SQL Server/SQL Azure DATE DATETIME. Time generated as all zero's. DATETIME2(P) DATETIMEOFFSET(P) TIME TIME(P) SMALLDATETIME. Time generated as all zero's.
	Oracle DATE TIMESTAMP. Time generated as all zero's. TIMESTAMP(P) VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	PostgreSQL DATE TIME TIMESTAMP
	Sybase DATE DATETIME. Time generated as all zero's. SMALLDATETIME. Time generated as all zero's.
DATETIME	Teradata DATE LONG VARCHAR TIME TIMESTAMP. Time generated as all zero's. TIMESTAMP(P). Add several timestamps with different precisions
	All Platforms CHAR (L) VARCHAR (L) where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

MS SQL Server Source Datatype	Supported Targets
DATETIME2(P)	DB2 (includes IBM i and UDB) DATE—Time data is truncated. TIME TIMESTAMP
	Informix DATE DATETIME. Time generated as all zero's. Ideal mapping is to INFORMIX YEAR TO FRACTION(3).
	MS SQL Server/SQL Azure DATE DATETIME. Time generated as all zero's. SMALLDATETIME. Time generated as all zero's. TIME TIME(P)
	Oracle DATE TIMESTAMP. Time generated as all zero's. TIMESTAMP(P) VARCHAR2 (L), where L >= 21. Format of target value is YYYYMMDDHHMMSSFFFFFFF.
	PostgreSQL DATE TIME TIMESTAMP
DATETIME2(P)	Sybase DATE DATETIME. Time generated as all zero's. DATETIME2. Time generated as all zero's. DATETIMEOFFSET SMALLDATETIME. Time generated as all zero's.
	Teradata DATE LONG VARCHAR TIME TIMESTAMP. Time generated as all zero's. TIMESTAMP(P). Add several timestamps with different precisions
	All Platforms CHAR (L) VARCHAR (L) L >= 21. Format of target value is YYYYMMDDHHMMSSFFFFFFF.

MS SQL Server Source Datatype	Supported Targets
DATETIMEOFFSET(P)	DB2 (includes IBM i and UDB) DATE TIME TIMESTAMP
	Informix DATE DATETIME. Time generated as all zero's.
	MS SQL Server/SQL Azure DATE DATETIME. Time generated as all zero's. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME. Time generated as all zero's. TIME TIME(P)
	Oracle DATE TIMESTAMP. Time generated as all zero's. TIMESTAMP(P) VARCHAR2 (L), where L >= 26. Format of target value is YYYYMMDDHHMMSSFFFFFFFsHHMM.
	PostgreSQL DATE TIME TIMESTAMP
	Sybase DATE DATETIME. Time generated as all zero's. DATETIMEOFFSET SMALLDATETIME. Time generated as all zero's. TIME
DATETIMEOFFSET(P)	Teradata DATE LONG VARCHAR TIME TIMESTAMP. Time generated as all zero's. TIMESTAMP(P). Add several timestamps with different precisions
	All Platforms CHAR (L) VARCHAR (L) L >= 26. Format of target value is YYYYMMDDHHMMSSFFFFFFFsHHMM.

MS SQL Server Source Datatype	Supported Targets
DECIMAL	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	Informix DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY NUMERIC (p,s) SMALLFLOAT SMALLINT. Connect CDC Director warns.
	MS SQL Server/SQL Azure BIGINT BIT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Oracle NUMBER (p,s) NUMBER NUMBER(38) VARCHAR2 (L), where L >= p+2.
DECIMAL	PostgreSQL BIGINT DOUBLE PRECISION DECIMAL INTEGER. Connect CDC Director warns. MONEY REAL SMALLINT. Connect CDC Director warns.
	Sybase BIT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. LONG VARCHAR NUMBER NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	All Platforms CHAR (L), where L >= p+2. VARCHAR (L), where L >= p+2.

MS SQL Server Source Datatype	Supported Targets
DOUBLE PRECISION	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL SMALLFLOAT
	MS SQL Server/SQL Azure BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
DOUBLE PRECISION	Oracle DOUBLE PRECISION NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER REAL
	Sybase DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
	Teradata BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER LONG VARCHAR REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

MS SQL Server Source Datatype	Supported Targets
FLOAT	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE PRECISION INTEGER FLOAT REAL SMALLFLOAT
	MS SQL Server/SQL Azure BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER REAL SMALLINT
FLOAT	Sybase DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
	Teradata BIGINT DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER LONG VARCHAR NUMBER REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

MS SQL Server Source Datatype	Supported Targets
GEOGRAPHY	MS SQL Server/SQL Azure GEOGRAPHY GEOMETRY

MS SQL Server Source Datatype

Supported Targets

GEOGRAPHY

MS SQL Server/SQL Azure

GEOGRAPHY
GEOMETRY

MS SQL Server Source Datatype	Supported Targets
GEOMETRY	MS SQL Server/SQL Azure GEOGRAPHY GEOMETRY

MS SQL Server Source Datatype

Supported Targets

GEOMETRY

MS SQL Server/SQL Azure

GEOGRAPHY
GEOMETRY

MS SQL Server Source Datatype	Supported Targets
IMAGE	IBM i BLOB
	MS SQL Server/SQL Azure IMAGE VARBINARY(MAX)
	Oracle BLOB
	PostgreSQL BYTEA
	Sybase IMAGE

MS SQL Server Source Datatype	Supported Targets
INTEGER	DB2 (includes IBM i and UDB) BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT
	Informix DECIMAL(p,s) FLOAT INTEGER SMALLFLOAT SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L>= 11.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER REAL SMALLINT
INTEGER	Sybase DATETIME. Time generated as all zero's. INTEGER SMALLINT TINYINT
	Teradata BIGINT BYTEINT DECIMAL FLOAT INTEGER LONG VARCHAR NUMBER SMALLINT
	All Platforms CHAR (L), where L>= 11. VARCHAR (L), where L>= 11.

MS SQL Server Source Datatype	Supported Targets
MONEY	DB2 (includes IBM i and UDB) BIGINT DECIMAL FLOAT INTEGER. Connect CDC Director warns. NUMERIC SMALLINT. Connect CDC Director warns.
	Informix DECIMAL FLOAT INTEGER. Connect CDC Director warns. MONEY NUMERIC SMALLFLOAT SMALLINT. Connect CDC Director warns.
	MS SQL Server/SQL Azure BIGINT BIT. Connect CDC Director warns. DECIMAL (p,s) FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= p+2.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION MONEY
MONEY	Sybase BIT DECIMAL FLOAT INTEGER MONEY (assumed tp = 19, ts = 4) NUMERIC SMALLINT. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL INTEGER. LONG VARCHAR NUMBER NUMERIC SMALLINT. Connect CDC Director warns.
	All Platforms CHAR VARCHAR
	Notes: For all the above: Source precision and scale are fixed at 19 and 4. Range of values for all datatypes: Minimum values: -922, 337, 203,685, 477.5808 Maximum values: +922, 337, 203,685, 477.5807

MS SQL Server Source Datatype	Supported Targets
NCHAR	DB2 (includes IBM i and UDB) CHAR (Unicode) ^a DBCLOB (Unicode for IBM i only) GRAPHIC (Unicode) ^b VARCHAR VARGRAPHIC (Unicode) ^b
	Informix NCHAR NVARCHAR ^a
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR^a
	Oracle NCHAR NVARCHAR2
	PostgreSQL CHAR (Unicode type) VARCHAR (Unicode type)
	Sybase
	Teradata CHAR (Unicode type) VARCHAR (Unicode type)

^aOnly if defined in a Unicode database. NCHAR/NVARCHAR columns cannot be mapped to ordinary CHAR/VARCHAR columns.

^bIf tagged with a CCSID that supports a conversion to Unicode.

MS SQL Server Source Datatype	Supported Targets
NTEXT	DB2 (includes IBM i and UDB) CHAR ^a DBCLOB ((Unicode for IBM i only) GRAPHIC^a VARCHAR^a VARGRAPHIC^a
	Informix
	MS SQL Server/SQL Azure NCHAR^a NTEXT NVARCHAR^a NVARCHAR(MAX)
	Oracle NCHAR ^a NVARCHAR2 ^a
	PostgreSQL NTEXT
	Sybase
	Teradata CHAR ^a LONG VARCHAR ^a VARCHAR ^a

^aIndicates that Connect CDC Director will issue a warning of possible truncation of data at the target.

MS SQL Server Source Datatype	Supported Targets
NUMERIC	Functionally equivalent to DECIMAL. See DECIMAL.

MS SQL Server Source Datatype

Supported Targets

NUMERIC

Functionally equivalent to DECIMAL. See DECIMAL.

MS SQL Server Source Datatype	Supported Targets
NVARCHAR	DB2 (includes IBM i and UDB) CHAR. (Unicode) ^a DBCLOB. ((Unicode for IBM i only) GRAPHIC. (Unicode) ^b VARCHAR^a VARGRAPHIC. (Unicode) ^b
	Informix NCHAR NVARCHAR
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR ^a
	Oracle NCHAR NVARCHAR2
	PostgreSQL CHAR (Unicode type) TEXT (Unicode type) VARCHAR (Unicode type)
	Sybase
	Teradata CHAR (Unicode) VARCHAR (Unicode)

^aOnly if defined in a Unicode database. NCHAR/NVARCHAR columns cannot be mapped to ordinary CHAR/VARCHAR columns.

^bIf tagged with a CCSID that supports a conversion to Unicode.

MS SQL Server Source Datatype	Supported Targets
NVARCHAR(MAX)	DB2 (includes IBM i and UDB) CHAR ^a DBCLOB (Unicode for IBM i only) GRAPHIC^a VARCHAR VARGRAPHIC
	Informix
	MS SQL Server/SQL Azure NCHAR NTEXT NVARCHAR ^a NVARCHAR(MAX)
	Oracle NCHAR ^a NVARCHAR2 ^a
	PostgreSQL TEXT (Unicode type)
	Sybase
	Teradata CHAR ^a LONG VARCHAR ^a VARCHAR ^a

^aIndicates that Connect CDC Director will issue a warning of possible truncation of data at the target

MS SQL Server Source Datatype	Supported Targets
REAL	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER REAL
	Informix DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL SMALLFLOAT
	MS SQL Server/SQL Azure DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
	Oracle NUMBER NUMBER (p,s) NUMBER(38) VARCHAR2 (L), where L >= 22.
	PostgreSQL BIGINT DOUBLE PRECISION REAL
	Sybase DECIMAL (p,s) DOUBLE PRECISION FLOAT INTEGER REAL
REAL	Teradata BIGINT DOUBLE PRECISION FLOAT INTEGER LONG VARCHAR NUMBER REAL
	All Platforms CHAR (L), where L >= 22. VARCHAR (L), where L >= 22.

MS SQL Server Source Datatype	Supported Targets
SMALLDATETIME	DB2 (includes IBM i and UDB) TIMESTAMP.
	Informix DATETIME. Ideal mapping is to DATETIME (YEAR TO MINUTE).
	MS SQL Server/SQL Azure DATETIME. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME
	Oracle TIMESTAMP. TIMESTAMP(P) VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	PostgreSQL DATE TIME TIMESTAMP
	Sybase DATETIME SMALLDATETIME
	Teradata LONG VARCHAR TIMESTAMP TIMESTAMP(P)
	All Platforms CHAR (L) VARCHAR (L) where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	For all datatypes: Missing seconds and fractions of seconds are generated as zeros.

MS SQL Server Source Datatype	Supported Targets
SMALLINT	DB2 (includes IBM i and UDB) BIGINT DECIMAL(p,s) FLOAT INTEGER SMALLINT
	Informix DECIMAL(p,s) FLOAT INTEGER SMALLFLOAT SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Oracle NUMBER NUMBER(38) NUMBER (p,s). Connect CDC Director warns. VARCHAR2 (L), where L>= 6.
	PostgreSQL BIGINT DECIMAL INTEGER SMALLINT
SMALLINT	Sybase BIT DECIMAL(p,s) FLOAT INTEGER SMALLINT TINYINT
	Teradata BIGINT BIT BYTEINT DECIMAL(p,s) FLOAT INTEGER NUMBER LONG VARCHAR SMALLINT
	All Platforms CHAR (L), where L>= 6. VARCHAR (L), where L>= 6.

MS SQL Server Source Datatype	Supported Targets
SMALLMONEY	DB2 (includes IBM i and UDB) BIGINT DECIMAL FLOAT INTEGER. Connect CDC Director warns. NUMERIC SMALLINT. Connect CDC Director warns.
	Informix DECIMAL FLOAT INTEGER. Connect CDC Director warns. MONEY NUMERIC SMALLFLOAT SMALLINT. Connect CDC Director warns.
	MS SQL Server/SQL Azure BIGINT BIT. Connect CDC Director warns. DECIMAL FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4). NUMERIC SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Oracle NUMBER NUMBER NUMBER(38) VARCHAR2 (L), where L >= p+2.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION MONEY
SMALLMONEY	Sybase BIT. Connect CDC Director warns. DECIMAL FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC SMALLINT. Connect CDC Director warns. SMALLMONEY. Assumed tp = 10, ts = 4). TINYINT. Connect CDC Director warns.
	Teradata BIGINT BYTEINT. Connect CDC Director warns. DECIMAL (p,s) INTEGER. Connect CDC Director warns. LONG VARCHAR NUMBER NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	All Platforms CHAR (L), where L >= p+2. VARCHAR (L), where L >= p+2.
	Notes: Source precision and scale are fixed at 19 and 4. Range of values for all datatypes: Minimum values: -214, 748.3648 Maximum values: +214, 748.3647

MS SQL Server Source Datatype	Supported Targets
TEXT	MS SQL Server/SQL Azure CHAR ^a TEXT VARCHAR ^a VARCHAR(MAX)
	Oracle CLOB LONG
	PostgreSQL TEXT
	Sybase TEXT

^aIndicates that Connect CDC Director will issue a warning of possible truncation of data at the target.

MS SQL Server Source Datatype	Supported Targets
TIME/TIME(P)	DB2 (includes IBM i and UDB) TIME TIMESTAMP
	Informix DATETIME
	MS SQL Server/SQL Azure DATETIME DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME TIME TIME(P)
	Oracle DATE TIMESTAMP. TIMESTAMP (P) VARCHAR2.
	PostgreSQL TIME TIMESTAMP
	Sybase DATETIME SMALLDATETIME
	Teradata LONG VARCHAR TIME TIME(P) TIMESTAMP TIMESTAMP (P) TIMESTAMP(P)
	All Platforms CHAR VARCHAR
	Note: P can be between 0 and 7 and defaults to 7 when not specified and signifies the number of decimal fractions of a second.

MS SQL Server Source Datatype	Supported Targets
TINYINT	DB2 (includes IBM i and UDB) DECIMAL FLOAT INTEGER SMALLINT
	Informix DECIMAL FLOAT INTEGER SMALLFLOAT SMALLINT
	MS SQL Server/SQL Azure BIGINT BIT. Connect CDC Director warns. DECIMAL FLOAT INTEGER SMALLINT TINYINT
	Oracle NUMBER NUMBER(38) NUMBER. Connect CDC Director warns. VARCHAR2 (L), where L>= 3.
	PostgreSQL BIGINT DECIMAL INTEGER SMALLINT
	Sybase BIT. Connect CDC Director warns. DECIMAL FLOAT INTEGER SMALLINT TINYINT
TINYINT	Teradata BIGINT BYTEINT DECIMAL FLOAT INTEGER LONG VARCHAR NUMBER SMALLINT
	All Platforms CHAR (L), where L>= 3. VARCHAR (L), where L>= 3.

MS SQL Server Source Datatype	Supported Targets
UNIQUEIDENTIFIER	DB2 (includes IBM i and UDB) CHAR VARCHAR ^a
	MS SQL Server/SQL Azure CHAR UNIQUEIDENTIFIER VARCHAR ^a
	Oracle CHAR VARCHAR ^a
	Sybase CHAR VARCHAR ^a

^aSee Distributing UNIQUEIDENTIFIER Columns for more information.

MS SQL Server Source Datatype	Supported Targets
VARBINARY	IBM i BLOB CHAR FOR BIT DATA VARCHAR FOR BIT DATA UDB CHAR FOR BIT DATA VARCHAR FOR BIT DATA
	MS SQL Server/SQL Azure BINARY IMAGE VARBINARY VARBINARY(MAX)
	Oracle BLOB LONG RAW RAW
	PostgreSQL BYTEA
	Sybase BINARY IMAGE VARBINARY

MS SQL Server Source Datatype	Supported Targets
VARBINARY(MAX)	IBM i BLOB
	MS SQL Server/SQL Azure IMAGE VARBINARY(MAX)
	Oracle BLOB
	SYBASE IMAGE

MS SQL Server Source Datatype	Supported Targets
VARCHAR	DB2 (includes IBM i and UDB) CLOB (for IBM i only) DBCLOB (for IBM i only) GRAPHIC. (Unicode) VARGRAPHIC. (Unicode)
	Informix
	MS SQL Server/SQL Azure TEXT VARCHAR (MAX)
	Oracle VARCHAR2
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR

MS SQL Server Source Datatype	Supported Targets
VARCHAR(MAX)	MS SQL Server/SQL Azure CHAR ^a CLOB (for IBM i only) DBCLOB (for IBM i only) TEXT VARCHAR ^a VARCHAR(MAX)
	Oracle CLOB LONG

MS SQL Server Source Datatype

Supported Targets

VARCHAR(MAX)

MS SQL Server/SQL Azure

CHAR ^a
CLOB (for IBM i only)
DBCLOB (for IBM i only)
TEXT
VARCHAR ^a
VARCHAR(MAX)

Oracle

CLOB
LONG

^aIndicates that Connect CDC Director will issue a warning of possible truncation of data at the target.

MS SQL Server Source Datatype	Supported Targets
XML	DB2 (includes IBM i and UDB) CLOB DBCLOB
	MS SQL Server/SQL Azure NTEXT TEXT NVARCHAR(MAX) VARCHAR(MAX) XML
	Oracle CLOB NCLOB XMLTYPE
	Sybase TEXT

MS SQL server datatype support - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide