All Products
Search
Document Center

DataWorks:DB2

Last Updated:Nov 07, 2024

Property definition

  • Data source type: db2

  • Supported configuration mode (ConnectionPropertiesMode): Connection string mode (UrlMode)

Connection string mode

Parameter

Type

Example

Required

Description

address

JSON Array

[
    {
        "host": "127.0.0.1",
        "port": 3306
    }
]

Yes

The address, which is configured in the JSON array format but contains only a single pair of host and port.

database

String

mysql_database

Yes

The name of the database.

jdbcDriver

String

db2_1

Yes

The model of the Db2 driver. Valid values:

  • db2_1

  • as400_1

  • db2_2

username

String

xxxxx

Yes

The username.

password

String

xxxxx

Yes

The password.

properties

JSON Object

{
    "currentSchema": "abc"
}

No

The properties of the driver.

envType

String

Dev

Yes

The information about the data source environment. Valid values:

  • Dev: The development environment.

  • Prod: The production environment.

Configuration examples

Connection string mode

{
    "address": [
        {
            "host": "127.0.0.1",
            "port": 5432
        }
    ],
    "database": "db",
    "properties": {
        "currentSchema": "abc"
    },
    "jdbcDriver":"db2_1",
    "username": "xxxxx",
    "password": "xxxxx",
    "envType": "Dev"
}