PostgreSQL - 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 PostgreSQL datatype support for source and target.

Connect CDC supports data movement to the majority of datatypes in the PostgreSQL platform. The PostgreSQL datatypes together with their possible source datatypes for each database platform are shown in the tables below.

PostgreSQL Unicode datatypes, such as NCHAR, NVARCHAR and NTEXT, are only supported if the underlying database is installed with UTF8 encoding. Connect CDC does not support CLOB and BLOB PostgreSQL datatypes. However, large objects from source platforms can be mapped to the BYTEA, TEXT and NTEXT datatypes. The load option in Copy and Synchronization requests cannot be used with large objects.

PostgreSQL Source Datatype

Supported Targets

BIGINT

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

Oracle

  • DECIMAL

  • FLOAT

  • NUMBER (38)

  • NUMBER (p,s)

All platforms

  • CHAR (L)

  • VARCHAR (L)

if L <= 18, Connect CDC Director warns.

*Oracle recommends VARCHAR2.

 

PostgreSQL Target-only Datatype

Supported Sources

BOOLEAN

MS SQL Server

  • BIT

PostgreSQL Source Datatype

Supported Targets

BYTEA

Db2 (includes IBM i)

  • BLOB CHAR FOR BIT

MS SQL Server

  • BINARY

  • VARBINARY

Oracle

  • BLOB

PostgreSQL Source Datatype

Supported Targets

CHAR

Db2 (includes IBM i and UDB)

  • BIGINT

  • CHAR

  • DATE

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIME

  • TIMESTAMP

  • VARCHAR

MS SQL Server

  • BIGINT

  • BIT

  • CHAR

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLDATETIME

  • SMALLINT

  • SMALLMONEY

  • TIME

  • TIME(P)

  • TINYINT

  • VARCHAR

  • VARCHAR (MAX)

Oracle

  • CHAR

  • CLOB

  • DATE

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • LONG

  • LONG RAW

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

  • TIMESTAMP

  • TIMESTAMP(P)

  • VARCHAR

  • VARCHAR2

PostgreSQL Source Datatype

Supported Targets

DATE

Db2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

MS SQL Server

  • DATE

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

Oracle

  • DATE

  • TIMESTAMP

PostgreSQL Source Datatype

Supported Targets

DECIMAL

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • NUMERIC (p,s)

  • SMALLINT

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC (p,s)

  • SMALLINT

  • SMALLMONEY

  • TINYINT

Oracle

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMBER (p,s)

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

PostgreSQL Source Datatype

Supported Targets

DOUBLE PRECISION

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • REAL

MS SQL Server

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

  • SMALLMONEY

Oracle

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

PostgreSQL Source Datatype

Supported Targets

INTEGER

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • SMALLINT

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

Oracle

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

 

PostgreSQL Source Datatype

Supported Targets

MONEY

Db2 (includes IBM i and UDB)

  • DECIMAL (p,s)

  • NUMERIC

MS SQL Server

  • MONEY

  • NUMERIC

  • SMALL MONEY

Oracle

  • DECIMAL

  • NUMERIC

  • NUMBER

  • NUMBER (p,s)

PostgreSQL Source Datatype

Supported Targets

NUMERIC

  • Functionally equivalent to DECIMAL. See DECIMAL .

PostgreSQL Source Datatype

Supported Targets

REAL

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • REAL

MS SQL Server

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

Oracle

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

  • REAL

PostgreSQL Source Datatype

Supported Targets

SMALLINT

Db2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

Oracle

  • DECIMAL

  • FLOAT

  • INT

  • NUMBER

  • NUMBER (p,s)

 

PostgreSQL Source Datatype

Supported Targets

TEXT

MS SQL Server

  • TEXT

 

PostgreSQL Source Datatype

Supported Targets

TIME

Db2 (includes IBM i and UDB)

  • TIME

  • TIMESTAMP

MS SQL Server

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

Oracle

  • TIMESTAMP

  • TIMESTAMP (P)

PostgreSQL Source Datatype

Supported Targets

TIMESTAMP

Db2 (includes IBM i and UDB)

  • DATE

  • TIME

  • TIMESTAMP

MS SQL Server

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

Oracle

  • DATE

  • TIMESTAMP

  • TIMESTAMP (P)

PostgreSQL Source Datatype

Supported Targets

VARCHAR

  • Functionally equivalent to CHAR. See CHAR .