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 alpha

Oracle DB

Output schema

By default, each stream goes to its own Oracle table. Each table contains three columns:

  • _AIRBYTE_AB_ID: a UUID Airbyte assigns to each processed event. The Oracle column type is VARCHAR(64).
  • _AIRBYTE_EMITTED_AT: a timestamp showing when Airbyte pulled the event 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.

Enabling normalisation also creates 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

You’ll need the following to use the Oracle destination:

  • An Oracle server running version 21 or above

Network access

Make sure Airbyte can access your Oracle database. If your database is inside a VPC, you may need to allow access from the IP 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

Creating an Airbyte-specific user for this purpose is highly recommended.

Set up the Oracle destination in Airbyte

You now have everything required to configure Oracle as a destination in the UI. You’ll need these details:

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

Airbyte can connect to an Oracle instance through an SSH Tunnel. Use this approach when direct database access is impossible or breaches security policy, such as when it has no public IP address.

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

This feature needs extra configuration when you create the source. The following guidance explains each setting.

  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 when using an RSA private key to establish the SSH Tunnel. See below for guidance on generating this key.
    2. Choose Password Authentication when using a password to establish the SSH Tunnel.
  3. SSH Tunnel Jump Server Host is the intermediate (bastion) server that Airbyte connects to. Enter its 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 default unless you’ve explicitly changed the port.
  5. SSH Login Username is the username Airbyte uses to connect to the bastion server. This isn’t the Oracle username.
  6. If you’re using Password Authentication, set SSH Login Username to the previous step’s user password. If you’re using SSH Key Authentication, leave this field blank. This isn’t the Oracle password. It’s the OS-user password Airbyte uses to run commands on the bastion.
  7. If you’re using SSH Key Authentication, set SSH Private Key to the RSA Private Key used for the SSH connection. Include the key file’s full 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: The connection uses the TCP protocol. All data travels across the network without encryption.
  2. Native network encryption: This option encrypts database connections without TCP / IP and SSL / TLS configuration overhead. You also don’t need to open and listen on different ports. The SQLNET.ENCRYPTION_CLIENT option always defaults 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): This option transfers data using TLS, including the handshake procedure and certificate verification. To use it, insert the server-issued certificate’s content into 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.