View Source

This section covers data type conversions between the and Oracle databases.

NOTE: The listed in this page reflect the raw data type of the converted column. Depending on the contents of the column, the Transformer Page may re-infer a different data type, when a dataset using this type of source is loaded.

NOTE: Dots (.) in the names of Oracle tables or table columns are not supported.

Access/Read

Source Data Type	Supported
ANYDATA	N
ANYDATASET	N
ANYTYPE	N
BFILE	N
BINARY_DOUBLE	Y	Decimal
BINARY_FLOAT	Y	Decimal
BLOB	N
CHAR	Y	String
CLOB	Y	String
DATE	Y	Date/Time
DBURIType	Y	String
FLOAT	Y	Decimal
HTTPURIType	Y	String
INTERVAL_DAY TO SECOND	Y	String
INTERVAL_YEAR TO MONTH	Y	String
LONG RAW	Y	String (base64)
<media types>	N
NCHAR	Y	String
NCLOB	Y	String
NUMBER	Y	Decimal / Integer
NVARCHAR2	Y	Integer
RAW	Y	String (base64)
ROWID	N
SDO_GEOMETRY	N
SDO_GEORASTER	N
SDO_TOPO_GEOMETRY	N
TIMESTAMP	Y	String
TIMESTAMP WITH LOCAL TIMEZONE	Y	String
TIMESTAMP WITH TIMEZONE	Y	String
URITYPE	Y	String
UROWID	N
VARCHAR2	Y	String
XDBUIRType	Y	String
XMLType	N

NOTE: Implementation of Oracle custom types is a custom engagement. For more information, please contact .

Write/Publish

	Oracle Column Type	Notes
Bool	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Integer	INT
	INTEGER
	SMALLINT
	DECIMAL
	DEC
	NUMERIC
	NUMBER
	FLOAT
	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
String	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Datetime	TIMESTAMP
	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Timestamp	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Float	DECIMAL(38,9)	Oracle DECIMAL column type must include the scale (total number of permitted digits) and precision (total number of digits permitted to the right of the decimal) as parameters.
	DEC
	NUMERIC
	NUMBER
	FLOAT
	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Map	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.
Array	VARCHAR(256)	Oracle VARCHAR column type must include the maximum number of permitted characters.

NOTE: If you are appending to an existing table where a column's is not mapped to the column data type in the target table, a validation error is thrown, as the platform writes unmapped types as String data type.