tap-oracle - Meltano Hub

Oracle

tap-oracle (hamza-bouali variant)🥈

Modern Singer tap for Oracle databases, built with the Meltano Singer SDK

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

Alternate Implementations

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 using
```
meltano add
```
:

meltano add tap-oracle --variant hamza-bouali

Configure the tap-oracle settings using

meltano config

:

meltano config tap-oracle set --interactive

Test that extractor settings are valid using

meltano config

:

meltano config tap-oracle test

Next steps

Follow the remaining steps of the Getting Started guide:

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

Capabilities

The current capabilities for tap-oracle may have been automatically set when originally added to the Hub. Please review the capabilities when using this extractor. If you find they are out of date, please consider updating them by making a pull request to the YAML file that defines the capabilities for this extractor.

This plugin has the following capabilities:

catalog
discover
state
about

You can override these capabilities or specify additional ones in your meltano.yml by adding the capabilities key.

Settings

The tap-oracle settings that are known to Meltano are documented below. To quickly find the setting you're looking for, click on any setting name from the list:

host
port
user
password
service_name
sid
filter_schemas
filter_tables
cursor_array_size
thick_mode
https_proxy
start_date

You can also list these settings using

meltano config

with the list subcommand:

meltano config tap-oracle list

You can override these settings or specify additional ones in your meltano.yml by adding the settings key.

Please consider adding any settings you have defined locally to this definition on MeltanoHub by making a pull request to the YAML file that defines the settings for this plugin.

Host (host)

Environment variable: TAP_ORACLE_HOST
Default Value: localhost

Your Oracle host or IP address

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set host [value]

Port (port)

Environment variable: TAP_ORACLE_PORT
Default Value: 1521

Your Oracle port number

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set port [value]

User (user)

Environment variable: TAP_ORACLE_USER

Your Oracle username

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set user [value]

Password (password)

Environment variable: TAP_ORACLE_PASSWORD

Your Oracle password

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set password [value]

Service Name (service_name)

Environment variable: TAP_ORACLE_SERVICE_NAME

Oracle service name (preferred method for connection)

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set service_name [value]

SID (sid)

Environment variable: TAP_ORACLE_SID

Oracle System ID (alternative to service_name)

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set sid [value]

Filter Schemas (filter_schemas)

Environment variable: TAP_ORACLE_FILTER_SCHEMAS

Comma-separated list of schema names to filter discovery

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set filter_schemas [value]

Filter Tables (filter_tables)

Environment variable: TAP_ORACLE_FILTER_TABLES

Array of tables to filter discovery in format SCHEMA-TABLE

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set filter_tables [value]

Cursor Array Size (cursor_array_size)

Environment variable: TAP_ORACLE_CURSOR_ARRAY_SIZE
Default Value: 1000

Cursor array size for batch fetches (default 1000)

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set cursor_array_size [value]

Thick Mode (thick_mode)

Environment variable: TAP_ORACLE_THICK_MODE
Default Value: false

Use thick mode for oracledb driver (requires Oracle Client installation)

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set thick_mode [value]

HTTPS Proxy (https_proxy)

Environment variable: TAP_ORACLE_HTTPS_PROXY

HTTPS proxy URL for connections

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set https_proxy [value]

Start Date (start_date)

Environment variable: TAP_ORACLE_START_DATE

Start date for incremental replication (ISO format)

Configure this setting directly using the following Meltano command:

meltano config tap-oracle set start_date [value]

Something missing?

This page is generated from a YAML file that you can contribute changes to.

Edit it on GitHub!

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.

Install

meltano add
              tap-oracle --variant hamza-bouali

Maintenance Status

Repo

https://github.com/Hamza-Bouali/tap-oracle

Maintainer

PyPI Stats

Keywords