IBM DB2 setup
Community plugin
Some core functionality may be limited. If you're interested in contributing, check out the source code for each repository listed below.
Overview of dbt-ibmdb2
- Maintained by: Community
- Authors: Rasmus Nyberg (https://github.com/aurany)
- GitHub repo: aurany/dbt-ibmdb2
- PyPI package:
dbt-ibmdb2
- Slack channel: n/a
- Supported dbt Core version: v1.0.4 and newer
- dbt Cloud support: Not Supported
- Minimum data platform version: IBM DB2 V9fp2
Installing dbt-ibmdb2
pip is the easiest way to install the adapter:
pip install dbt-ibmdb2
Installing dbt-ibmdb2
will also install dbt-core
and any other dependencies.
Configuring dbt-ibmdb2
For IBM DB2-specifc configuration please refer to IBM DB2 Configuration
For further info, refer to the GitHub repository: aurany/dbt-ibmdb2
This is an experimental plugin:
- We have not tested it extensively
- Tested with dbt-adapter-tests and DB2 LUW on Mac OS+RHEL8
- Compatibility with other dbt packages (like dbt_utils) is only partially tested
Connecting to IBM DB2 with dbt-ibmdb2
IBM DB2 targets should be set up using the following configuration in your profiles.yml
file.
Example:
~/.dbt/profiles.yml
your_profile_name:
target: dev
outputs:
dev:
type: ibmdb2
schema: analytics
database: test
host: localhost
port: 50000
protocol: TCPIP
username: my_username
password: my_password
Description of IBM DB2 Profile Fields
Option | Description | Required? | Example |
---|---|---|---|
type | The specific adapter to use | Required | ibmdb2 |
schema | Specify the schema (database) to build models into | Required | analytics |
database | Specify the database you want to connect to | Required | testdb |
host | Hostname or IP-adress | Required | localhost |
port | The port to use | Optional | 50000 |
protocol | Protocol to use | Optional | TCPIP |
username | The username to use to connect to the server | Required | my-username |
password | The password to use for authenticating to the server | Required | my-password |
Supported features
DB2 LUW | DB2 z/OS | Feature |
---|---|---|
✅ | 🤷 | Table materialization |
✅ | 🤷 | View materialization |
✅ | 🤷 | Incremental materialization |
✅ | 🤷 | Ephemeral materialization |
✅ | 🤷 | Seeds |
✅ | 🤷 | Sources |
✅ | 🤷 | Custom data tests |
✅ | 🤷 | Docs generate |
✅ | 🤷 | Snapshots |
Notes
- dbt-ibmdb2 is built on the ibm_db python package and there are some known encoding issues related to z/OS.
0