Connect Doris to DataWorks Using UrlMode FE Endpoint - DataWorks

Configure an Apache Doris data source in DataWorks to read from and write to Doris clusters in data integration tasks.

Property definition

Data source type: doris
Supported configuration mode (ConnectionPropertiesMode): Connection string mode (UrlMode)

Connection string mode

Parameter	Type	Required	Default	Description
`address`	Array	Yes	—	The address, which contains only a single pair of host and port.
`loadAddress`	Array	Yes	—	The FE endpoint, which can contain one or more pairs of host and port.
`database`	String	Yes	—	The name of the database.
`username`	String	Yes	—	The username.
`password`	String	Yes	—	The password.
`properties`	JSON Object	No	—	Additional driver properties, such as `useSSL` and `socketTimeout`.
`envType`	String	Yes	—	The data source environment. Valid values: `Dev` (development environment), `Prod` (production environment).

Configuration examples

Minimal configuration

Use this configuration when no additional driver properties are needed:

{
    "envType": "Prod",
    "address": [
        {
            "host": "127.0.0.1",
            "port": "3306"
        }
    ],
    "loadAddress": [
        {
            "host": "127.0.0.2",
            "port": "8031"
        }
    ],
    "database": "my_database",
    "username": "my_username",
    "password": "my_password"
}

Configuration with driver properties

Add properties to customize driver behavior, such as disabling SSL or setting a socket timeout:

{
    "envType": "Prod",
    "address": [
        {
            "host": "127.0.0.1",
            "port": "3306"
        }
    ],
    "loadAddress": [
        {
            "host": "127.0.0.2",
            "port": "8031"
        }
    ],
    "database": "my_database",
    "username": "my_username",
    "password": "my_password",
    "properties": {
        "socketTimeout": "2000"
    }
}