PostgreSQL - connect_cdc_mimix_share

PostgreSQL - connect_cdc_mimix_share - Latest

Connect CDC System Reference Guide

Product type

Software

Portfolio

Integrate

Product family

Connect

Product

Connect > Connect CDC (MIMIX Share)

Version

Latest

Language

English

Product name

Connect CDC

Title

Connect CDC System Reference Guide

2024

First publish date

2003

Last edition

2024-08-20

Last publish date

2024-08-20T21:40:14.000381

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 Target-only Datatype

Supported Sources

BOOLEAN

MS SQL Server

Sybase

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 .