The tap-oracle Meltano extractor pulls data from Oracle DB that can then be sent to a destination using a loader.

Alternative variants #

Multiple variants of tap-oracle are available. This document describes the default transferwise variant, which is recommended for new users.

Alternative variants are:

Getting Started #

Prerequisites #

If you haven't already, follow the initial steps of the Getting Started guide:

  1. Install Meltano
  2. Create your Meltano project

Installation and configuration #

Using the Command Line Interface #

  1. Add the tap-oracle extractor to your project using meltano add : 

    meltano add extractor tap-oracle
  2. Configure the settings below using meltano config .

Next steps #

Follow the remaining steps of the Getting Started guide:

  1. Select entities and attributes to extract
  2. Add a loader to send data to a destination
  3. Run a data integration (EL) pipeline

If you run into any issues, learn how to get help.

Capabilities #

Settings #

tap-oracle requires the configuration of the following settings:

These and other supported settings are documented below. To quickly find the setting you're looking for, use the Table of Contents at the top of the page.

SID (sid) #

Your Oracle SID.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set sid <sid>

export TAP_ORACLE_SID=<sid>

Host (host) #

Your Oracle host.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set host <host>

export TAP_ORACLE_HOST=<host>

Port (port) #

Your Oracle port.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set port <port>

export TAP_ORACLE_PORT=<port>

User (user) #

Your Oracle user.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set user <user>

export TAP_ORACLE_USER=<user>

Password (password) #

Your Oracle password.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set password <password>

export TAP_ORACLE_PASSWORD=<password>

Default Replication Method (default_replication_method) #

The default replication method to use if one is not automatically set on the stream. Options - ‘LOG_BASED’, ‘FULL_TABLE’, ‘INCREMENTAL’.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set default_replication_method <default_replication_method>

export TAP_ORACLE_DEFAULT_REPLICATION_METHOD=<default_replication_method>

Filter Schemas (filter_schemas) #

A comma separated list of schema names to scan. Used to improve the performance of data extraction.

How to use #

Manage this setting using meltano config or an environment variable: 

meltano config tap-oracle set filter_schemas <filter_schemas>

export TAP_ORACLE_FILTER_SCHEMAS=<filter_schemas>

Looking for help? #

If you're having trouble getting the tap-oracle extractor to work, look for an existing issue in its repository, file a new issue, or join the Meltano Slack community and ask for help in the #plugins-general channel.

Found an issue on this page? #

This page is generated from a YAML file that you can contribute changes to. Edit it on GitHub!