Global Resource Properties

Connection Settings

The connection settings of global resource can be managed from the adapter properties, from "Global Resource Settings" within the Control Panel, or from WebConsole.
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.
  • Usually input "Public DNS" value.
Port number Optional Only environment variables are available. Enter the port number of database.
The default number is "3306". 		 
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 to make the SSL connection.
  • [Checked]:
    Make SSL connections.
  • [Not Checked]:(default)
    Do not make SSL connections.
  • To perform SSL communication between Amazon RDS 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.
    Download a certificate of region the DB instance resides in from "Using SSL to Encrypt a Connection to a DB Instance"(http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/UsingWithRDS.SSL.html).
    For how to import the private key and certificate, refer to Certificate Installation.
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 the number of tables listed.
  • Enabled when [Specify the number of tables in the list] is checked.
  • Defaults to 500 if omitted, or if the value specified is invalid.
Specify the number of procedures in the list Optional Not 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 Enter a number of procedures listed.
  • Enabled when [Specify the number of procedures in the list] is checked.
  • Defaults to 500 if omitted, or if the value specified is invalid.

Components pool settings

You can only edit Component Pool Settings from Control Panel, "Global Resource Settings" or WebConsole.

Security

You can only edit Security Settings from Control Panel, "Global Resource Settings" or WebConsole.