`Tap-DB2` is a Singer tap for IBM DB2 data sources.
Project description
Tap-DB2 👑
Tap-DB2
is a Singer tap for IBM DB2 data sources. Built with the Meltano Tap SDK for Singer Taps.
❗️ Caution: This tap has only been tested against an IBM DB2 running on z/OS.
Installation ⚙️
Install from PyPi:
pipx install tap-db2
Install from GitHub:
pipx install git+https://github.com/danielptv/tap-db2.git@main
Configuration 📝
Setting | Required | Default | Description |
---|---|---|---|
host | True | None | The DB2 hostname. |
port | True | None | The DB2 port. |
database | True | None | The DB2 database. |
schema | False | None | The DB2 schema. |
user | True | None | The DB2 username. |
password | True | None | The DB2 password. |
encryption.encryption_method | True | None | The encryption method. Valid values are 'encrypted_verify_certificate' and 'none'. |
encryption.ssl_server_certificate | False | None | The path to the SSL server certificate. |
connection_parameters | False | None | Additional parameters to be appended to the connection string. This is an array of objects. Each object must contain the keys 'key' and 'value'. |
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. |
A full list of supported settings and capabilities for this tap is available by running:
tap-db2 --about --format json
Configure using environment variables ✏️
This Singer tap 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.
Usage 👷♀️
You can easily run tap-db2
by itself or in a pipeline using Meltano.
Executing the Tap Directly 🔨
tap-db2 --version
tap-db2 --help
tap-db2 --config CONFIG --discover > ./catalog.json
Developer Resources 👩🏼💻
Follow these instructions to contribute to this project.
Initialize your Development Environment
pipx install poetry
poetry install
Create and Run Tests 🧪
Create tests within the tests
subfolder and
then run:
poetry run pytest
You can also test the tap-db2
CLI interface directly using poetry run
:
poetry run tap-db2 --help
Testing with Meltano
Note: This tap 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 tap-db2
meltano install
Now you can test and orchestrate using Meltano:
# Test invocation:
meltano invoke tap-db2 --version
# OR run a test `elt` pipeline:
meltano elt tap-db2 target-jsonl
SDK Dev Guide
See the dev guide for more instructions on how to use the SDK to develop your own taps and targets.
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
Hashes for tap_ibm_db2-0.1.5-py3-none-any.whl
Algorithm | Hash digest | |
---|---|---|
SHA256 | ebb6448285f3ccb3debc56910522152995c0d9c28ba03f52204933056728ccc5 |
|
MD5 | 78f0fbcd00fb1d0eef0ff9ed9a58a840 |
|
BLAKE2b-256 | 3b402f6c2c54d630a88120cb898d62de831b0d1ec7d00c13ed1a02d0aa0f5827 |