The tap-oracle Singer tap pulls data from Oracle DB that can then be sent to a destination using a Singer target.

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:

Standalone usage #

Install the package using pip:

pip install pipelinewise-tap-oracle

For additional instructions, refer to the README in the repository.

Usage with Meltano #

Meltano helps you manage your configuration, incremental replication, and scheduled pipelines.

View the Meltano-specific tap-oracle instructions to learn more.

Capabilities #

These capabilities can also be overriden by specifying the capabilities key in your meltano.yml file.

Settings #

tap-oracle requires the configuration of the following settings:

The settings for tap 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.

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 tap.

SID (sid) #

Your Oracle SID.

Host (host) #

Your Oracle host.

Port (port) #

Your Oracle port.

User (user) #

Your Oracle user.

Password (password) #

Your Oracle 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’.

Filter Schemas (filter_schemas) #

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

Looking for help? #

If you're having trouble getting the tap-oracle tap 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!