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