Skip to main content

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.

  • 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

Use pip to install the adapter. Before 1.8, installing the adapter would automatically install dbt-core and any additional dependencies. Beginning in 1.8, installing an adapter does not automatically install dbt-core. This is because adapters and dbt Core versions have been decoupled from each other so we no longer want to overwrite existing dbt-core installations. Use the following command for installation:

Configuring dbt-ibmdb2

For IBM DB2-specific configuration, please refer to IBM DB2 configs.

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.
0