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, 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.  
Required settings
Item name Required / Optional Use of variables Description Remarks
URL Required Only environment variables are available. Enter the URL which connects to database.
  • Specify Cluster Database Properties-JDBC URL displayed in Amazon Redshift console screen.
  • User name Required Only environment variables are available. Enter the user name.  
    Password Required Only environment variables are available. Enter the password.  
    SSL connection Optional Not available Select whether to perform SSL connection or not.
    • [Checked]:
      Performs SSL connection.
    • [Not checked]:(default)
      Does not perform SSL connection.
    • To perform SSL correspondence between this adapter and Amazon Redshift, importing certification to keystore that is referred from DataSpiderServer is required.
      Get the certification from https://s3.amazonaws.com/redshift-downloads/redshift-ssl-ca-cert.pem.
      For how to import to key store, refer to "Importing certification".
    Socket Timeout(Seconds) Optional Only environment variables are available. Specify socket timeout value in seconds for the connection to Amazon Web Services.
    • Available values are from "0" to "2147483647".
    • If omitted, defaults to "60".
    • If the value is "0", timeout does not occur.
    Connection Timeout(Seconds) Optional Only environment variables are available. Specify connection timeout time when connecting Amazon Web Services into second unit.
    • Available values are from "0" to "2147483647".
    • If omitted, defaults to "60".
    • If the value is "0", timeout does not occur.
    Property Action
    Item name Description Remarks
    Connection Test Checks the connection to Amazon Redshift.  

    Component Pool Settings

    Component pool settings can be managed in "Global Resource Settings" within control panel, or WebConsole.

    Security Settings

    Security settings can be managed in "Global Resource Settings" within control panel, or WebConsole.

    Main Exceptions

    Exception name Cause Solution
    InvalidPropertyConfigurationException
    <Property name> is not specified.
    [<Property name>] is not specified. Specify [<Property name>].