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.
The LogMiner method is sunset and is no longer available for new Oracle connections.
| Supportability Category | SaaS | Hybrid |
|---|---|---|
| Incremental sync method | Oracle connector: Binary Log Reader, Teleport, and LogMiner HVA Oracle connector: Direct Capture and Archive Log Only | Oracle connector: Binary Log Reader, Teleport, and LogMiner 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), 1TB (LogMiner) HVA Oracle connector: 5TB | Oracle connector: 1TB HVA Oracle connector: 5TB |
| Minimum sync interval | 1 minute | 1 minute |
| Minimum latency | > 1 minute | > 1 minute |
| Maximum hourly redo volume | Oracle connector: 200 GB (Binary Log Reader), 10 GB (LogMiner) HVA Oracle connector: 200 GB | Oracle connector: 10 GB HVA Oracle connector: 200 GB |
| Database versions | 11g R2 - 21c | 11g R2 - 21c |
| Encrypted data transfer | Always | Optional |
| Use cases | Analytics | Analytics |
| Pricing plan | Enterprise and Business Critical | Enterprise and Business Critical |
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.
The LogMiner method is sunset and is no longer available for new Oracle connections.
| Supportability Category | Binary Log Reader | Teleport | LogMiner |
|---|---|---|---|
| Table size uncompressed | Not applicable | Tables < 100 GB | Not applicable |
| Read method | Database logs/Direct log capture | Query tables | Database logs/LogMiner query |
| Primary key | Not required | Not required | Not required |
| LOBs | Supported | Not supported | Not supported |
| Source DB server configuration | Minimal | Zero | Minimal |
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.
The LogMiner method is sunset and is no longer available for new Oracle connections.
| Supportability Category | Oracle Connector - Binary Log Reader | Oracle Connector - Teleport Sync | Oracle Connector - LogMiner | HVA Oracle Connector - Direct Capture | HVA Oracle Connector - Archive Log Only |
|---|---|---|---|---|---|
| Generic Oracle | |||||
| Primary instance | Yes | Yes | Yes | Yes | Yes |
| Active Data Guard standby instance | No | Yes | No | Yes | Yes |
| Physical standby instance | No | No | No | No | No |
| Automatic Storage Management (ASM) | Yes | Yes | Yes | Yes | Yes |
| Real Application Cluster (RAC) | Yes | Yes | Yes | Yes | Yes |
| Multitenant (CDBs/PDBs) | Yes | Yes | Yes | Yes | Yes |
| Amazon RDS for Oracle | |||||
| Primary instance | Yes | Yes | Yes | No | No |
| Active Data Guard standby instance | No | Yes | No | No | Yes |
| Physical standby instance | No | No | No | No | No |