Advanced Analytica Advanced Analytica: IBOM
← All connectors
Oracle DB logo

Source connector

Oracle DB

Set up Oracle DB as a source and move its data into your chosen destination.

Version 0.5.8 community alpha

Oracle DB

Features

FeatureSupportedNotes
Full Refresh SyncYes
Incremental - Append SyncYes
Replicate Incremental DeletesNo
Logical Replication (WAL)No
TLS SupportYes
SSH Tunnel ConnectionYes
LogMinerNo
FlashbackNo
NamespacesYesEnabled by default

The Oracle source keeps your database schema unchanged. However, the connected destination may alter it. See the destination’s documentation for details.

Prerequisites

  1. Oracle Database 11g or above (tested with Oracle 11g, 12c, 18c, 19c, and 21c)
  2. Allow Airbyte to connect to your Oracle database if they’re in separate VPCs
  3. Create a dedicated read-only Airbyte user with access to every table required for replication

Setup guide

Step 1: Confirm database access from the machine running Airbyte

Access depends on your network setup. Use the check connection tool in the UI to verify Airbyte can connect to your Oracle instance.

This optional step gives you better permission control and auditing. Alternatively, you can use an existing database user with Airbyte.

Run these commands against your database to create a dedicated user:

CREATE USER airbyte IDENTIFIED BY <your_password_here>;
GRANT CREATE SESSION TO airbyte;

Next, grant the user read-only access to the relevant tables. The simplest approach grants read access to every table in the schema:

GRANT SELECT ANY TABLE TO airbyte;

Alternatively, grant access more precisely:

GRANT SELECT ON "<schema_a>"."<table_1>" TO airbyte;
GRANT SELECT ON "<schema_b>"."<table_2>" TO airbyte;

Your database user is now ready to use with Airbyte.

Step 3: Configure the connection type and schemas

Connection Type: Choose Service Name or System ID (SID):

  • Service Name: Recommended for modern Oracle installations (Oracle 8i and later). A service name logically represents a database and supports connection load balancing and failover.
  • System ID (SID): Used for legacy Oracle instances. A SID uniquely identifies a specific Oracle database instance on a server.

Schemas: Specify the schemas Airbyte should sync from. Schema names are case sensitive. If empty, this defaults to the uppercase username. Airbyte won’t discover tables if the user can’t access the configured schemas.

Step 4: Add JDBC configuration (optional)

Add JDBC URL parameters in the JDBC URL Params field to customise connection behaviour. Format parameters as key=value pairs, separated by &. For example:

defaultRowPrefetch=20&oracle.net.CONNECT_TIMEOUT=10000&oracle.net.READ_TIMEOUT=30000

Common parameters:

  • defaultRowPrefetch: Number of rows to prefetch (default: 10)
  • oracle.net.CONNECT_TIMEOUT: Connection timeout in milliseconds
  • oracle.net.READ_TIMEOUT: Socket read timeout in milliseconds

Connect through an SSH tunnel

Airbyte can connect to an Oracle instance through an SSH tunnel. This helps when the database isn’t directly accessible from the public internet. For example, it may lack a public IP address, or your security policy may restrict direct connections.

With an SSH tunnel, Airbyte connects to an intermediate server, known as a bastion server. The bastion has direct database access. Airbyte connects to the bastion, which then connects directly to the database.

Configure an SSH tunnel as follows:

  1. Configure every source field as usual, except SSH Tunnel Method.
  2. SSH Tunnel Method defaults to No Tunnel, which means a direct connection. For an SSH tunnel, choose SSH Key Authentication or Password Authentication.
    1. Choose Key Authentication to use an RSA private key for the SSH tunnel. See below for key generation guidance.
    2. Choose Password Authentication to use a password for the SSH tunnel.
  3. SSH Tunnel Jump Server Host is the bastion server’s hostname or IP address.
  4. SSH Connection Port is the bastion server port for the SSH connection. The default SSH port is 22.
  5. SSH Login Username is the username Airbyte uses to connect to the bastion server. This isn’t the Oracle database username.
  6. If you’re using Password Authentication, set Password to the bastion server OS user’s password. If you’re using SSH Key Authentication, leave this blank.
  7. If you’re using SSH Key Authentication, set SSH Private Key to the RSA private key for the SSH connection. Provide the key file’s full contents, starting with -----BEGIN RSA PRIVATE KEY----- and ending with -----END RSA PRIVATE KEY-----.

Generate an SSH key pair

The connector requires an RSA key in PEM format. Generate this key as follows:

ssh-keygen -t rsa -m PEM -f myuser_rsa

This creates a PEM-formatted private key and a standard-format public key. The public key uses the format required by the authorized_keys file on your bastion host. Add it to the bastion host for the user Airbyte will connect as. Copy the private key into the Airbyte connector configuration.

Data type mapping

When synchronising data, Oracle data types map to the following data types.

Note: The connector automatically handles LONG and LONG RAW columns by setting the Oracle JDBC property oracle.jdbc.useFetchSizeWithLongColumn=true. For new applications, Oracle recommends LOB types (CLOB, BLOB) instead of LONG and LONG RAW columns.

Oracle TypeResulting TypeNotes
binary_doublenumber
binary_floatnumber
blobstring
charstring
char(3 char)string
clobstring
datestring
decimalnumber
floatnumber
float(5)number
integernumber
interval year to monthstring
long rawstring
numbernumber
number(6, 2)number
nvarchar(3)string
rawstring
timestampstring
timestamp with local time zonestring
timestamp with time zonestring
varchar2string
varchar2(256)string
xmltypestring

Any type not listed is coerced into a string. You can provide feedback on your preferred mappings.

Encryption options

The connector supports three encryption methods. Airbyte Cloud requires encryption, using either Native Network Encryption or TLS. Self-Managed Airbyte supports all three options.

  1. Unencrypted (Self-Managed only): The connection uses the TCP protocol without encryption. All data travels as plain text. Only choose this option in secure, trusted network environments.

  2. Native Network Encryption (NNE): Encrypts the database connection without TLS configuration or separate ports. The connector sets SQLNET.ENCRYPTION_CLIENT=REQUIRED, so it accepts only encrypted traffic. Choose from these encryption algorithms:

    • AES256: Advanced Encryption Standard with 256-bit keys (recommended)
    • RC4_56: RC4 stream cipher with 56-bit keys (legacy, less secure)
    • 3DES168: Triple DES with 168-bit keys (legacy, less secure)
  3. TLS Encrypted (verify certificate): Uses the TLS protocol with certificate verification for maximum security. Provide the server’s SSL certificate in PEM format in the SSL PEM file field. The certificate must be valid and trusted.

IP allow list

If you use Airbyte Cloud and your organisation restricts access to specific IPs, add the Airbyte Cloud IP addresses to your allow list.

Changelog

Expand to review
VersionDatePull RequestSubject
0.5.82026-03-2575410Fold strict-encrypt variant into main connector; encryption is now required on Airbyte Cloud
0.5.72025-07-1563326Fix publishing flow.
0.5.62025-07-1062920Convert to new gradle build flow
0.5.52025-07-1062921Convert to new gradle build flow
0.5.32024-12-1849883Use a base image: airbyte/java-connector-base:1.0.0
0.5.22024-02-1335225Adopt CDK 0.20.4
0.5.12024-01-2434453bump CDK version
0.5.02023-12-1833485Remove LEGACY state
0.4.02023-06-2627737License Update: Elv2
0.3.252023-06-2027212Fix silent exception swallowing in StreamingJdbcDatabase
0.3.242023-03-2220760Removed redundant date-time datatypes formatting
0.3.232023-03-0623455For network isolation, source connector accepts a list of hosts it is allowed to connect to
0.3.222022-12-1420346Consolidate date/time values mapping for JDBC sources
2022-10-1315535Update incremental query to avoid data missing when new data is inserted at the same time as a sync starts under non-CDC incremental mode
0.3.212022-09-0116238Emit state messages more frequently
0.3.202022-08-1814356DB Sources: only show a table can sync incrementally if at least one column can be used as a cursor field
0.3.192022-08-0314953Use Service Name to connect to database
0.3.182022-07-1414574Removed additionalProperties:false from JDBC source connectors
0.3.172022-06-2414092Introduced a custom jdbc param field
0.3.162022-06-2213997Fixed tests
0.3.152022-04-2912480Query tables with adaptive fetch size to optimize JDBC memory consumption
0.3.142022-02-2110242Fixed cursor for old connectors that use non-microsecond format. Now connectors work with both formats
0.3.132022-02-1810242Updated timestamp transformation with microseconds
0.3.122022-02-1410256Add -XX:+ExitOnOutOfMemoryError JVM option
0.3.112021-12-248958Add support for JdbcType.ARRAY
0.3.102021-12-078582Update connector fields title/description
0.3.92021-12-018371Fixed incorrect handling “\n” in ssh key
0.3.82021-10-137125Fix incorrect handling of LONG RAW data type
0.3.72021-10-016616Added network encryption options
0.3.62021-09-306585Improved SSH Tunnel key generation steps
0.3.52021-09-226356Added option to connect to DB via SSH.
0.3.42021-09-016038Remove automatic filtering of system schemas.
0.3.32021-09-015779Ability to only discover certain schemas.
0.3.22021-08-134699Added json config validator.
Advanced Analytica

Most businesses are sitting on information they can’t use at speed. The people who hold it are busy, and when they leave, the knowledge goes with them. The documents are static, and the processes around them weren’t designed for AI.

Advanced Analytica works with these businesses to turn that information into structured data assets. Once they're integrated, AI systems can govern it, and the business can use it. We bring in the strategy, the specification and the AI skills to rework how the business operates.

MOVE FAST. STAY SAFE.