The following table identifies the recommended data-type mappings for Database Ingestion and Replication configurations with an Oracle source and a Salesforce Data 360 target:
Oracle Source Data Type
Salesforce Data 360 Target Data Type
CHAR
Text
VARCHAR2
Text
NCHAR
Text
NVARCHAR2
Text
NUMBER
Text
NUMBER(*,s)
Text
NUMBER(p,s)
Text
FLOAT
Text
INTEGER
Text
BINARY_FLOAT
Number
BINARY_DOUBLE
Number
DATE
DateTime
ROWID
Text
RAW
Text
Note: If necessary, you can create custom data-type mappings when you define a database ingestion and replication task. For more information, see "Data Type Rules" in Configure a Salesforce Data 360 target.