Oracle Private Preview

Oracle is an object-relational database management system created by the Oracle Corporation. Fivetran supports Oracle as a destination and enables you to sync your data from your data sources into your Oracle database.

Fivetran supports Oracle as both a database connector and a destination.

Supported implementations

Fivetran supports the following Oracle database implementations:

Supported configurations

Fivetran supports the following Oracle configurations:

Supportability Category	Supported Values
Database versions	19c or higher
Transport Layer Security (TLS)	TLS 1.2

Supported deployment models

We support the SaaS and Hybrid deployment models for all Oracle implementations.

You must have an Enterprise or Business Critical plan to use the Hybrid Deployment model.

Type transformation mapping

The data types in your Oracle database follow Fivetran's standard data type storage.

We use the following data type conversions:

Fivetran Data Type	Destination Data Type	Notes
BOOLEAN	NUMBER or BOOLEAN	We support the BOOLEAN data type only for Oracle v23 and higher. For earlier versions, we convert BOOLEAN values to NUMBER (`0` and `1`).
SHORT	NUMBER
INT	NUMBER
LONG	NUMBER
BIGDECIMAL	DECIMAL or BINARY DOUBLE	We convert BIGDECIMAL to BINARY DOUBLE only if: the column's precision exceeds `38` the column's scale exceeds `127` the column has no precision or scale defined
FLOAT	REAL
DOUBLE	BINARY DOUBLE	The DOUBLE data type supports values with exponents up to 125.
LOCALDATE	DATE
LOCALDATETIME	TIMESTAMP
INSTANT	TIMESTAMP WITH TIME ZONE	Oracle does not support the TIMESTAMP WITH TIMEZONE data type for primary keys. Therefore, we convert the data type of such primary keys to VARCHAR.
STRING	VARCHAR2	Empty strings are stored as `NULL`. For primary keys: An empty string is stored as `_FIVETRAN_EMPTY_STRING`. A null value is stored as `_FIVETRAN_NULL`.
XML	XMLTYPE
JSON	JSON or CLOB	We support the JSON data type only for Oracle v21 and higher. For earlier versions, we convert JSON to CLOB.
BINARY	BLOB	We do not support the BINARY data type for primary keys.

Setup guide

Follow our step-by-step setup guides for specific instructions on how to set up your Oracle database as a destination:

Limitations

We do not support the following features for Oracle destinations: