Advanced Analytica Advanced Analytica: IBOM
← All connectors
Oracle logo

Destination connector

Oracle

Send governed data into Oracle with a clear, practical setup guide.

Version 1.0.0 community alpha

Oracle DB

Output schema

By default, Oracle outputs each stream to a separate table. Each table contains three columns:

  • _AIRBYTE_AB_ID: a UUID that Airbyte assigns to each processed event. The Oracle column type is VARCHAR(64).
  • _AIRBYTE_EMITTED_AT: a timestamp showing when the event was pulled from the data source. The Oracle column type is TIMESTAMP WITH TIME ZONE.
  • _AIRBYTE_DATA: a JSON blob containing the event data. The Oracle column type is NCLOB.

Enable normalisation to create strongly typed, normalised tables.

Supported sync modes

Sync modeSupported?
Full Refresh - OverwriteYes
Full Refresh - AppendYes
Full Refresh - Overwrite + DedupedNo
Incremental Sync - AppendYes
Incremental Sync - Append + DedupedNo

Get started (Airbyte Cloud)

The Oracle connector is currently in Alpha on Airbyte Cloud. Airbyte Cloud only supports TLS-encrypted connections to your database. Otherwise, follow the open-source instructions below.

Get started (Airbyte Open Source)

Requirements

To use the Oracle destination, you’ll need:

  • An Oracle server running version 21 or later

Network access

Make sure Airbyte can access your Oracle database. For databases within a VPC, allow access from the IP address exposing Airbyte.

Permissions

Airbyte namespaces let you store data in different schemas. Required permissions vary by scenario:

Login userDestination userRequired permissionsComment
DBA UserAny user-
Regular userSame user as loginCreate, drop and write table, create session
Regular userAny existing userCreate, drop and write ANY table, create sessionGrants can be provided on a system level by DBA or by target user directly
Regular userNot existing userCreate, drop and write ANY table, create user, create sessionGrants should be provided on a system level by DBA

Create a dedicated Airbyte user for this purpose.

Set up the Oracle destination

You now have everything needed to configure Oracle as a destination in the UI. You’ll need the following information:

  • Host
  • Port
  • Username
  • Password
  • Database
  • Connection via SSH Tunnel

Airbyte can connect to an Oracle instance through an SSH tunnel. Use this when direct database access is unavailable or conflicts with security policy. For example, the database may not have a public IP address.

An SSH tunnel connects Airbyte through an intermediate server, also called a bastion server. This server has direct database access. Airbyte connects to the bastion, which then connects directly to the database server.

This feature requires additional configuration when you create the source. The following steps explain each configuration field.

  1. Configure every source field as usual, except SSH Tunnel Method.
  2. SSH Tunnel Method defaults to No Tunnel, which creates a direct connection. For an SSH tunnel, choose SSH Key Authentication or Password Authentication.
    1. Choose Key Authentication when using an RSA private key to establish the SSH tunnel. See below for key-generation details.
    2. Choose Password Authentication when using a password to establish the SSH tunnel.
  3. SSH Tunnel Jump Server Host identifies the intermediate bastion server that Airbyte connects to. Enter a hostname or IP address.
  4. SSH Connection Port is the bastion server port used for the SSH connection. The default SSH port is 22. Keep this value unless you’ve explicitly changed the port.
  5. SSH Login Username is the username Airbyte uses to connect to the bastion server. It isn’t the Oracle username.
  6. When using Password Authentication, set SSH Login Username to the previous step’s user password. When using SSH Key Authentication, leave this field blank. This isn’t the Oracle password. It belongs to the operating system user that Airbyte uses to run commands on the bastion.
  7. When using SSH Key Authentication, set SSH Private Key to the RSA private key used for the SSH connection. Include the full key file contents, starting with -----BEGIN RSA PRIVATE KEY----- and ending with -----END RSA PRIVATE KEY-----.

Encryption options

Airbyte can connect to the Oracle source using three network connectivity options:

  1. Unencrypted uses the TCP protocol. All network data is transmitted without encryption.
  2. Native network encryption encrypts database connections without TCP / IP and SSL / TLS configuration overhead. You also don’t need to open and monitor different ports. By default, the SQLNET.ENCRYPTION_CLIENT option is always set to REQUIRED. The client or server only accepts encrypted traffic. You can choose an Encryption algorithm that meets your security policies.
  3. TLS Encrypted (verify certificate) transfers data using TLS, including the handshake and certificate verification. To use this option, enter the server-issued certificate’s contents in the SSL PEM file field.

Namespace support

This destination supports namespaces. The namespace maps to an Oracle schema.

Changelog

Expand to review
VersionDatePull RequestSubject
1.0.02024-04-11#36048Removes Normalization, updates to V2 Raw Table Format
0.2.02023-06-27#27781License Update: Elv2
0.1.192022-07-26#10719Destination Oracle: added custom JDBC parameters support.
0.1.182022-07-14#14618Removed additionalProperties: false from JDBC destination connectors
unpublished2022-05-1712820Improved ‘check’ operation performance
0.1.162022-04-0611514Bump mina-sshd from 2.7.0 to 2.8.0
0.1.152022-02-2510421Refactor JDBC parameters handling and remove DBT support
0.1.142022-02-1410256(unpublished) Add -XX:+ExitOnOutOfMemoryError JVM option
0.1.132021-12-29#9177Update connector fields title/description
0.1.122021-11-08#7719Improve handling of wide rows by buffering records based on their byte size rather than their count
0.1.102021-10-08#6893🎉 Destination Oracle: implemented connection encryption
0.1.92021-10-06#6611🐛 Destination Oracle: maxStringLength should be 128
0.1.82021-09-28#6370Add SSH Support for Oracle Destination
0.1.72021-08-30#5746Use default column name for raw tables
0.1.62021-08-23#5542Remove support for Oracle 11g to allow normalization
0.1.52021-08-10#5307🐛 Destination Oracle: Fix destination check for users without dba role
0.1.42021-07-30#5125Enable additionalPropertities in spec.json
0.1.32021-07-21#3555Partial Success in BufferedStreamConsumer
0.1.22021-07-20#4874Require sid instead of database in connector specification
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.