Edit resource list

Edit the resource list.

Note

The following types of operations use the same MySQL connection settings:

Insert operation
Insert (result output) operation
Select (1 row) operation

It is not necessary to create MySQL connection settings for each component.

On the Required settings tab on the insert operation screen, open the pulldown list of Destination, and then click Edit resource list to display the editing screen.

For details on the insert operation screen, refer to Insert.

Figure 6.8 Edit resource list screen

(1) Field list

This is a list of the fields to configure on the Edit resource list screen.

Table 6.8 Field list
Field Name		Initial Value	Setting Value	Omission	Notes
Name			Single-byte alphanumeric characters and certain symbols (*1)	-	A value that begins with a single-byte alphabetic character
Required settings
	Host name			-
	Port No.	3306	From 1 to 65535	-	Set as integer
	User name			-
	Password			-
	Database			-

-	:	Impossible to omit
*1	:	Only "_" (underscore) can be specified.

(2) Description of each field

This section explains each of the fields to configure on the Edit resource list screen.

After changing these settings, click Apply to save the settings.

Click Cancel to discard the changes.

Click Close to close the screen.

Resource list

Resource list for MySQL connection

To edit the content of the settings, select the resource name of a registered MySQL connection.

When you click Add, the MySQL connection settings screen appears, and you can add resource information.

For details on the MySQL connection settings screen, refer to MySQL connection settings.

When you click Delete, the resource information of the selected MySQL connection settings is deleted.

Name

Resource name for MySQL connection settings

Single-byte alphanumeric characters and "_" (underscore) can be used.

Use a value that begins with a single-byte alphabetic character.

Required settings

Host name

Host name of the MySQL destination

Specify the host name of the MySQL destination.

Port No.

Port number of the MySQL destination

Specify a number from "1" through "65535" for the port number of the MySQL destination.

User name

User name

Specify the user name that is used to connect to MySQL.

Password

Password

Specify the password that is used to connect to the MySQL destination.

Database

The database that you want to connect

Specify the MySQL database.

You can use Get database list to get a list of databases stored in the destination host.

When you click Connection test, you can check whether the database specified for Database can be connected.

Official | HULFT IoT EdgeStreaming Adapter Reference First Edition: July 1, 2021

You are here: