Oracle datatype support - connect_cdc_mimix_share

Oracle Source Datatype	Supported Targets
BLOB	IBM i BLOB
	MS SQL Server/SQL Azure IMAGE
	Oracle BLOB LONG RAW

Oracle Source Datatype

Supported Targets

BLOB

IBM i

BLOB

MS SQL Server/SQL Azure

IMAGE

Oracle

BLOB
LONG RAW

Oracle 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
	Oracle CLOB LONG VARCHAR2 (recommended in place of VARCHAR)
	Sybase
	Teradata LONG VARCHAR
	All Platforms CHAR VARCHAR *Oracle recommends VARCHAR2, Teradata recommends LONG VARCHAR

Oracle Source Datatype	Supported Targets
CLOB	IBM i CLOB DBCLOB (Unicode)
	MS SQL Server/SQL Azure TEXT
	Oracle CHAR CLOB LONG VARCHAR VARCHAR2
	Teradata LONG VARCHAR

Oracle Source Datatype	Supported Targets
DATE	DB2 (includes IBM i and UDB) DATE TIME. Date is truncated.
	Informix DATE DATETIME. Ideal mapping is to DATETIME (YEAR TO DAY). For other target columns, data is padded or truncated to fit the target.
	MS SQL Server/SQL Azure DATE DATETIME. Fractions of a second are zero. DATETIME2(P) DATETIMEOFFSET(P) SMALLDATETIME. Seconds are truncated. TIME. Date is truncated. TIME(P). Date is truncated.
	Oracle DATE VARCHAR2 (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF.
	PostgreSQL DATE TIMESTAMP
	Sybase DATETIME. Fractions of a second are zero. SMALLDATETIME. Seconds are truncated.
	Teradata DATE LONG VARCHAR (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF. TIME. Date is truncated. TIME(P). Date is truncated.
	All Platforms CHAR VARCHAR* (L), where L >= 20. Format of target value is YYYYMMDDHHMMSSFFFFFF. *Oracle recommends VARCHAR2, Teradata recommends LONG VARCHAR)

Oracle 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.
	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER MONEY REAL SMALLINT
DECIMAL	Sybase BIT. Connect CDC 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 (L), where L >= p+2 NUMBER NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	All Platforms ( CHAR (L), where L >= p+2. VARCHAR (L), where L >= p+2. Note: For all the above, if tp < p, or ts < s, Connect CDC Director issues a warning.

Oracle 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 DOUBLE PRECISION
	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.

Oracle 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 (p,s) DOUBLE-PRECISION INTEGER REAL SMALLINT
	Sybase DECIMAL (p,s) DOUBLE-PRECISION FLOAT INTEGER REAL
FLOAT	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.

Oracle 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). Connect CDC Director warns. NUMBER(38) VARCHAR2 (L), where L>= 11.
	PostgreSQL BIGINT DECIMAL (p,s) DOUBLE-PRECISION INTEGER REAL SMALLINT
	Sybase DATETIME—Time generated as all zero's. INTEGER SMALLINT TINYINT
INTEGER	Teradata BIGINT BYTEINT DECIMAL FLOAT INTEGER LONG VARCHAR (L), where L>= 11. NUMBER SMALLINT
All Platforms CHAR (L), where L>= 11. VARCHAR (L), where L>= 11.

Oracle Source Datatype	Supported Targets
LONG	DB2 (includes IBM i and UDB)
	MS SQL Server/SQL Azure TEXT
	Oracle CHAR CLOB LONG VARCHAR VARCHAR2
	Teradata LONG VARCHAR

Oracle Source Datatype	Supported Targets
LONG RAW	DB2 (includes IBM i and UDB)
	MS SQL Server/SQL Azure BINARY (Director allows mapping, but you will get validation errors) IMAGE VARBINARY (Director allows mapping, but you will get validation errors) VARBINARY (MAX)
	Oracle BLOB IMAGE LONG RAW RAW (Director allows mapping, but you will get validation errors)

Oracle Source Datatype

Supported Targets

LONG RAW

DB2 (includes IBM i and UDB)

MS SQL Server/SQL Azure

BINARY (Director allows mapping, but you will get validation errors)
IMAGE
VARBINARY (Director allows mapping, but you will get validation errors)
VARBINARY (MAX)

Oracle

BLOB
IMAGE
LONG RAW
RAW (Director allows mapping, but you will get validation errors)

Oracle Source Datatype	Supported Targets
NCHAR	DB2 (includes IBM i and UDB) CHAR (Unicode) ^a DBCLOB ((Unicode 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 NCHAR NVARCHAR
	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.

Oracle Source Datatype	Supported Targets
NCLOB	IBM i CLOB DBCLOB (Unicode)
	Oracle NCLOB

Oracle Source Datatype

Supported Targets

NCLOB

IBM i

CLOB
DBCLOB (Unicode)

Oracle

NCLOB

Oracle Source Datatype	Supported Targets
NUMBER	DB2 (includes IBM i and UDB) BIGINT DECIMAL (p,s) DOUBLE FLOAT INTEGER. Connect CDC Director warns. NUMERIC (p,s) SMALLINT. Connect CDC Director warns.
	Informix DECIMAL (p,s) DOUBLE 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) DOUBLE FLOAT INTEGER. Connect CDC Director warns. MONEY (assumed tp = 19, ts = 4) NUMERIC (p,s) REAL 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.

NUMBER	PostgreSQL BIGINT DECIMAL DOUBLE PRECISION INTEGER MONEY REAL SMALLINT
	Sybase BIT. Connect CDC Director warns. DECIMAL (p,s) DOUBLE 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) DOUBLE INTEGER. Connect CDC Director warns. LONG VARCHAR NUMBER NUMERIC (p,s) REAL SMALLINT. Connect CDC Director warns.
	All Platforms CHAR (L), where L >= p+2. VARCHAR (L)*, where L >= p+2.

Oracle Source Datatype	Supported Targets
NUMERIC	Functionally equivalent to DECIMAL. See DECIMAL .

Oracle Source Datatype	Supported Targets
NVARCHAR2	DB2 (includes IBM i and UDB) CHAR (Unicode) DBCLOB ((Unicode IBM i only) GRAPHIC (Unicode) VARCHAR VARGRAPHIC (Unicode)
	Oracle NVARCHAR2
	Teradata CHAR VARCHAR LONG VARCHAR

Oracle Source Datatype

Supported Targets

NVARCHAR2

DB2 (includes IBM i and UDB)

CHAR (Unicode)
DBCLOB ((Unicode IBM i only)
GRAPHIC (Unicode)
VARCHAR
VARGRAPHIC (Unicode)

Oracle

NVARCHAR2

Teradata

CHAR
VARCHAR
LONG VARCHAR

Oracle Source Datatype	Supported Targets
RAW	DB2 (includes IBM i and UDB) BLOB (IBM i only) CHAR FOR BIT (treat as binary) VARCHAR FOR BIT DATA (treat as binary)
	Informix
	MS SQL Server/SQL Azure BINARY IMAGE VARBINARY VARBINARY (MAX)
	Oracle BLOB LONG RAW RAW
	Sybase BINARY IMAGE VARBINARY

Oracle 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 DECIMAL (p,s) DOUBLE-PRECISION INTEGER REAL
	Sybase BIGINT 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.

Oracle Source Datatype	Supported Targets
SDO_GEOMETRY	MS SQL Server/SQL Azure GEOMETRY,GEOGRAPHY

Oracle Source Datatype

Supported Targets

SDO_GEOMETRY

MS SQL Server/SQL Azure

GEOMETRY,GEOGRAPHY

Oracle Source Datatype	Supported Targets
ST_GEOMETRY	MS SQL Server/SQL Azure GEOMETRY,GEOGRAPHY

Oracle Source Datatype

Supported Targets

ST_GEOMETRY

MS SQL Server/SQL Azure

GEOMETRY,GEOGRAPHY

Oracle datatype support - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide