Oracle 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 Oracle (as source) datatype support.

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

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

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

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

ST_GEOMETRY

MS SQL Server/SQL Azure

  • GEOMETRY,GEOGRAPHY