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 Specify the global resource name for FTP Adapter.  
Required settings
Item name Required/Optional Use of variables Description Remarks
Host name Required Only environment variables are available Enter the destination FTP server.  
Port number Required Only environment variables are available Enter the port number where the FTP service is provided.
  • Default value is “21”.
User name Required Only environment variables are available Select or enter a user name to login to the FTP server.

Specify either “anonymous” or “ftp”, in the case of anonymous FTP.		  
Password Optional Only environment variables are available Enter the password to login to the FTP server.

Specify an email address, in the case of anonymous FTP.		  
Data transmission mode Required Not available Select data transmission mode.
  • [PASV]: (default)
    When there is a Firewall between the FTP server to be connected and DataSpider, this mode is used.
  • [ACTIVE]:
    Normal FTP connection.
  
Encoding Required Only environment variables are available Select or enter the encoding for FTP server.

When you enter encoding, specify one of the encodings supported in Java SE Runtime Environment 8.
For more details, refer to “Supported Encodings” (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).
Connection timeout Optional Only environment variables are available Enter the connection timeout period in milliseconds.
  • Default value is "300000" and the value will be set to "300000" when you omitted.
  • Enter the value to be not less than 0.
  • If “0” is set, timeout does not occur.
Property actions
Item name Description Remarks
Connection test Check the connection to the host.
  • Only control connection will be checked.
Secure FTP settings
Item name Required/Optional Use of variables Description Remarks
Security type Required Not available Select security type when performing secure FTP connection.
  • [None]: (default)
    Normal FTP connection will be performed.
  • [SFTP]:
    SFTP connection using SSH will be performed.
  • [FTP over SSL/TLS]:
    FTP over SSL/TLS connection using SSL/TLS will be performed.
  
Private key Optional Only environment variables are available To connect by public key authentication, enter the file path of private key.

You can click [Browse] button to launch the file chooser and find the file.
  • Displayed when [SFTP] is selected in [Security type].
  • When there is no input, password authentication using [Password] is performed.
  • Specify the file path as an absolute path of DataSpider File System.
  • Except for the path separator "/”, restricted characters of DataSpider File System cannot be used.
Private key passphrase Optional Not available Enter the private key pass phrase.
  • Displayed when [SFTP] is selected in [Security type].
SSL/TLS connection type Optional Not available Select connection method when performing SSL/TLS connection.
  • [explicit]: (default)
    Connection will be performed in explicit mode.
  • [implicit]:
    Connection will be performed in implicit mode.
  • Displayed when [FTP over SSL/TLS] is selected in [Security type].
  • When connecting in the different mode from the one in the settings of destination server, it may take some time until an error will occur.
Security mechanism Optional Not available Select security mechanism used in AUTH command when connecting in explicit mode.
  • [SSL]: (default)
    Connection will be performed in AUTH SSL.
  • [TLS]:
    Connection will be performed in AUTH TLS.
  • Displayed when [explicit] is selected in [SSL/TLS connection type].
Client certificate Optional Only environment variables are available To connect by client certificate authentication, enter the file path of client certificate (PEM format).

You can click [Browse] button to launch the file chooser and find the file.
  • Displayed when [FTP over SSL/TLS] is selected in [Security type].
  • When there is no input, password authentication using [Password] is performed.
  • Specify the file path as an absolute path of DataSpider File System.
  • Except for the path separator "/”, restricted characters of DataSpider File System cannot be used.
Certificate passphrase Optional Not available Enter the client certificate passphrase.
  • Displayed when [FTP over SSL/TLS] is selected in [Security type].
Do not check server certificate Optional Not available Select whether or not to check validity of server certificate.
  • [Checked]: (default)
    Validity of server certificate will not checked.
  • [Not checked]:
    Validity of server certificate will be checked.
  • Displayed when [FTP over SSL/TLS] is selected in [Security type].
  • When [Not checked] is selected, you need to import a certificate to the keystore referred by DataSpiderServer.
    For details on how to import a certificate to key store, refer to "Import Certificate".

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.

Major Exceptions

Exception name Cause Solution
InvalidPropertyConfigurationException
<Property Name> is not entered.		 [<Property name>] is not entered. Enter [<Property name>].
java.io.UnsupportedEncodingException
<encoding>		 Unsupported encoding is entered in [Encoding]. Select or enter an encoding supported in Java SE Runtime Environment 8.
For more details, refer to “Supported Encodings” (http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html).
java.net.UnknownHostException
The host ”<host name>” is not found.		 Unable to connect to [Host name]. Check the settings.
InvalidPrivateKeyException
Private key file or private key pass phrase is invalid.		 Either the format of the specified [Private key] or the entered [Private key passphrase] is invalid. Check whether the [Private key] file of valid format is specified and [Private key passphrase] is valid.
InvalidCertificateException
Failed to load the client certificate. Check the file format or the passphrase.		 Either the format of specified [Client certificate] or the entered [Certificate passphrase] is invalid. Check whether the [Client certificate] file with valid format (PEM format) is specified and [Certificate passphrase] is valid.
com.enterprisedt.net.puretls.SSLCaughtAlertException
Expired certificate at handshake state SSL_HT_FINISHED or SSL_HS_WAIT_FOR_CHANGE_CIPHER_SPECS		 The client certificate has expired. Specify a client certificate that is still valid.
javax.net.ssl.SSLHandshakeException
The authenticity of server certificate cannot be verified.		 This error occurs when performing [FTP over SSL/TLS] connection and [Do not check server certificate] is [Not checked].
The cause is that authenticity of the server certificate could not be verified, because the server certificate registered in Java does not match with the one to perform SSL/TLS connection.		 Check whether the server certificate to perform SSL/TLS connection is registered in Java. When registered, check whether the destination server is same as the one registered in Java and the server certificate of destination is not expired.
com.enterprisedt.net.puretls.SSLPrematureCloseException
Short read		 Occurs when failed to connect with [FTP over SSL/TLS]. Check whether the server connectivity information such as [SSL/TLS connection type] is configured correctly.

Notes