MS SQL server datatype support - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

BIGINT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL

• FLOAT

• INTEGER

• NUMERIC

• REAL

• 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.

PostgreSQL

• BIGINT

• DECIMAL

• DOUBLE PRECISION

• INTEGER

• REAL

• SMALLINT

All Platforms

• CHAR (L)

• VARCHAR (L)

if L <= 18, Connect CDC Director warns.

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

BIT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• FLOAT

• INTEGER

• TIMESTAMP

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

All Platforms

• CHAR (L), where L >= 1.

• VARCHAR (L), where L >= 1.

CHAR

IBM i

• CHAR. (Unicode)

• CLOB

• DBCLOB. (Unicode)

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

UDB

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

MS SQL Server/SQL Azure

• TEXT

Oracle

• CLOB

• LONG

• VARCHAR2

All Platforms

• CHAR

• VARCHAR

CHAR

IBM i

• CLOB

• DBCLOB

MS SQL Server/SQL Azure

• TEXT

Oracle

• CLOB

• LONG

• VARCHAR2

All Platforms

• CHAR

• VARCHAR

DATE

Db2 (includes IBM i and UDB)

• DATE

• TIMESTAMP. 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

All Platforms

• CHAR (L)

• VARCHAR (L)

where L >= 8. Format of target value is YYYYMMDD.

DATETIME

Db2 (includes IBM i and UDB)

• TIMESTAMP. 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

All Platforms

• CHAR (L)

• VARCHAR (L)

where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.

DATETIME2(P)

Db2 (includes IBM i and UDB)

• DATE—Time data is truncated.

• TIME

• TIMESTAMP

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

All Platforms

• CHAR (L)

• VARCHAR (L)

L >= 21. Format of target value is YYYYMMDDHHMMSSFFFFFFF.

DATETIMEOFFSET(P)

Db2 (includes IBM i and UDB)

• DATE

• TIME

• TIMESTAMP

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

All Platforms

• CHAR (L)

• VARCHAR (L)

L >= 26. Format of target value is YYYYMMDDHHMMSSFFFFFFFsHHMM.

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.

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.

PostgreSQL

• BIGINT

• DOUBLE PRECISION

• DECIMAL

• INTEGER. Connect CDC Director warns.

• MONEY

• REAL

• SMALLINT. Connect CDC Director warns.

All Platforms

• CHAR (L), where L >= p+2.

• VARCHAR (L), where L >= p+2.

DOUBLE PRECISION

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

MS SQL Server/SQL Azure

• BIGINT

• DECIMAL (p,s)

• DOUBLE PRECISION

• FLOAT

• INTEGER

• REAL

Oracle

• DOUBLE PRECISION

• NUMBER

• NUMBER (p,s)

• NUMBER(38)

• VARCHAR2 (L), where L >= 22.

PostgreSQL

• BIGINT

• DECIMAL

• DOUBLE PRECISION

• INTEGER

• REAL

All Platforms

• CHAR (L), where L >= 22.

• VARCHAR (L), where L >= 22.

FLOAT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

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

All Platforms

• CHAR (L), where L >= 22.

• VARCHAR (L), where L >= 22.

GEOGRAPHY

MS SQL Server/SQL Azure

• GEOGRAPHY

• GEOMETRY

GEOMETRY

MS SQL Server/SQL Azure

• GEOGRAPHY

• GEOMETRY

IMAGE

IBM i

• BLOB

MS SQL Server/SQL Azure

• IMAGE

• VARBINARY(MAX)

Oracle

• BLOB

PostgreSQL

• BYTEA

INTEGER

Db2 (includes IBM i and UDB)

• BIGINT

• BIT

• DECIMAL(p,s)

• FLOAT

• INTEGER

• 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

All Platforms

• CHAR (L), where L>= 11.

• VARCHAR (L), where L>= 11.

MONEY

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL

• FLOAT

• INTEGER. Connect CDC Director warns.

• NUMERIC

• 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

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

NCHAR

Db2 (includes IBM i and UDB)

• CHAR (Unicode) ^a

• DBCLOB (Unicode for IBM i only)

• GRAPHIC (Unicode) ^b

• VARCHAR

• VARGRAPHIC (Unicode) ^b

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR^a

Oracle

• NCHAR

• NVARCHAR2

PostgreSQL

• 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.

NTEXT

Db2 (includes IBM i and UDB)

• CHAR ^a

• DBCLOB ((Unicode for IBM i only)

• GRAPHIC^a

• VARCHAR^a

• VARGRAPHIC^a

MS SQL Server/SQL Azure

• NCHAR^a

• NTEXT

• NVARCHAR^a

• NVARCHAR(MAX)

Oracle

• NCHAR ^a

• NVARCHAR2 ^a

PostgreSQL

• NTEXT

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

NUMERIC

Functionally equivalent to DECIMAL. See DECIMAL.

NVARCHAR

Db2 (includes IBM i and UDB)

• CHAR. (Unicode) ^a

• DBCLOB. ((Unicode for IBM i only)

• GRAPHIC. (Unicode) ^b

• VARCHAR^a

• VARGRAPHIC. (Unicode) ^b

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR ^a

Oracle

• NCHAR

• NVARCHAR2

PostgreSQL

• CHAR (Unicode type)

• TEXT (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.

NVARCHAR(MAX)

Db2 (includes IBM i and UDB)

• CHAR ^a

• DBCLOB (Unicode for IBM i only)

• GRAPHIC^a

• VARCHAR

• VARGRAPHIC

MS SQL Server/SQL Azure

• NCHAR

• NTEXT

• NVARCHAR ^a

• NVARCHAR(MAX)

Oracle

• NCHAR ^a

• NVARCHAR2 ^a

PostgreSQL

• TEXT (Unicode type)

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

REAL

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL (p,s)

• DOUBLE

• FLOAT

• INTEGER

• REAL

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

All Platforms

• CHAR (L), where L >= 22.

• VARCHAR (L), where L >= 22.

SMALLDATETIME

Db2 (includes IBM i and UDB)

• TIMESTAMP.

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

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.

SMALLINT

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL(p,s)

• FLOAT

• INTEGER

• 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

All Platforms

• CHAR (L), where L>= 6.

• VARCHAR (L), where L>= 6.

SMALLMONEY

Db2 (includes IBM i and UDB)

• BIGINT

• DECIMAL

• FLOAT

• INTEGER. Connect CDC Director warns.

• NUMERIC

• 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

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

TEXT

MS SQL Server/SQL Azure

• CHAR ^a

• TEXT

• VARCHAR ^a

• VARCHAR(MAX)

Oracle

• CLOB

• LONG

PostgreSQL

• TEXT

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

TIME/TIME(P)

Db2 (includes IBM i and UDB)

• TIME

• TIMESTAMP

MS SQL Server/SQL Azure

• DATETIME

• DATETIME2(P)

• DATETIMEOFFSET(P)

• SMALLDATETIME

• TIME

• TIME(P)

Oracle

• DATE

• TIMESTAMP.

• TIMESTAMP (P)

• VARCHAR2.

PostgreSQL

• TIME

• TIMESTAMP

All Platforms

• CHAR

• VARCHAR

TINYINT

Db2 (includes IBM i and UDB)

• DECIMAL

• FLOAT

• INTEGER

• 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

All Platforms

• CHAR (L), where L>= 3.

• VARCHAR (L), where L>= 3.

UNIQUEIDENTIFIER

Db2 (includes IBM i and UDB)

• CHAR

• VARCHAR ^a

MS SQL Server/SQL Azure

• CHAR

• UNIQUEIDENTIFIER

• VARCHAR ^a

Oracle

• CHAR

• VARCHAR ^a

^aSee Distribute UNIQUEIDENTIFIER columns for more information.

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

VARBINARY(MAX)

IBM i

• BLOB

MS SQL Server/SQL Azure

• IMAGE

• VARBINARY(MAX)

Oracle

• BLOB

VARCHAR

Db2 (includes IBM i and UDB)

• CLOB (for IBM i only)

• DBCLOB (for IBM i only)

• GRAPHIC. (Unicode)

• VARGRAPHIC. (Unicode)

MS SQL Server/SQL Azure

• TEXT

• VARCHAR (MAX)

Oracle

• VARCHAR2

All Platforms

• CHAR

• VARCHAR

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.

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