Oracle DB
Features
Feature | Supported?(Yes/No) | Notes |
---|---|---|
Full Refresh Sync | Yes | |
Incremental - Append Sync | Yes | |
Incremental - Append + Deduped | Yes | |
Namespaces | Yes | |
Basic Normalization | Yes | Doesn't support for nested json yet |
SSH Tunnel Connection | Yes | |
Encryption | Yes | Support Native Network Encryption (NNE) as well as TLS using SSL cert |
Output Schema
By default, each stream will be output into its own table in Oracle. Each table will contain 3 columns:
_AIRBYTE_AB_ID
: a uuid assigned by Airbyte to each event that is processed. The column type in Oracle isVARCHAR(64)
._AIRBYTE_EMITTED_AT
: a timestamp representing when the event was pulled from the data source. The column type in Oracle isTIMESTAMP WITH TIME ZONE
._AIRBYTE_DATA
: a json blob representing with the event data. The column type in Oracles isNCLOB
.
Enabling normalization will also create normalized, strongly typed tables.
Getting Started (Airbyte Cloud)
The Oracle connector is currently in Alpha on Airbyte Cloud. Only TLS encrypted connections to your DB can be made from Airbyte Cloud. Other than that, follow the open-source instructions below.
Getting Started (Airbyte Open Source)
Requirements
To use the Oracle destination, you'll need:
- An Oracle server version 18 or above
- It's possible to use Oracle 12+ but you need to configure the table name length to 120 chars.
Network Access
Make sure your Oracle database can be accessed by Airbyte. If your database is within a VPC, you may need to allow access from the IP you're using to expose Airbyte.
Permissions
As Airbyte namespaces allows us to store data into different schemas, we have different scenarios and list of required permissions:
Login user | Destination user | Required permissions | Comment |
---|---|---|---|
DBA User | Any user | - | |
Regular user | Same user as login | Create, drop and write table, create session | |
Regular user | Any existing user | Create, drop and write ANY table, create session | Grants can be provided on a system level by DBA or by target user directly |
Regular user | Not existing user | Create, drop and write ANY table, create user, create session | Grants should be provided on a system level by DBA |
We highly recommend creating an Airbyte-specific user for this purpose.