FTP/SFTP Data Connection

Version 

Application Scenario

To enable users to read Excel and CSV file data from FTP or SFTP servers and process them in FineDataLink, FineDataLink supports FTP/SFTP-based data connections.

Connection Information Collection 

Collect the following information before connecting FineDataLink to the database.

• IP address and port number of the database server

• Username and password

1. Log in to FineDataLink as the admin, choose System Management > Data Connection > Data Connection Management, and click New Data Connection.

Note: If you are not the admin, you can configure data connections only after the admin assigns you permission on Data Connection under Permission Management > System Management. For details, see Data Connection Management Permission. 

2. Click the FTP/SFTP icon.

3. Fill in the connection information. 

4. Click Test Connection. If the connection is successful, click Save to save the configuration.

You can fetch specified data from an FTP or SFTP directory using File Input (in Data Transformation), Data Synchronization, and Parameter Assignment nodes, as shown in the following figures.

For details, see File Input Description.