Global Resource Properties

Connection Settings

Connection settings for a Global Resource can be managed in the property setting dialog for each adapter, in the 'Global Resource Settings' within the Control Panel.
Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Enter the name of the connection setting.  
Type Required Not available Select the type of database to connect.
  • Cannot select the database out of the operation database on editing.
Required settings
Item name Required / Optional Use of Variables Description Remarks
Hostname Required Only environment variables are available. Enter the host name of database.
  • Disabled when [Enter URL directly] is checked.
Port number Optional Only environment variables are available. Enter the port number of database.
The number defaults to 3306.
  • Disabled when [Enter URL directly] is checked.
Database name Required Only environment variables are available. Enter the database name.
  • Disabled when [Enter URL directly] is checked.
Enter URL directly Optional Not available Select whether or not to enter the URL of destination MySQL database directly.
  • [Checked]:
    Enter the URL directly.
  • [Not checked]: (default)
    Generate URL based on the settings of [Host name], [Port number], [Database name], and [SSL connection].
  • In case of [Not Checked], the parameters will be provided automatically.
    For more details, refer to “About Connection parameters”.
URL Required Only environment variables are available Enter the URL.
Standard URL format of MySQL is “jdbc:mysql://<Host name>:<Port number>/<Database name>”.
The adapter supports URL which is supported by the JDBC driver.
  • Enabled when [Enter URL directly] is checked.
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 to make the SSL connection.
  • [Checked]:
    Make SSL connections.
  • [Not Checked]: (default)
    Do not make SSL connections.
  • To perform SSL communication between MySQL and this adapter, you will need to import the private key and the certificate issued by Certification Authority (CA) into the keystore that is referenced by DataSpiderServer.
    For how to import the private key and certificate, refer to Certificate Installation
    Private keys and certificates generated with OpenSSL are also supported.
  • Disabled when [Enter URL directly] is checked.
Property Action
Item name Description Remarks
Connection Test Checks the connection to the database.  
Display Settings
Item name Required / Optional Use of Variables Description Remarks
Specify the number of tables in the list Optional Not available Select whether to limit the number of tables listed or not.
  • [Checked]:(default)
    limit the number of tables names listed.
  • [Not Checked]:
    Table names listed are not limited. Fetches all of the table names available.
 
Number of tables Optional Available Enter a number of tables listed.
  • Enabled when [Specify the number of tables in the list] is checked.
  • Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.
Specify the number of procedures in the list Optional Not available available Select whether to limit the number of procedures or not.
  • [Checked]:(default)
    limit the number of procedures listed.
  • [Not Checked]:
    Procedure names listed are not limited. Fetches all of the procedure names.
  
Number of procedures Optional Available limit the number of the procedures listed.
  • Enabled when [Specify the number of procedures in the list] is checked.
  • Defaults to 500 if omitted. Defaults to 500 if omitted, or if the value specified is invalid.

Components pool settings

Component pool settings can be managed in Control Panel within the 'Global Resource Settings'.

Security

Security settings can be managed in Control Panel within the 'Global Resource Settings'.

About Connection parameters

When [Enter URL directly] is not checked, the following parameters will be added to the URL which is used to connect to the database.

MySQL 8.0 Adapter

Key Value Remarks
sslMode VERIFY_CA or DISABLED
  • [SSL connection] is checked
    "VERIFY_CA"
  • [SSL connection] is not checked
    "DISABLED"
useCursorFetch true  
allowPublicKeyRetrieval true  
serverTimezone <Timezone ID of DataSpiderServer>
  • The timezone of DataSpiderServer is used by default.
  • If you want to use the timezone of MySQL server, delete this parameter.

MySQL 5.7/5.6/5.5/5.1/5.0 Adapter

Key Value Remarks
useSSL true or false
  • [SSL connection] is checked
    "true"
  • [SSL connection] is not checked
    "false"
useCursorFetch true  

Sales and support for the following adapters are finished.

Notes