Global Resource Properties

Connection Setting

Set global resource in the adapter properties, "Global Resource Settings" in the Control Panel, or WebConsole.
Basic settings
Item name Required / Optional Use of Variables Description Remarks
Name Required Not available Specify the name of global resource used by the FTP adapter.  
Required settings
Item name Required / Optional Use of Variables Description Remarks
Hostname Required Only environment variables are available. Enter the FTP server to connect.  
Port number Required Only environment variables are available. Enter the FTP port number that the service provided.
  • The default value is "21".
User name Required Only environment variables are available. Select or type the FTP user name to login to the server.

To connect to an anonymous FTP server, specify "anonymous" or "ftp" if anonymous.
 
Password Optional Only environment variables are available. Enter the password to log into the FTP server.

Enter email address if anonymous.
 
Data transfer mode Required Not available Select data transfer mode.
  • [PASV]: (default)
    Use this mode if there is a fire wall between DataSpider and FTP servers.
  • [ACTIVE]:
    Regular FTP connection.
 
Encoding Required Not available Select the encode of the FTP server.

Use only the canonical name supported by Java SE Runtime Environment 8 when specifying the encoding directly in the field.
Refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html) for details.
  • For information regarding the default values used, refer to "Default encoding".
  • You are allowed to select from the list only when WebConsole is used.
Connection time out Optional Only environment variables are available. Enter the time of connection time out in milliseconds.
  • The default value is "300,000", and if omitted the "300,000" is set.
  • Please enter a value greater than zero in the numbers.
  • There is no timeout if"0" is set
Property Action
Item name Description Remarks
Connection Test Checks the connection to the host.
  • Confirms the connectivity of the control connection only.
Secure FTP settings
Item name Required / Optional Use of Variables Description Remarks
Security type Required Not available Select the security type when connect to the secure FTP.
  • [None]: (default)
    Perform regular FTP connection.
  • [SFTP]:
    Connect to SFTP using SSH.
  • [FTP over SSL/TLS]:
    Connect to FTP over SSL/TLS using SSL/TLS.
 
Private key Optional Only environment variables are available. Input the private key file path when connect to the public key authentication.

Click [Browse] button to activate the file Selectr and Select the file.
  • [Security type] will be displayed if Select [SFTP].
  • If there is no input, [Certificate passphrase] will be used to authenticate.
  • Please specify an absolute path in the DataSpider file system.
  • Constrained characters of DataSpider File System cannot be used except for path separator "/".
Private key passphrase Of omitting Not available Enter the private key passphrase.
  • [Security type] will be displayed if Select [SFTP].
SSL/TLS connection type Optional Not available Select the SSL/TLS connection when making a connection.
  • [explicit]: (default)
    make the connection in explicit mode.
  • [implicit]:
    make the connection in implicit mode..
  • [Security type] will be displayed if Select [FTP over SSL/TLS].
  • It may take some time to get an error when connected to the server with a different mode.
Security mechanism Optional Not available Select a security mechanism which is used in AUTH command when connecting as explicit mode.
  • [SSL]:(default)
    Connects as AUTH SSL.
  • [TLS]:
    Connects as AUTH TLS.
  • It shows when selected [explicit] in [SSL/TLS connect type].
Client certificate Optional Only environment variables are available. Input the file path of client certificate file (PEM format) when connect to the client certificate authentication.

Click [Browse] button to activate the file Selectr and Select the file.
  • [Security type] will be displayed if Select [FTP over SSL/TLS].
  • If there is no input,[Password] to authenticate using a password.
  • Please specify an absolute path in the DataSpider file system.
  • Constrained characters of DataSpider File System cannot be used except for path separator "/".
Certificate passphrase Of omitting Not available Enter the client certificate passphrase.
  • [Security type] will be displayed if Select [FTP over SSL/TLS].
Do not check server certificates Optional Not available Select whether to check the validity of the server certificate.
  • [Checked]: (default)
    Not check the validity of the server certificate.
  • [Not Checked]:
    Check the validity of the server certificate.
  • [Security type] will be displayed if Select [FTP over SSL/TLS].
  • A certificate needs to be imported into the keystore referenced by DataSpiderServer if [Not Checked] is selected.
    For information regarding how to import to the keystore, refer to "Import of certificate".

Component pool settings

You can edit the Component pool settings from Control Panel, "Global Resource Settings" or WebConsole.

Security

Security Settings can be managed from "Global Resource Settings" within Control Panel or from WebConsole.

Main exception

Exception name Causes Solution
InvalidPropertyConfigurationException
<Property name> is not specified.
[<Property name>] is not specified. Specify [<Property name>].
java.io.UnsupportedEncodingException
<Encoding>
An encode not supported in [Encoding] is entered. Select or specify encode supported in Java SE Runtime Environment 8.
Refer to "Supported Encodings"(http://docs.oracle.com/javase/8/docs/technotes/guides/intl/encoding.doc.html) for details.
java.net.UnknownHostException
"Host <host name>" could not be found.
[Hostname] can not be connected. Check the setting.
InvalidPrivateKeyException
The format of private key file or the passphrase of private key is not correct.
The form of [Private key] is incorrect or [Private key passphrase] is incorrect. Specify the form of [Private key] or check the [Private key passphrase].
InvalidCertificateException
Failed to load the client certificate.Check the format or passphrase.
The form of [Client certificate] is incorrect or [Certificate passphrase] is incorrect. Specify the correct form of [Client certificate],or check the [Certificate passphrase].
com.enterprisedt.net.puretls.SSLCaughtAlertException
Expired certificate at handshake state SSL_HT_FINISHED or SSL_HS_WAIT_FOR_CHANGE_CIPHER_SPECS
Client certificate has expired. Specify the client certificate that does not expire.
javax.net.ssl.SSLHandshakeException
Unable to validate the reliability of the server certificate.
It occurs when selected [Not Checked] in [Do not check server certificates] when connect to [FTP over SSL/TLS].
The reason is that the server certificate registered in Java is different from the one that is used to SSL/TLS connection,so the validity cannot be verified.
Check if the server certificate is registered in JAVA when connecting to SSL/TLS server. If registered,check if the server is the same as the one registered in JAVA and check if the server certificate has expired.
com.enterprisedt.net.puretls.SSLPrematureCloseException
Short read
Occurs when fail to connect to [FTP over SSL/TLS]. Check if the information used to connect to [SSL/TLS connection type] is correct.

Notes