# macrometa-source-oracle
Macrometa source connector 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 macrometa-source-oracle
```
or from source using,
1. Install poetry using https://python-poetry.org/docs/#installation
2. Run
```bash
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:
```json
{
"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
```
Raw data
{
"_id": null,
"home_page": "https://www.macrometa.com/",
"name": "macrometa-source-oracle",
"maintainer": "",
"docs_url": null,
"requires_python": ">=3.8.1,<3.11",
"maintainer_email": "",
"keywords": "ELT,Connectors,Workflows,Macrometa,Oracle,Source",
"author": "Macrometa",
"author_email": "info@macrometa.com",
"download_url": "https://files.pythonhosted.org/packages/62/56/7d927d3eda9d9251f524f69101e11026e88bd8db12b4209089a5fb0baad8/macrometa-source-oracle-1.0.0.tar.gz",
"platform": null,
"description": "# macrometa-source-oracle\n\nMacrometa source connector 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 macrometa-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/macrometa_source_oracle-<version>*.whl\n ```\n\n### Configuration\n\nRunning the the macrometa source connector independently 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_schema\": \"C##HELLO\",\n \"filter_table\": \"CUSTOMERS\",\n \"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```\nmacrometa-source-oracle --config /tmp/config.json --discover >> /tmp/catalog.json\n```\n\nThen use the catalog.json to run a full export:\n\n```\nmacrometa-source-oracle --config /tmp/config.json --catalog /tmp/catalog.json\n```\n\n\n",
"bugtrack_url": null,
"license": "Apache-2.0",
"summary": "Macrometa source oracle connector for reading from oracle databases.",
"version": "1.0.0",
"project_urls": {
"Bug Tracker": "https://github.com/Macrometacorp/macrometa-source-oracle/issues",
"Homepage": "https://www.macrometa.com/"
},
"split_keywords": [
"elt",
"connectors",
"workflows",
"macrometa",
"oracle",
"source"
],
"urls": [
{
"comment_text": "",
"digests": {
"blake2b_256": "40bd5361715e547a40ace4b334b09979b795d3a26522f93cb32a31a946733017",
"md5": "411375068a55ce2d05c1befa3a255c7b",
"sha256": "af55bed152e4311b74d4e05518ac3bca168e7bf964b4c43fb1929a93b8c3f63c"
},
"downloads": -1,
"filename": "macrometa_source_oracle-1.0.0-py3-none-any.whl",
"has_sig": false,
"md5_digest": "411375068a55ce2d05c1befa3a255c7b",
"packagetype": "bdist_wheel",
"python_version": "py3",
"requires_python": ">=3.8.1,<3.11",
"size": 26384,
"upload_time": "2023-08-01T08:41:35",
"upload_time_iso_8601": "2023-08-01T08:41:35.967910Z",
"url": "https://files.pythonhosted.org/packages/40/bd/5361715e547a40ace4b334b09979b795d3a26522f93cb32a31a946733017/macrometa_source_oracle-1.0.0-py3-none-any.whl",
"yanked": false,
"yanked_reason": null
},
{
"comment_text": "",
"digests": {
"blake2b_256": "62567d927d3eda9d9251f524f69101e11026e88bd8db12b4209089a5fb0baad8",
"md5": "434e814c03e3c0549a5ad5d7ea3c6688",
"sha256": "aca1f15c1fe90746fec9781a6a61e202ae1cdf0bcbc0fc88f5b035a033ced6fb"
},
"downloads": -1,
"filename": "macrometa-source-oracle-1.0.0.tar.gz",
"has_sig": false,
"md5_digest": "434e814c03e3c0549a5ad5d7ea3c6688",
"packagetype": "sdist",
"python_version": "source",
"requires_python": ">=3.8.1,<3.11",
"size": 23735,
"upload_time": "2023-08-01T08:41:37",
"upload_time_iso_8601": "2023-08-01T08:41:37.022216Z",
"url": "https://files.pythonhosted.org/packages/62/56/7d927d3eda9d9251f524f69101e11026e88bd8db12b4209089a5fb0baad8/macrometa-source-oracle-1.0.0.tar.gz",
"yanked": false,
"yanked_reason": null
}
],
"upload_time": "2023-08-01 08:41:37",
"github": true,
"gitlab": false,
"bitbucket": false,
"codeberg": false,
"github_user": "Macrometacorp",
"github_project": "macrometa-source-oracle",
"github_not_found": true,
"lcname": "macrometa-source-oracle"
}
JSON
