- Destination
- Databases
- Alpha
Connect Oracle data with any data source.
Replicate any source into Oracle without custom pipelines.
- Sources
- 590+
- Standard support
- 1.0.0
Overview
What is the Airbyte Oracle connector?
The Airbyte Oracle connector loads data from 590+ Airbyte sources into Oracle, with full refresh and incremental sync on a schedule you control.
- 01
Load from any source
Move data into Oracle from 590+ Airbyte sources on a schedule you control.
- 02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
- 03
Cloud or self-hosted
Run the Oracle connector on OSS.
Setup
Live in three steps
Confirm your Oracle destination credentials and permissions.
Configure the destination in Airbyte with the required connection settings.
Choose a source, map streams, and schedule syncs into Oracle.
Configuration fields
| Field | Type | Description |
|---|---|---|
| host* | string | The hostname of the database. |
| port* | integer | The port of the database. |
| sid* | string | The System Identifier uniquely distinguishes the instance from any other instance on the same computer. |
| username* | string | The username to access the database. This user must have CREATE USER privileges in the database. |
| encryption | object | The encryption method which is used when communicating with the database. |
| jdbc_url_params | string | Additional properties to pass to the JDBC URL string when connecting to the database formatted as 'key=value' pairs separated by the symbol '&'. (example: key1=value1&key2=value2&key3=value3). |
| password | string | The password associated with the username. |
| raw_data_schema | string | The schema to write raw tables into (default: airbyte_internal) |
Hybrid deployment
Sovereign by architecture, not by policy.
The data plane runs in your environment. Records, credentials and keys stay with you; the control plane only receives configuration and job metadata.
- OSS
Your environment
Airbyte control plane
Related connectors
FAQ
Oracle connector questions
What data can I load into Oracle with Airbyte?
Airbyte moves data from any supported source into Oracle on a schedule you control, with full refresh and incremental sync where the destination supports it.
Does the Oracle connector support incremental sync?
Yes. The Oracle destination supports full refresh and incremental sync, so Airbyte can load only the records that changed since the last sync.
Where can I run the Oracle connector?
Run the Oracle connector on OSS.
Didn't find your answer? Talk to sales
Start loading data into Oracle in minutes.
Free 14-day trial. No credit card needed.