Skip to main content
日本語

FTP Connector - How to set up connection resource and use connector

  • Updated

Preparing FTP service connection information

Prepare connection information for an FTP server.
The following values will be used in the 'Creating connection resource' section below:

-Host name
-Port number
-User name
-Password
-Data transmission mode
-Encoding

 

Creating connection resource

To use the FTP Connector in HULFT Square, you need to create a connection resource first.

1. In HULFT Square, go to [Main] > [DATA INTEGRATION] > [Connections] and click [Add New].

2. In the Type section, select [FTP] for Connector and [FTP connection] for Type, then click [Next].

3. In the General section, set the name of the connection resource, workspace (optional), and description (optional), then click "Next."

4. In the Settings section, set the parameter values required for the connection.
　To verify the connection with the entered values, click [Verify Connection].

Item name Description Required Remarks
Host name Enter the destination FTP server.

○

 
Port number Enter the port number where the FTP service is provided. ○
  • Default value is "21".
User name Select or enter a user name to login to the FTP server.
Specify either “anonymous” or “ftp”, in the case of anonymous FTP. 		○  
Password Enter the password to login to the FTP server.
Specify an email address, in the case of anonymous FTP. 		   
Data transmission mode Select data transmission mode.
  • [PASV]: (default)
    This mode is used if the conditions below are satisfied:
    • There is a Firewall between the FTP server to be connected and HULFT Square.
    • Perform SFTP connection using HTTP proxy.
  • [ACTIVE]:
    Normal FTP connection.
 ○  
Encoding

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 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.
Security type 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 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 storage path.
  • Except for the path separator "/”, Restricted characters cannot be used.
Private key passphrase Enter the private key pass phrase.  
  • Displayed when [SFTP] is selected in [Security type].
Use the HTTP proxy server Select whether or not to use the HTTP proxy server.
  • [Checked]:
    Use the HTTP proxy server.
  • [Not checked]:(default)
    Not use the HTTP proxy server.
  
  • Displayed when [SFTP] is selected in [Security type].
HTTP proxy host Enter the HTTP proxy server's host address.  
  • Displayed when [SFTP] is selected in [Security type].
  • If [Use the HTTP proxy server] is checked, this field becomes valid and required.
HTTP proxy port Enter the HTTP proxy server's port number.  
  • Displayed when [SFTP] is selected in [Security type].
  • If [Use the HTTP proxy server] is checked, this field becomes valid and required.
SSL/TLS connection type 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 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 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 cannot be used.
Certificate passphrase Enter the client certificate passphrase.  
  • Displayed when [FTP over SSL/TLS] is selected in [Security type].
Do not check server certificate 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].

 

5. When Verify connection dialog box opens, set [Integrate service] and [Profile to load resources] and click "OK".
Verification test result will appear on dialog box.

6. If there are no problems, click "Finish" to complete connection resource settings.
Now you have a FTP connection resource.

 

Setting up Connector

Here is an example of using the FTP Connector on a script using the connection resource added above.

Example: Setting up FTP Connector [Get List and Data] operation

Drag and drop [Network] > [FTP] > [Get List and Data] onto the script canvas to open the properties dialog.

The setting values for each item in the required settings tab are as follows:

-Destination: Select the FTP connection resource name created in the Creating a Connection resource section.
-Path/Remote path: Enter the file/directory in the FTP server with an absolute path starting with “/”.

Related articles

Comments

0 comments

Article is closed for comments.