target-oracle is a Singer target for Oracle.
Build with the Meltano Target SDK.
git
| Setting | Required | Default | Description |
|---|---|---|---|
| sqlalchemy_url | False | None | SQLAlchemy connection string |
| driver_name | False | oracle+cx_oracle | SQLAlchemy driver name |
| username | False | None | Oracle username |
| password | False | None | Oracle password |
| host | False | None | Oracle host |
| port | False | None | Oracle port |
| database | False | None | Oracle database |
| prefer_float_over_numeric | False | 0 | Use float data type for numbers (otherwise number type is used) |
| freeze_schema | False | 0 | Do not alter types of existing columns |
| stream_maps | False | None | Config object for stream maps capability. For more information check out Stream Maps. |
| stream_map_config | False | None | User-defined config values to be used within map expressions. |
| flattening_enabled | False | None | 'True' to enable schema flattening and automatically expand nested properties. |
| flattening_max_depth | False | None | The max depth to flatten schemas. |
A full list of supported settings and capabilities for this target is available by running:
target-oracle --aboutThis Singer target will automatically import any environment variables within the working directory's
.env if the --config=ENV is provided, such that config values will be considered if a matching
environment variable is set either in the terminal context or in the .env file.
You can easily run target-oracle by itself or in a pipeline using Meltano.
target-oracle --version
target-oracle --help
# Test using the "Carbon Intensity" sample:
tap-carbon-intensity | target-oracle --config /path/to/target-oracle-config.jsonFollow these instructions to contribute to this project.
pipx install poetry
poetry installCreate tests within the target_oracle/tests subfolder and
then run:
poetry run pytestYou can also test the target-oracle CLI interface directly using poetry run:
poetry run target-oracle --helpTesting with Meltano
Note: This target will work in any Singer environment and does not require Meltano. Examples here are for convenience and to streamline end-to-end orchestration scenarios.
Next, install Meltano (if you haven't already) and any needed plugins:
# Install meltano
pipx install meltano
# Initialize meltano within this directory
cd target-oracle
meltano installNow you can test and orchestrate using Meltano:
# Test invocation:
meltano invoke target-oracle --version
# OR run a test `elt` pipeline with the Carbon Intensity sample tap:
meltano elt tap-carbon-intensity target-oracleSee the dev guide for more instructions on how to use the Meltano Singer SDK to develop your own Singer taps and targets.