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 #

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.

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!