Uploading data using SFTP

Before you can upload a data file:

  • You must have FTP client software which supports the SFTP protocol and AES-256 cypher strength (most recent clients offer this support as standard) such as WinSCP, FileZilla and the PuTTY PSFTP program.
  • You must have the domain name of the Workspaces SFTP server, which can be supplied by your Workspace Administrator or your organisation's Service Desk.
 

Connecting to the SFTP using WinSCP

To upload data using the SFTP service using the popular SFTP client WinSCP you must:

  • Download and install the WinSCP client – https://winscp.net/eng/download.php.
  • Start the WinSCP client.
  • Insert your SFTP credentials:
    • host name: xxxxxxx@host.com
    • username: your Workspaces username
    • password: your password
    • click 'Login'
  • Select the files to upload from your local machine and drag them to the data upload folder – this example uses the Iris dataset.
  • Drag and drop iris.csv to the Data folder.SFTP using WinSCP, grabbed on 17.01.17, using XAP version 1.19.1 2740-8759a, from https://edcvaatest04.aridhiatest.net/#
  • Once the data file has been copied in full to the Data folder, the platform will automatically start to load the data into the workspace.

Once the data processing has been completed a log file reporting the success or failure of the upload, giving detailed information on the process of how data was loaded in case of the successful upload, or why the upload failed is created in the upload folder. The resulting file has a name in the following format:

<filename>_<success/fail>_<year>
<month>
<day>_<hours>
<mins>
<secs>.txt

For example:

iris_success_20160306_121535.txt
iris_fail_20160307_142743.txt

The time needed to upload and process the data is dependent on the size of the data file and the speed of the network connection. If your SFTP client supports it, enabling compression can reduce the transfer time.

Updated on June 19, 2019

Was this article helpful?

Related Articles

Not the solution you were looking for?
Click the link below to submit a support ticket
CONTACT SERVICE DESK