Teradata 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 Teradata (as target-only) datatype support.

Teradata Target-only Datatype

Supported Sources

BIGINT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

 

Informix

  • FLOAT

  • INTEGER

  • SMALLINT

 

MS SQL Server

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

 

Sybase

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

All platforms

  • CHAR (L)

  • VARCHAR (L)

if L <= 18, Connect CDC Director warns.

*Oracle recommends VARCHAR2.

 

Teradata Target-only Datatype

Supported Sources

BYTEINT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

 

Informix

  • FLOAT

  • INTEGER

  • SMALLINT

 

MS SQL Server

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

 

Sybase

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

Teradata Target-only Datatype

Supported Sources

CHAR

DB2 (includes IBM i and UDB)

  • BIGINT (only IBM i and UDB)

  • CHAR

  • DATE

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIME

  • TIMESTAM

  • VARCHAR

 

Informix

  • CHAR

  • DATE

  • DATETIME

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • INTERVAL

  • MONEY

  • NUMERIC

  • REAL

  • SERIAL

  • SMALLFLOAT

  • SMALLINT

  • VARCHAR

CHAR

MS SQL Server

  • BIGINT

  • BIT

  • CHAR

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLDATETIME

  • SMALLINT

  • SMALLMONEY

  • TEXT

  • TIME

  • TIME(P)

  • TINYINT

  • VARCHAR

  • VARCHAR (MAX)

CHAR

Oracle

  • CHAR

  • CLOB

  • DATE

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • LONG

  • LONG RAW

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIMESTAMP

  • TIMESTAMP(P)

  • VARCHAR

  • VARCHAR2

 

Sybase

  • BIT

  • CHAR

  • DATETIME

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLDATETIME

  • SMALLINT

  • SMALLMONEY

  • TEXT

  • TIME

  • TINYINT

  • VARCHAR

Teradata Target-only Datatype

Supported Sources

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

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

 

Sybase

  • DATETIME. Time generated as all zero's.

  • SMALLDATETIME. Time generated as all zero's.

 

Teradata Target-only Datatype

Supported Sources

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

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

DECIMAL

Oracle

  • NUMBER (p,s)

  • NUMBER

  • NUMBER(38)

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

 

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 Target-only Datatype

Supported Sources

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

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • DOUBLE PRECISION

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

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

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

Teradata Target-only Datatype

Supported Sources

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

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

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

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

Teradata Target-only Datatype

Supported Sources

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

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

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

 

Sybase

  • DATETIME. Time generated as all zero's.

  • INTEGER

  • SMALLINT

  • TINYINT

Teradata Target-only Datatype

Supported Sources

LONG VARCHAR

  • Functionally equivalent to DECIMAL. See CHAR .

NUMBER

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • NUMERIC (p,s)

  • REAL

  • SMALLINT

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC (p,s)

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

NUMBER

Oracle

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (38)

  • NUMBER (p,s)

  • NUMERIC

  • REAL

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

Teradata Target-only Datatype

Supported Sources

NUMERIC

  • Functionally equivalent to DECIMAL. See DECIMAL .

 

Teradata Target-only Datatype

Supported Sources

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

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • NUMBER

  • NUMBER (p,s)

  • NUMBER(38)

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

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

Teradata Target-only Datatype

Supported Sources

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

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

 

Sybase

  • DATETIME. Time generated as all zero's.

  • INTEGER

  • SMALLINT

  • TINYINT

 

 

Teradata Target-only Datatype

Supported Sources

TIME(P)

DB2 (includes IBM i and UDB)

  • TIME

  • TIMESTAMP

 

Informix

  • DATETIME

 

MS SQL Server

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • TIMESTAMP

  • TIMESTAMP (P)

 

Sybase

  • DATETIME

  • SMALLDATETIME

Teradata Target-only Datatype

Supported Sources

TIMESTAMP

DB2 (includes IBM i and UDB)

  • DATE

  • TIME

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

  • TIMESTAMP (P)

 

Sybase

  • DATETIME

  • SMALLDATETIME

Teradata Target-only Datatype

Supported Sources

TIMESTAMP (P)

DB2 (includes IBM i and UDB)

  • DATE

  • TIME

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

  • TIMESTAMP (P)

 

Sybase

  • DATETIME

  • SMALLDATETIME

Teradata Target-only Datatype

Supported Sources

VARCHAR

  • Functionally equivalent to CHAR. See CHAR .