MS SQL server datatype support - 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

The following tables show the MS SQL Server (as source) datatype support.

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

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

  • NVARCHARa

 

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 can­not 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)

  • GRAPHICa

  • VARCHARa

  • VARGRAPHICa

Informix
 

MS SQL Server/SQL Azure

  • NCHARa

  • NTEXT

  • NVARCHARa

  • 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 trun­cation 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

NVARCHAR

DB2 (includes IBM i and UDB)

  • CHAR. (Unicode) a

  • DBCLOB. ((Unicode for IBM i only)

  • GRAPHIC. (Unicode) b

  • VARCHARa

  • 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 can­not 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)

  • GRAPHICa

  • 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 trun­cation 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 trun­cation 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

aIndicates that Connect CDC Director will issue a warning of possible trun­cation 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

For details on rules and restrictions for MS SQL Server XML support refer to MS SQL Server XML Support.