Help Center/DataArts Studio/User Guide/DataArts Migration (CDM Jobs)/Creating a Link in a CDM Cluster/Configuring Link Parameters/Doris Link Parameters
Updated on 2026-03-20 GMT+08:00
View PDF
Share

Doris Link Parameters

CDM can connect to open-source Doris and MRS Doris. Table 1 lists the parameters for a Doris link.

  • Do not change the password or user when the job is running. If you do so, the password will not take effect immediately and the job will fail.
  • Doris is compatible with the MySQL protocol. You can use the standard MySQL client or driver to connect to Doris. However, to fully utilize Doris's high performance and achieve the best operation experience, you are strongly advised to use the native Doris connection.
Table 1 Doris link parameters

Parameter

Description

Example Value

Name

Link name, which should be defined based on the data source type, so it is easier to remember what the link is for

Doris_link

Database Server

One or more server lists (server domain names/IP addresses) separated by semicolons (;)

NOTE:
  • For the open-source Doris, enter the server domain names or IP addresses.
  • For MRS Doris, log in to Manager of the cluster where the MRS Doris data source is located, choose Cluster > Services > Doris > Instance, and view the MRS Doris service IP address.

    MRS clusters whose Kerberos encryption type is aes256-sha2,aes128-sha2 are not supported, and only MRS clusters whose Kerberos encryption type is aes256-sha1,aes128-sha1 are supported.

192.168.0.1;192.168.0.2

Port

Port of the database to connect

  • MySQL: The default port is 3306.
  • Oracle: The default port is 1521.
  • PostgreSQL: The default port is 5432.
  • Microsoft SQL Server: The default port is 1433.
  • DWS: The default port is 8000.
  • Doris: The default port is 9030.
    • To query the MRS Doris MySQL port, log in to Manager, choose Cluster > Services > Doris, click Configurations, and search for query_port.
    • To query the open-source Doris MySQL port,

      go to the installation path and search for query_port in the conf/fe.conf file.

  • DB2: The default port is 50000.

9030

Database Name

Name of the database to connect

dbname

Username

Username used for accessing the database This account must have the permissions required to read and write data tables and metadata.

cdm

Password

Password of the user

-

SSL Encryption

Select Yes if you want to enable SSL encrypted transmission.

  • If the current data source is Doris, HTTPS is enabled for Doris, and SSL Encryption is set to Yes, HTTPS transmission is enabled. The default value is Yes. This parameter is valid only when stream load is used to write data.
  • To check whether HTTPS is enabled for MRS, log in to FusionInsight Manager, choose Cluster > Services > Doris, click Configurations, and search for https_enable.
  • To check whether HTTPS is enabled for open-source Doris, go to the installation path conf/fe.conf and search for https_enable.

Yes

Use Agent

The agent function will be unavailable soon and does not need to be configured.

-

Agent

The agent function will be unavailable soon and does not need to be configured.

-

FE HTTP Port

HTTP port number of the FE in the Doris cluster. The default port is 8030. If HTTPS is enabled, the default port is 8050.

  • Method for querying the MRS Doris FE HTTP port:
    • HTTPS port number: Log in to FusionInsight Manager, choose Cluster > Services > Doris > Configurations, and search for https_port.
    • HTTP port number: Log in to FusionInsight Manager, choose Cluster > Services > Doris > Configurations, and search for http_port.
  • Method for querying the open-source Doris FE HTTP port:
    • HTTPS port number: Go to the installation path conf/fe.conf and search for https_port.
    • HTTP port number: Go to the installation path conf/fe.conf and search for http_port.

8030

check streamLoad

Whether to check accessibility of the IP address and HTTP port of the FE node. You are advised to set this parameter to Yes when using stream load to write data.

Yes

Reference Sign

Database enclosure character. This parameter is optional. For some databases, the value is case sensitive. Leave this parameter blank if no enclosure character is required.

`

Driver Version

Upload the required driver.

  • The mysql-connector-java-5.1.48.jar driver is recommended.
  • For Doris 2.x or later versions of clusters for which HTTPS is enabled, the mysql-connector-java-8.0.27.jar driver is recommended. If the mysql-connector-java-5.1.48.jar driver is used, the connection test will fail.

-

Fetch Size

(Optional) Displayed when you click Show Advanced Attributes.

Number of rows obtained by each request. Set this parameter based on the data source and the job's data size. If the value is either too large or too small, the job may run for a long time.

1000

Commit Size

(Optional) Displayed when you click Show Advanced Attributes.

Number of records submitted each time. Set this parameter based on the data destination and the job's data size. If the value is either too large or too small, the job may run for a long time.

10000

Link Attributes

(Optional) Click Add to add the JDBC connector attributes of multiple specified data sources. For details, see the JDBC connector document of the corresponding database.

The following are some examples:

connectTimeout=600000 and socketTimeout=300000: When a large amount of data needs to be migrated or the entire table is retrieved using query statements, the migration fails due to connection timeout. In this case, you can customize the connection timeout interval (ms) and socket timeout interval (ms) to prevent failures caused by timeout.

sslmode=require

Link Secret Attributes

Custom secret attributes of the link

sk=09fUgD5WOF1L6f