Oracle Source | Flat File Target | Microsoft SQL Server Target | MySQL Target | Oracle Target |
|---|---|---|---|---|
Bfile | Not supported. | Not supported. | Not supported. | Not supported. |
Binary_double | Number | Float | Double | Number |
Blob | Not supported. | Image | Blob | Not supported. |
Char | Nstring | Char | Char if precision is 255 or less. Text if precision is greater than 255. | Char |
Clob | Nstring | Text | Text | Not supported. |
Date | Datetime | Datetime | Datetime | Date |
Dec | Number | Decimal | Decimal | Number |
Decimal | Number | Decimal | Decimal | Number |
Double Precision | Number | Float | Double | Number |
Float | Number | Float | Double | Number |
Int | Number | Decimal | Decimal | Number |
Integer | Number | Decimal | Decimal | Number |
Interval Day To Second | Not supported. | Not supported. | Not supported. | Not supported. |
Interval Year To Month | Not supported. | Not supported. | Not supported. | Not supported. |
Long | Nstring | Text | Text | Clob |
Long Raw | Not supported. | Not supported. | Not supported. | Not supported. |
Nchar | Nstring | Nchar | Char if precision is 255 or less. Text if precision is greater than 255. | Nchar |
Nclob | Nstring | Ntext | Text | Not supported. |
Number(p,s) | Number | Decimal | Decimal | Number |
Number[(p)] | Number | Float | Float | Number |
Numeric | Number | Float | Float | Number |
Nvarchar2 | Nstring | Nvarchar | Varchar if precision is 255 or less. Text if precision is greater than 255. | Nvarchar2 |
Raw | Not supported. | Varbinary | Varbinary | Not supported. |
Real | Number | Float | Double | Number |
Rowid | Nstring | Varchar(18) | Varchar(18) | Varchar2(18) |
Smallint | Number | Decimal | Decimal | Number |
Timestamp | Datetime | Datetime | Datetime | Date |
Timestamp With Local Time Zone | Not supported. | Not supported. | Not supported. | Not supported. |
Timestamp With Time Zone | Not supported. | Not supported. | Not supported. | Not supported. |
Urowid | Not supported. | Not supported. | Not supported. | Not supported. |
Varchar2 | Nstring | Varchar | Varchar if precision is 255 or less. Text if precision is greater than 255. | Varchar2 |