Oracle
Oracle is an object-relational database management system created by the Oracle Corporation. Fivetran's integration platform replicates data from your Oracle source database and loads it into your destination.
Oracle change-capture solutions
Fivetran offers the Oracle connector and High-Volume Agent (HVA) Oracle connector for capturing changes from Oracle databases. Both connectors support the same core features, but they differ in their incremental sync methods, security, and supportability categories.
We also offer the Oracle E-Business Suite connector for replicating data from Oracle E-Business Suite applications. For more information, see our Oracle E-Business Suite documentation.
Supported configurations
This section highlights key differences between the supportability categories of SaaS and Hybrid deployment models. For more information about these deployment models, see our Deployment Models documentation.
| Supportability Category | SaaS | Hybrid |
|---|---|---|
| Incremental sync method | Oracle connector: Binary Log Reader, Fivetran Teleport Sync, and XStream Out HVA Oracle connector: Direct Capture and Archive Log Only | Oracle connector: Binary Log Reader, Fivetran Teleport Sync, and XStream Out HVA Oracle connector: Direct Capture and Archive Log Only |
| Security | Data is sent through the Fivetran cloud. | Data is processed locally. Only metadata (MAR information) and logs are sent to Fivetran. |
| Connection options | Direct, Private Networking, SSH Tunnel, Reverse SSH Tunnel, and Proxy Agent | Direct, Private Networking, SSH Tunnel, Reverse SSH Tunnel, and Proxy Agent |
| Sum of replicated table size | Oracle connector: 5TB (Binary Log Reader) HVA Oracle connector: 5TB | Oracle connector: 5TB (Binary Log Reader) HVA Oracle connector: 5TB |
| Minimum sync interval | 1 minute | 1 minute |
| Minimum latency | > 1 minute | > 1 minute |
| Maximum hourly redo volume1 | Oracle connector — Binary Log Reader:
| Oracle connector — Binary Log Reader: typically 290 GB/hour, up to 780 GB/hour HVA Oracle connector: 200 GB |
| Database versions | Binary Log Reader, Fivetran Teleport Sync, and XStream Out: 11g R2 - 26ai All other methods: 11g R2 - 21c | Binary Log Reader, Fivetran Teleport Sync, or XStream Out: 11g R2 - 26ai All other methods: 11g R2 - 21c |
| Encrypted data transfer | Always | Optional |
| Use cases | Analytics | Analytics |
| Pricing plan | Enterprise and Business Critical | Enterprise and Business Critical |
1Maximum hourly redo volume is the rate at which we read redo logs from your database when it syncs a backlog of 1 GB or more. For each deployment option and connection method, “typically” indicates the median rate observed across Oracle connections in Fivetran, and “up to” indicates the rate that the fastest 10% of those connections reach. Your throughput depends on your source database, network, and region. We don't list connection methods for which we don't yet have enough throughput measurements.
Incremental sync methods
This section provides a comprehensive comparison of key supportability factors across various incremental sync methods employed by each Fivetran solution.
Oracle connector
The following table illustrates the main differences between the incremental sync methods supported by our Oracle connector.
| Supportability Category | Binary Log Reader | Fivetran Teleport Sync |
|---|---|---|
| Table size uncompressed | Not applicable | Tables < 100 GB |
| Read method | Database logs/Direct log capture | Query tables |
| Primary key | Not required | Not required |
| LOBs | Supported | Not supported |
| Source DB server configuration | Minimal | Zero |
HVA Oracle connector
The following table illustrates the main differences between the incremental sync methods supported by our HVA Oracle connector:
| Supportability Category | Direct Capture | Archive Log Only |
|---|---|---|
| Table size uncompressed | Not applicable | Not applicable |
| Primary key | Not required | Not required |
| LOBs | Supported | Supported |
| Source DB server configuration | Moderate | Minimal |
Features
Fivetran supports the following features when connecting to the Oracle database:
| Feature Name | Oracle Connector | HVA Oracle Connector |
|---|---|---|
| Capture deletes | ||
| Custom data | ||
| Data blocking | ||
| Column hashing | ||
| Re-sync | ||
| History Mode | ||
| API configurable | ||
| Private networking |
Supported instance types
Fivetran supports the following Oracle instance types:
The Oracle instance types that we can connect to depend on your database service.
| Supportability Category | Oracle Connector - Binary Log Reader | Oracle Connector - Fivetran Teleport Sync | HVA Oracle Connector - Direct Capture | HVA Oracle Connector - Archive Log Only |
|---|---|---|---|---|
| Generic Oracle | ||||
| Primary instance | Yes | Yes | Yes | Yes |
| Active Data Guard standby instance | Yes | Yes | Yes | Yes |
| Physical standby instance | No | No | No | No |
| Automatic Storage Management (ASM) | Yes | Yes | Yes | Yes |
| Real Application Cluster (RAC) | Yes | Yes | Yes | Yes |
| Multitenant (CDBs/PDBs) | Yes | Yes | Yes | Yes |
| Amazon RDS for Oracle | ||||
| Primary instance | Yes | Yes | No | No |
| Active Data Guard standby instance | Yes | Yes | No | Yes |
| Physical standby instance | No | No | No | No |