Oracle DB
Table of Contents
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:
Installation and configuration #
-
Add the
tap-oracle
extractor to your project usingmeltano add
:meltano add extractor tap-oracle
-
Configure the settings below using
meltano config
.
Next steps #
Follow the remaining steps of the Getting Started guide:
- Select entities and attributes to extract
- Add a loader to send data to a destination
- Run a data integration (EL) pipeline
Capabilities #
Settings #
tap-oracle
requires the
configuration
of the following settings:
The settings for extractor tap-oracle
that are known to Meltano 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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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
)
#
-
Environment variable:
TAP_ORACLE_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!