Fast loader - Connect_CDC - connect_cdc_mimix_share - 5 - 5.8

Connect CDC Advanced User 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 Advanced User Guide
Copyright
2023
First publish date
2003
ft:lastEdition
2023-09-27
ft:lastPublication
2023-09-27T18:12:55.651884

If Use load mode when possible is checked (the default) on the Copy tab of the Copy Request Properties dialog, Connect CDC applies the database’s fast loader utility when possible.

When copying data from a single source to multiple systems where all target DBMSs are not supported for fast loader, Connect CDC utilizes fast loaders for the targets with supported DBMSs and generic copy for all targets with unsupported DBMSs.

The table below lists datatypes supported for fast loaders:

MS SQL Server

Oracle

PostgreSQL

Teradata

bigint

blob

bigint

bigint

binary

char

boolean

byteint

bit

clob

bytea

char

char

date

character,

date

date

long

date

decimal(n,m) [includes numeric(n,m)]

decimal

long raw

decimal

double precision (includes float and real)

float

nchar

double precision

integer

image

number (integral numeric)

integer

long varchar

int

number (approximate numeric)

money

smallint

money

number (decimal)

nchar

time and time(n)

nchar

nvarchar2

ntext

timestamp and timestamp(n)

ntext

timestamp

numeric

varchar(n)

numeric

varchar2, character varying

nvarchar

 

nvarchar

 

real

 

real

 

smallint

 

smalldatetime

 

text

 

smallint

 

time

 

smallmoney

 

timestamp

 

text

 

 

 

tinyint

 

 

 

varbinary

 

 

 

Note: To get the PostgreSQL loader to operate properly, you must grant the owner of the tables to the replication user. Enter this command:GRANT <reptableowner> TO <rpuser>;