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:
|
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 |
|
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 enforce only the UNIQUE constraint on the primary keys.
- We do not support the following features for Oracle destinations:
- History mode
- Private networking
- Oracle multi-cloud setup
- Oracle version migrations
- Fivetran Proxy Agent