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.

Overview of dbt-ibmdb2

  • Maintained by: Community
  • Authors: Rasmus Nyberg (
  • 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:

Connecting to IBM DB2 with dbt-ibmdb2

IBM DB2 targets should be set up using the following configuration in your profiles.yml file.


target: 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

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
🤷Custom data tests
🤷Docs generate


  • dbt-ibmdb2 is built on the ibm_db python package and there are some known encoding issues related to z/OS.