The following tables show the Oracle (as source) datatype support.
Oracle Source Datatype |
Supported Targets |
---|---|
BLOB |
IBM i
|
MS SQL Server/SQL Azure
|
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
CHAR |
IBM i
UDB
|
MS SQL Server/SQL Azure | |
Oracle
|
|
All Platforms
*Oracle recommends VARCHAR2, Teradata recommends LONG VARCHAR |
Oracle Source Datatype |
Supported Targets |
---|---|
CLOB |
IBM i
|
MS SQL Server/SQL Azure
|
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
DATE |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms
Format of target value is YYYYMMDDHHMMSSFFFFFF. *Oracle recommends VARCHAR2, Teradata recommends LONG VARCHAR) |
Oracle Source Datatype |
Supported Targets |
---|---|
DECIMAL |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms (
|
Oracle Source Datatype |
Supported Targets |
---|---|
DOUBLE PRECISION |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms
|
Oracle Source Datatype |
Supported Targets |
---|---|
FLOAT |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms
|
Oracle Source Datatype |
Supported Targets |
---|---|
INTEGER |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms
|
Oracle Source Datatype |
Supported Targets |
---|---|
LONG |
Db2 (includes IBM i and UDB) |
MS SQL Server/SQL Azure
|
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
LONG RAW |
Db2 (includes IBM i and UDB) |
MS SQL Server/SQL Azure
|
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
NCHAR |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
aOnly if defined in a Unicode database. NCHAR/NVARCHAR columns cannot be mapped to ordinary CHAR/VARCHAR columns. bIf tagged with a CCSID that supports a conversion to Unicode. |
Oracle Source Datatype |
Supported Targets |
---|---|
NCLOB |
IBM i
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
NUMBER |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
NUMBER |
PostgreSQL
|
All Platforms
|
Oracle Source Datatype |
Supported Targets |
---|---|
NUMERIC |
Functionally equivalent to DECIMAL. See DECIMAL . |
Oracle Source Datatype |
Supported Targets |
---|---|
NVARCHAR2 |
Db2 (includes IBM i and UDB)
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
RAW |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
Oracle Source Datatype |
Supported Targets |
---|---|
REAL |
Db2 (includes IBM i and UDB)
|
MS SQL Server/SQL Azure
|
|
Oracle
|
|
PostgreSQL
|
|
All Platforms
|
Oracle Source Datatype |
Supported Targets |
---|---|
SDO_GEOMETRY |
MS SQL Server/SQL Azure
|
Oracle Source Datatype |
Supported Targets |
---|---|
ST_GEOMETRY |
MS SQL Server/SQL Azure
|