Macrometa source oracle connector for reading from oracle databases.
Project description
macrometa-source-oracle
Macrometa source connector 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 macrometa-source-oracle
or from source using,
- Install poetry using https://python-poetry.org/docs/#installation
- Run
poetry build pip install dist/macrometa_source_oracle-<version>*.whl
Configuration
Running the the macrometa source connector independently requires a config.json
file.
Example configuration:
{
"host": "dev.oracledb.io",
"port": 1521,
"user": "C##HELLO",
"password": "password",
"service_name": "ORCLCDB",
"filter_schema": "C##HELLO",
"filter_table": "CUSTOMERS",
"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
macrometa-source-oracle --config /tmp/config.json --discover >> /tmp/catalog.json
Then use the catalog.json to run a full export:
macrometa-source-oracle --config /tmp/config.json --catalog /tmp/catalog.json
Project details
Release history Release notifications | RSS feed
Download files
Download the file for your platform. If you're not sure which to choose, learn more about installing packages.
Source Distribution
Built Distribution
Close
Hashes for macrometa-source-oracle-1.0.0.tar.gz
Algorithm | Hash digest | |
---|---|---|
SHA256 | aca1f15c1fe90746fec9781a6a61e202ae1cdf0bcbc0fc88f5b035a033ced6fb |
|
MD5 | 434e814c03e3c0549a5ad5d7ea3c6688 |
|
BLAKE2b-256 | 62567d927d3eda9d9251f524f69101e11026e88bd8db12b4209089a5fb0baad8 |
Close
Hashes for macrometa_source_oracle-1.0.0-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | af55bed152e4311b74d4e05518ac3bca168e7bf964b4c43fb1929a93b8c3f63c |
|
MD5 | 411375068a55ce2d05c1befa3a255c7b |
|
BLAKE2b-256 | 40bd5361715e547a40ace4b334b09979b795d3a26522f93cb32a31a946733017 |