Oracle Beta

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
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	We convert BOOLEAN values to NUMBER (`0` and `1`).
SHORT	NUMBER
INT	NUMBER
LONG	NUMBER
BIGDECIMAL	BINARY DOUBLE, DECIMAL, or STRING	Fivetran maps BIGDECIMAL to a destination data type based on the column precision and scale. For more information about BIGDECIMAL data type mapping and transformation, see our How Does Fivetran Handle BIGDECIMAL Data? article.
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	CLOB
BINARY	BLOB	We do not support the BINARY data type for primary keys.

Tablespace requirements for the staging schema

Fivetran creates a staging schema/user named _FIVETRAN_STAGING to stage the data. Objects in this staging schema are cleaned up after each sync. When this schema is created, no tablespace is explicitly specified, which means Oracle assigns a tablespace using the Fivetran user's default tablespace.

To ensure proper operation, make sure the default tablespace of the Fivetran user has sufficient space. See our setup guide for details on how to configure the default tablespace.

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:

Thanks for your feedback!

Was this page helpful?

YesNo

On this page