Edit resource list

Edit the resource list.

Note

The following types of operations use the same SQL Server connection settings:

  • Insert operation

  • Insert (result output) operation

  • Select (1 row) operation

It is not necessary to create SQL Server 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.18 Edit resource list screen

(1) Field list

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

Table 6.18 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.

8086

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 SQL Server connection

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

When you select a resource name, the registered contents are displayed.

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

For details on the SQL Server connection settings screen, refer to SQL Server connection settings.

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

Name

Resource name for SQL Server 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 SQL Server destination

Specify the host name of the SQL Server destination.

Port No.

Port number of the SQL Server destination

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

User name

User name

Specify the user name that is used to connect to SQL Server.

Password

Password

Specify the password that is used to connect to the SQL Server destination.

Database

The database that you want to connect

Specify the SQL Server 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.