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 the type of destination database.
  • You can only select the database of the editing operation.
Required settings
Item name Required/Optional Use of variables Description Remarks
Host name Required Only environment variables are available Enter the host name.
  • In general, it is the value of “Public DNS”.
  • Disabled when [Enter URL directly] is checked.
Port number Optional Only environment variables are available Enter the database port number.
Default number is 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&rdquo.
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 a 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 RDS, you need to import a certificate to the keystore referred by DataSpiderServer.
    Download the certificate of the region where the DB instance exists from “Using SSL to Encrypt a Connection to a DB Instance” (http://docs.aws.amazon.com/ja_jp/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html).
    For details on how to import a certificate to key store, refer to "Import Certificate".
  • Disabled when [Enter URL directly] is checked.
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.

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.

Amazon RDS for 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  
useUnicode true  
characterEncoding utf8  
characterSetResults utf8  
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.

Amazon RDS for MySQL 5.7/5.6/5.1 Adapter

Key Value Remarks
useSSL true or false
  • [SSL connection] is checked
    「true」
  • [SSL connection] is not checked
    「false」
requireSSL true
  • [SSL connection] is checked
    「true」
  • [SSL connection] is not checked
    Not added
useCursorFetch true  
useUnicode true  
characterEncoding utf8  
characterSetResults utf8  

Sales and support for the following adapters are finished.