Skip to main content

IBM DB2 Profile

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
Author: Rasmus Nyberg
Source: GitHub
Core version: v1.0.4
dbt Cloud: Not Supported

dbt-ibmdb2 stars latest version on PyPI

The package can be installed from PyPI with:

pip install dbt-ibmdb2

This is an experimental plugin:

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​

OptionDescriptionRequired?Example
typeThe specific adapter to useRequiredibmdb2
schemaSpecify the schema (database) to build models intoRequiredanalytics
databaseSpecify the database you want to connect toRequiredtestdb
hostHostname or IP-adressRequiredlocalhost
portThe port to useOptional50000
protocolProtocol to useOptionalTCPIP
usernameThe username to use to connect to the serverRequiredmy-username
passwordThe password to use for authenticating to the serverRequiredmy-password

Supported features​

DB2 LUWDB2 z/OSFeature
βœ…πŸ€·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.