Oracle datatype mapping
Type mapping
Oracle data types are matched with Data Integration data types while extracting your data. If a data type is not supported, it is mapped as a String type.
The following table shows the mapping of Oracle data types to Data Integration-compatible types:
| Oracle Type | Data Integration Type |
|---|---|
| BLOB | STRING |
| DATE | TIMESTAMP |
| TIMESTAMP | TIMESTAMP |
| VARCHAR | STRING |
| NVARCHAR | STRING |
| CHAR | STRING |
| FLOAT | FLOAT |
| CLOB | STRING |
| DOUBLE_PRECISION | FLOAT |
| INTERVAL | TIMESTAMP |
| LONG | INTEGER |
| NCLOB | STRING |
| NUMBER | FLOAT |
| RAW | STRING |
| ROWID | INTEGER |
| VARCHAR2 | STRING |
| NVARCHAR2 | STRING |
Unsupported data types
| Source data type | Target |
|---|---|
| ANYDATA | All |
| VARRAY | All |
| NESTED TABLE | All |
| URITYPE | All |
