Oracle datatype support - aws_mainframe_modernization_service - connect_cdc_mimix_share - Latest

AWS Mainframe Modernization - Data Replication for IBM i

Product type
Software
Portfolio
Integrate
Product family
Connect
Product
AWS Mainframe Modernization > AWS Mainframe Modernization Service
Version
Latest
Language
English
Product name
AWS Mainframe Modernization
Title
AWS Mainframe Modernization - Data Replication for IBM i
Copyright
2024
First publish date
2003
Last updated
2024-02-01
Published on
2024-02-01T23:02:31.099696

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)

MS SQL Server/SQL Azure

Oracle

  • CLOB

  • LONG

  • VARCHAR2 (recommended in place of 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

 

Oracle Source Datatype

Supported Targets

DATE

Db2 (includes IBM i and UDB)

  • DATE

  • TIME. Date is truncated.

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

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.

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

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

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

  • DOUBLE PRECISION

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

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

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

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

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

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

MS SQL Server/SQL Azure

  • NCHAR

  • NTEXT

  • NVARCHAR a

Oracle

  • NCHAR

  • NVARCHAR2

PostgreSQL

  • NCHAR

  • NVARCHAR

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.

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

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

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)

MS SQL Server/SQL Azure

  • BINARY

  • IMAGE

  • VARBINARY

  • VARBINARY (MAX)

Oracle

  • BLOB

  • LONG RAW

  • RAW

Oracle Source Datatype

Supported Targets

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

  • DECIMAL (p,s)

  • DOUBLE-PRECISION

  • INTEGER

  • 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