GBASE Link Parameters

Table 1 lists the parameters for a link to GBASE.

**Table 1** GBASE 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	adb_link
Connector	The default value is Relational Database and cannot be changed.	-
Database Server	IP address or domain name of the database to connect. Use semicolons (;) to separate multiple values.	192.168.0.1;192.168.0.2
Port	Port of the database to connect	3306
Database Name	Name of the database to connect	dbname
Username	Username used for accessing the database When you create a database shard link, this configuration is applied to all backend links in the data source list for which no username or password has been configured. When you edit a database shard link, if you want to modify an existing backend link, specify the username and password in the data source list.	cdm
Password	Database password	-
Use Agent	This parameter does not need to be set as the agent function will be unavailable soon. This parameter is available for GBASE8A.	-
Agent	This parameter does not need to be set as the agent function will be unavailable soon. This parameter is available for GBASE8A.	-
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	Different types of relational databases adapt to different drivers. For details, see How Do I Obtain a Driver? This parameter is available for GBASE8A.	-
Fetch Size	This parameter is optional. It is displayed when you click Show Advanced Attributes. It specifies the number of rows obtained by each request. Set this parameter based on the data source and the amount of data of the job. If the value is either too large or too small, the job may run for a long time.	10,000
Commit Size	This parameter is optional. It is displayed when you click Show Advanced Attributes. It specifies the number of records submitted each time. Set this parameter based on the data destination and the amount of data of the job. If the value is either too large or too small, the job may run for a long time.	1,000
Link Attributes	Custom attributes of the link. This parameter is 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: socketTimeout: JDBC connection timeout duration, in milliseconds mysql.bool.type.transform: whether to parse tinyint(1) to a Boolean value during data reading from a MySQL database. The default value is true.	-