Global Resource Properties

Connection Settings

The connection settings of global resource can be configured from the property settings of each adapter or “Global Resource Settings” of the control panel.

Basic settings

Item name	Required/Optional	Use of variables	Description	Remarks
Name	Required	Not available	Enter the name of the connection settings.
Type	Required	Not available	Select a destination database type.	You can only select the database of the editing operation.

Required settings

Item name	Required/Optional	Use of variables	Description	Remarks
Cluster Endpoint	Required	Only environment variables are available	Enter the cluster endpoint.
Port number	Optional	Only environment variables are available	Enter the database port number. Default number is 3306.	When an invalid port number is entered, the connection response might be delayed. Refer to “Notes” for details.
Database name	Required	Only environment variables are available	Enter the database name.
User name	Required	Only environment variables are available	Enter the user name.
Password	Optional	Only environment variables are available	Enter the password.
SSL connection	Optional	Not available	Select whether or not to perform SSL connection. [Checked]: SSL connection will be performed. [Not checked]: (default) SSL connection will not be performed.	To perform SSL connection between this adapter and Amazon Aurora, you need to import a certificate to the keystore referred by DataSpiderServer. Download the certificate from "Securing Aurora Data with SSL" (http://docs.aws.amazon.com/en_us/AmazonRDS/latest/UserGuide/Aurora.Overview.html#Aurora.Overview.Security.SSL). For details on how to import a certificate to key store, refer to “Import Certificate”.

Property actions

Item name	Description	Remarks
Connection test	Check the database connection.

List settings

Item name	Required/Optional	Use of variables	Description	Remarks
Limit the number of tables in list	Optional	Not available	Select whether or not to limit the number of tables to display. [Checked]: (default) Limit the number of tables to display in the list. [Not checked]: Do not limit the number of tables displayed in the list and get all of the table names.
Number of tables in list	Optional	Available	Enter the number of tables to display in the list.	Enabled when [Limit the number of tables in list] is checked. Default value is 500. When omitted, or when an invalid value is entered, 500 will be applied.
Limit the number of procedures	Optional	Not available	Select whether or not to limit the number of procedures to display. [Checked]: (default) Limit the number of procedures to display. [Not checked]: Get all procedure names without limiting the number of them.
Number of procedures	Optional	Available	Enter the number of procedures to display.	Enabled when [Limit the number of procedures] is checked. Default value is 500. When omitted, or when an invalid value is entered, 500 will be applied.

Component Pool Settings

The component pool settings can be configured in “Global Resource Settings” of the control panel.

Security

The security settings can be configured in “Global Resource Settings” of the control panel.

Specification Limits

When clicking [Connection test] with an invalid password and an error occurs, if you specify the correct password after that, connection might succeed even if an invalid value is set in some other item.

Notes

When you input an invalid port number in [Port number], the connection response might be delayed due to retry processing for recovery.
The retry processing is skipped when clicking [Connection test], so it is recommended that you add/edit a global resource after confirming that you can connect normally.