PostgreSQL - 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 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

 

Informix

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

 

Oracle

  • DECIMAL

  • FLOAT

  • NUMBER (38)

  • NUMBER (p,s)

BIGINT

Sybase

  • BIT

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLINT

  • SMALLMONEY

  • TINYINT

 

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

 

Sybase

  • BIT

PostgreSQL Source Datatype

Supported Targets

BYTEA

DB2 (includes IBM i)

  • BLOB CHAR FOR BIT

 

MS SQL Server

  • BINARY

  • VARBINARY

 

Oracle

  • BLOB

 

Sybase

  • BINARY

  • VARBINARY

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

 

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

  • 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

  • TINYINT

  • VARCHAR

PostgreSQL Source Datatype

Supported Targets

DATE

DB2 (includes IBM i and UDB)

  • DATE

  • TIMESTAMP

 

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

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

 

Oracle

  • DATE

  • TIMESTAMP

 

Sybase

  • DATETIME

  • SMALLDATETIME

PostgreSQL Source Datatype

Supported Targets

DECIMAL

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • NUMERIC (p,s)

  • SMALLINT

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC (p,s)

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC (p,s)

  • SMALLINT

  • SMALLMONEY

  • TINYINT

DECIMAL

Oracle

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMBER (p,s)

  • NUMBER

  • NUMERIC

  • REAL

  • SMALLINT

 

Sybase

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC (p,s)

  • SMALLINT

  • SMALLMONEY

  • TINYINT

PostgreSQL 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

  • MONEY

  • NUMERIC

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

  • SMALLMONEY

 

Oracle

  • DECIMAL

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • MONEY

  • REAL

  • SMALLMONEY

PostgreSQL Source Datatype

Supported Targets

INTEGER

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE

  • FLOAT

  • INTEGER

  • SMALLINT

 

Informix

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • MONEY

  • NUMERIC

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL (p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

 

Sybase

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • NUMERIC

  • SMALLINT

  • TINYINT

 

PostgreSQL Source Datatype

Supported Targets

MONEY

DB2 (includes IBM i and UDB)

  • DECIMAL (p,s)

  • NUMERIC

 

Informix

  • DECIMAL (p,s)

  • MONEY

  • NUMERIC

 

MS SQL Server

  • MONEY

  • NUMERIC

  • SMALL MONEY

 

Oracle

  • DECIMAL

  • NUMERIC

  • NUMBER

  • NUMBER (p,s)

 

Sybase

  • DECIMAL (p,s)

  • MONEY

  • NUMERIC

  • SMALLMONEY

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

 

Informix

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLFLOAT

 

MS SQL Server

  • BIGINT

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

 

Oracle

  • DECIMAL

  • DOUBLE

  • FLOAT

  • INTEGER

  • NUMBER

  • NUMBER (p,s)

  • REAL

 

Sybase

  • DECIMAL (p,s)

  • DOUBLE PRECISION

  • FLOAT

  • INTEGER

  • REAL

PostgreSQL Source Datatype

Supported Targets

SMALLINT

DB2 (includes IBM i and UDB)

  • BIGINT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

 

Informix

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • NUMERIC

  • REAL

  • SMALLFLOAT

  • SMALLINT

 

MS SQL Server

  • BIGINT

  • BIT

  • DECIMAL(p,s)

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

Oracle

  • DECIMAL

  • FLOAT

  • INT

  • NUMBER

  • NUMBER (p,s)

 

Sybase

  • BIT

  • DECIMAL

  • FLOAT

  • INTEGER

  • SMALLINT

  • TINYINT

 

PostgreSQL Source Datatype

Supported Targets

TEXT

MS SQL Server

  • TEXT

 

PostgreSQL Source Datatype

Supported Targets

TIME

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

PostgreSQL Source Datatype

Supported Targets

TIMESTAMP

DB2 (includes IBM i and UDB)

  • DATE

  • TIME

  • TIMESTAMP

 

Informix

  • DATE

  • DATETIME

 

MS SQL Server

  • DATETIME

  • DATETIME2(P)

  • DATETIMEOFFSET(P)

  • SMALLDATETIME

  • TIME

  • TIME(P)

 

Oracle

  • DATE

  • TIMESTAMP

  • TIMESTAMP (P)

 

Sybase

  • DATETIME

  • SMALLDATETIME

PostgreSQL Source Datatype

Supported Targets

VARCHAR

  • Functionally equivalent to CHAR. See CHAR .