Move Oracle DB data anywhere it matters.

Replicate Oracle DB data to the warehouse or AI app you use.

Sync Oracle DB free Read the docs

Source

Oracle DB

Snowflake
BigQuery
Postgres
Databricks
Claude

Destinations: 50+
Enterprise support: 0.5.8

Overview

What is the Airbyte Oracle DB connector?

The Airbyte Oracle DB connector extracts data from Oracle DB and loads it into 50+ destinations such as Snowflake, BigQuery, Databricks or Postgres, with full refresh and incremental sync. It publishes tables and events you can select per connection.

01
Sync to your warehouse
Land Oracle DB data in 50+ destinations on a schedule you control.
02
Incremental syncs
Pull only the records that changed since the last run instead of reloading everything.
03
One authorization
Authenticate Oracle DB once and Airbyte keeps every scheduled sync running on it.
04
Cloud or self-hosted
Run the Oracle DB connector on Cloud, OSS, Hybrid.

Setup

Live in nine steps

Open the Airbyte platform and navigate to the "Sources" tab on the left-hand side of the screen.
Click on the "Oracle DB" source connector and select "Create new connection".
Enter a name for your connection and click "Next".
In the "Connection Configuration" section, enter the following information: - Host: the hostname or IP address of your Oracle DB server - Port: the port number used to connect to your Oracle DB server - Database: the name of the database you want to connect to - Username: your Oracle DB username - Password: your Oracle DB password
Click "Test connection" to ensure that the connection is successful.
If the connection is successful, click "Next" to proceed to the "Schema Selection" section.
In the "Schema Selection" section, select the schema(s) you want to replicate data from.
Click "Create connection" to save your connection settings.
You can now create a new Oracle DB source in Airbyte and start replicating data from your Oracle DB database.

Configuration fields

Oracle DB configuration fields
Field	Type	Description
host*	string	Hostname of the database.
port*	integer	Port of the database. Oracle Corporations recommends the following port numbers: 1521 - Default listening port for client connections to the listener. 2484 - Recommended and officially registered listening port for client connections to the listener using TCP/IP with SSL
username*	string	The username which is used to access the database.
connection_data	object	Connect data that will be used for DB connection
encryption	object	The encryption method with 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.
schemas	array	The list of schemas to sync from. Defaults to user. Case sensitive.

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.

Cloud
OSS
Hybrid

Your environment

DataConnectorsCredentialsKeys

↕ metadata only

Airbyte control plane

OrchestrationMonitoringUI

FAQ

Oracle DB connector questions

What data can I sync from Oracle DB with Airbyte?

The Oracle DB connector syncs the tables and events published in Airbyte docs.

Does the Oracle DB connector support incremental sync?

Yes. The Oracle DB connector supports incremental sync on selected streams, and full refresh on every stream.

Where can I run the Oracle DB connector?

Run the Oracle DB connector on Cloud, OSS, Hybrid. Hybrid deployments keep the data plane in your environment while the control plane orchestrates syncs.

Didn't find your answer? Talk to sales