Pipelinewise tap for reading from oracle databases. This includes support for PDBs.
Project description
c8-source-oracle
Singer tap that extracts data from a Oracle database and produces JSON-formatted data following the Singer spec.
How to use it
Install and Run
First, make sure Python 3 is installed on your system or follow these installation instructions for Mac or Ubuntu.
It's recommended to use a virtualenv:
python3 -m venv venv
pip install c8-source-oracle
or from source using,
- Install poetry using https://python-poetry.org/docs/#installation
- Run
poetry build pip install dist/c8_source_oracle-<version>*.whl
Configuration
Running the the tap requires a config.json
file.
Example configuration:
{
"host": "dev.oracledb.io",
"port": 1521,
"user": "C##HELLO",
"password": "password",
"service_name": "ORCLCDB",
"filter_schemas": "C##HELLO",
"default_replication_method": "LOG_BASED",
"pdb_name": "ORCLPDB1",
"multitenant": true,
"scn_window_size": 10
}
You can run a discover run using the previous config.json
file to acquire all the tables definition
c8-source-oracle --config /tmp/config.json --discover >> /tmp/catalog.json
Then use the catalog.json to run a full export:
c8-source-oracle --config /tmp/config.json --catalog /tmp/catalog.json
Project details
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
c8-source-oracle-0.0.5.tar.gz
(25.8 kB
view hashes)
Built Distribution
Close
Hashes for c8_source_oracle-0.0.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | f8da32bcd41403dcf1ba12c4cd464b7073bc164c942ff52e43e20fbae96e6238 |
|
MD5 | e2809b31a2efcdba09b511f0d59ba261 |
|
BLAKE2b-256 | 3aa41796e513ce09e8780a85fc0e4d25f5e6b7f6298d7358c3dbb7835a6b522a |