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.
Fivetran Oracle solutions
Fivetran offers various solutions for capturing changes from databases, which are broadly categorized under the following deployment models - SaaS, Hybrid, and Self-hosted. For more information about these deployment models, see our Architecture documentation.
SaaS
In the SaaS model, the data processing is handled entirely within Fivetran's cloud. This model is ideal for organizations looking for a hands-off approach to data processing, allowing them to leverage Fivetran's cloud and expertise with minimal internal resource investment.
Fivetran offers the following solutions for capturing changes from Oracle using the SaaS deployment model:
Oracle connector with the following capture or sync methods:
High-Volume Agent (HVA) Oracle connector with the following capture or sync methods:
Hybrid
The Hybrid model allows organizations to process data locally within their own network while leveraging Fivetran's cloud for orchestrating and configuring all the data movement.
Fivetran offers the following solutions for capturing changes from Oracle using the hybrid deployment model:
Oracle connector with the following capture or sync methods:
High-Volume Agent (HVA) Oracle connector with the following capture or sync methods:
Self-hosted
The Self-hosted model allows organizations to run Fivetran technology (HVR) on their own servers, and the data processing is handled entirely within their network. The self-hosted model provides organizations with complete control over orchestration, configuration, credential management, and code deployment.
Fivetran offers the following solution for capturing changes from Oracle using the self-hosted deployment model:
- HVR - Oracle with the following capture or sync methods:
Supported configurations
This section highlights key differences between the supportability categories of SaaS, Hybrid, and Self-hosted deployment models.
| SUPPORTABILITY CATEGORY | SAAS | HYBRID | SELF-HOSTED |
|---|---|---|---|
| Capture or sync method | Oracle connector: Teleport and LogMiner HVA Oracle connector: Direct Capture and Archive Log Only | Oracle connector: Teleport and LogMiner HVA Oracle connector: Direct Capture and Archive Log Only | Direct Redo, Archive Log Only, BFile, and LogMiner |
| Security | Data is sent through the Fivetran cloud. | Data is processed locally. Only metadata (MAR information) and logs are sent to Fivetran. | All data is processed locally. |
| Connection options | Direct, Private Networking, SSH Tunnel, Reverse SSH Tunnel, and Proxy Agent | Direct, Private Networking, SSH Tunnel, Reverse SSH Tunnel, and Proxy Agent | Direct |
| Sum of replicated table size | Oracle connector: 1TB HVA Oracle connector: 5TB | Oracle connector: 1TB HVA Oracle connector: 5TB | Unlimited |
| Minimum sync interval | 1 minute | 1 minute | < 2 seconds |
| Minimum latency | > 1 minute | > 1 minute | < 2 seconds |
| Maximum hourly redo volume | Oracle connector: 10 GB HVA Oracle connector: 200 GB | Oracle connector: 10 GB HVA Oracle connector: 200 GB | > 500 GB |
| Database versions | 11g R2 - 21c | 11g R2 - 21c | 11g R2 - 21c |
| Encrypted data transfer | Always | Optional | Always |
| Use cases | Analytics | Analytics | Analytics and Operational |
| Pricing plan | Enterprise and Business Critical | Enterprise and Business Critical | Business Critical and Private Deployment |
Capture or sync methods
This section provides a comprehensive comparison of key supportability factors across various capture methods employed by each Fivetran solution.
Oracle connector
The following table illustrates the main differences between the capture or sync methods supported by our Oracle connector:
| SUPPORTABILITY CATEGORY | TELEPORT | LOGMINER |
|---|---|---|
| Table size uncompressed | Tables < 100 GB | Not Applicable |
| Read method | Query tables | Logs |
| Primary key | Not required | Not Required |
| LOBs | Not Supported | Not Supported |
| Source DB server configuration | Zero | Minimal |
HVA Oracle connector
The following table illustrates the main differences between the capture or 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 |
HVR Oracle
The following table illustrates the main differences between the capture or sync methods supported by Fivetran HVR:
| SUPPORTABILITY CATEGORY | DIRECT REDO | ARCHIVE LOG ONLY | BFILE | LOGMINER |
|---|---|---|---|---|
| Table size uncompressed | Not Applicable | Not Applicable | Not Applicable | Not Applicable |
| Primary key | Not Required | Not Required | Not Required | Not Required |
| LOBs | Supported | Supported | Supported | Supported |
| Source DB server configuration | Moderate | Minimal | Minimal | Minimal |
Features
Fivetran supports the following features when connecting to the Oracle database:
| Feature name | Oracle Connector | HVA Oracle Connector | HVR Oracle |
|---|---|---|---|
| Capture deletes | check | check | check |
| Custom data | check | check | check |
| Data blocking | check | check | check |
| Column hashing | check | check | |
| Re-sync | check | check | check |
| History Mode | check | check | check TimeKey |
| API configurable | check | check | check |
| Private networking | check | check | check |
Supported instance types
Fivetran supports the following Oracle instance types:
NOTE: The Oracle instance types that we can connect to depend on your database service.
| SUPPORTABILITY CATEGORY | ORACLE CONNECTOR - TELEPORT | ORACLE CONNECTOR - LOGMINER | HVA ORACLE CONNECTOR - DIRECT CAPTURE | HVA ORACLE CONNECTOR - ARCHIVE LOG ONLY | HVR - DIRECT REDO | HVR - ARCHIVE LOG ONLY | HVR - BFILE | HVR - LOGMINER |
|---|---|---|---|---|---|---|---|---|
| Generic Oracle | ||||||||
| Primary instance | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Active Data Guard standby instance | Yes | No | Yes | Yes | Yes | Yes | No | No |
| Physical standby instance | No | No | No | No | Yes | Yes | No | No |
| Real Application Cluster (RAC) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Multitenant (CDBs/PDBs) | Yes | Yes | Yes | Yes | Yes | Yes | Yes | Yes |
| Amazon RDS for Oracle | ||||||||
| Primary instance | Yes | Yes | No | No | No | No | Yes | Yes |
| Active Data Guard standby instance | Yes | No | No | Yes | No | No | No | No |
| Physical standby instance | No | No | No | No | No | No | No | No |