# c8-source-oracle
[](https://opensource.org/licenses/GPL-3.0)
[Singer](https://www.singer.io/) tap that extracts data from a [Oracle](https://www.oracle.com/database/) database and produces JSON-formatted data following the [Singer spec](https://github.com/singer-io/getting-started/blob/master/docs/SPEC.md).
## How to use it
### Install and Run
First, make sure Python 3 is installed on your system or follow these
installation instructions for [Mac](http://docs.python-guide.org/en/latest/starting/install3/osx/) or
[Ubuntu](https://www.digitalocean.com/community/tutorials/how-to-install-python-3-and-set-up-a-local-programming-environment-on-ubuntu-16-04).
It's recommended to use a virtualenv:
```bash
python3 -m venv venv
pip install c8-source-oracle
```
or from source using,
1. Install poetry using https://python-poetry.org/docs/#installation
2. Run
```bash
poetry build
pip install dist/c8_source_oracle-<version>*.whl
```
### Configuration
Running the the tap requires a `config.json` file.
Example configuration:
```json
{
"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
```
Raw data
{
"_id": null,
"home_page": "https://www.macrometa.com/",
"name": "c8-source-oracle",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.7",
"maintainer_email": "",
"keywords": "ELT,Connectors,Workflows,Macrometa,Oracle,Tap",
"author": "Macrometa",
"author_email": "info@macrometa.com",
"download_url": "https://files.pythonhosted.org/packages/06/ad/c2b583fc8c9099828a6f30104bb9dac2f8a66c451a361025b583f655d59e/c8-source-oracle-0.0.7.tar.gz",
"platform": null,
"description": "# c8-source-oracle\n\n[](https://opensource.org/licenses/GPL-3.0)\n\n[Singer](https://www.singer.io/) tap that extracts data from a [Oracle](https://www.oracle.com/database/) database and produces JSON-formatted data following the [Singer spec](https://github.com/singer-io/getting-started/blob/master/docs/SPEC.md).\n\n## How to use it\n\n### Install and Run\n\nFirst, make sure Python 3 is installed on your system or follow these\ninstallation instructions for [Mac](http://docs.python-guide.org/en/latest/starting/install3/osx/) or\n[Ubuntu](https://www.digitalocean.com/community/tutorials/how-to-install-python-3-and-set-up-a-local-programming-environment-on-ubuntu-16-04).\n\n\nIt's recommended to use a virtualenv:\n\n```bash\n python3 -m venv venv\n pip install c8-source-oracle\n```\n\nor from source using,\n1. Install poetry using https://python-poetry.org/docs/#installation\n2. Run \n ```bash\n poetry build\n pip install dist/c8_source_oracle-<version>*.whl\n ```\n\n### Configuration\n\nRunning the the tap requires a `config.json` file. \n\nExample configuration:\n\n```json\n{\n \"host\": \"dev.oracledb.io\",\n \"port\": 1521,\n \"user\": \"C##HELLO\",\n \"password\": \"password\",\n \"service_name\": \"ORCLCDB\",\n \"filter_schemas\": \"C##HELLO\",\n \"default_replication_method\": \"LOG_BASED\",\n \"pdb_name\": \"ORCLPDB1\",\n \"multitenant\": true,\n \"scn_window_size\": 10\n}\n```\n\nYou can run a discover run using the previous `config.json` file to acquire all the tables definition\n \n```\nc8-source-oracle --config /tmp/config.json --discover >> /tmp/catalog.json\n```\n\nThen use the catalog.json to run a full export:\n\n```\nc8-source-oracle --config /tmp/config.json --catalog /tmp/catalog.json\n```\n\n\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Pipelinewise tap for reading from oracle databases. This includes support for PDBs.",
"version": "0.0.7",
"split_keywords": [
"elt",
"connectors",
"workflows",
"macrometa",
"oracle",
"tap"
],
"urls": [
{
"comment_text": "",
"digests": {
"md5": "85479f5e8cc50acdf090919b7bf98bcf",
"sha256": "039a15aef4962a9fe0953779d6fd914b54582ec66122d08d7a8b388fbbcf033d"
},
"downloads": -1,
"filename": "c8_source_oracle-0.0.7-py3-none-any.whl",
"has_sig": false,
"md5_digest": "85479f5e8cc50acdf090919b7bf98bcf",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.7",
"size": 29545,
"upload_time": "2022-11-30T13:16:01",
"upload_time_iso_8601": "2022-11-30T13:16:01.375942Z",
"url": "https://files.pythonhosted.org/packages/a3/62/9bdf6480293ee0aafb7f0a72d256f6fb0e0b42c5f4257043e9856f8a7d91/c8_source_oracle-0.0.7-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"md5": "b3b774cb85aaa12215f0f1e4045e5ea0",
"sha256": "51bc46a070a5ceecade046033b79b9aa857c36ef2193cbe02edbea8be70b9234"
},
"downloads": -1,
"filename": "c8-source-oracle-0.0.7.tar.gz",
"has_sig": false,
"md5_digest": "b3b774cb85aaa12215f0f1e4045e5ea0",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.7",
"size": 26053,
"upload_time": "2022-11-30T13:16:02",
"upload_time_iso_8601": "2022-11-30T13:16:02.987553Z",
"url": "https://files.pythonhosted.org/packages/06/ad/c2b583fc8c9099828a6f30104bb9dac2f8a66c451a361025b583f655d59e/c8-source-oracle-0.0.7.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2022-11-30 13:16:02",
"github": false,
"gitlab": false,
"bitbucket": false,
"lcname": "c8-source-oracle"
}
JSON