Trella Health SFTP User Guide

Overview 

For customers who are contracted with Trella Health to receive Marketscape data, data files are made available via SFTP. This document outlines the process of receiving Trella Health data via Secure File Transfer Protocol (SFTP). 

• Overview 

• Deliverable File Structure

• Data Available

• Data Download Process 

• Establishing Connectivity

  • Using Cyberduck

  • Using FileZilla

  • Using WinSCP

  • Using OpenSSH

• Technical Support

Establishing Connectivity

SFTP is a method for obtaining files between two computers. SFTP is secure and requires a username and private key (both provided by Trella Health) to access the SFTP server.

The Trella Health SFTP server URL is located at sftp.trellahealth.com. You provide the SFTP server URL, username, and private key to a SFTP client software which will then allow you to transfer files to and from the Trella Health SFTP server.

There are many free products available for download to establish an SFTP connection. Some SFTP clients are listed below along with detailed instructions.

SFTP Clients

A username and private key will be provided to you by Trella.

• Cyberduck: https://cyberduck.io/ [Windows, Macintosh, and Linux]

• Filezilla: https://filezilla-project.org/ [Windows, Macintosh, and Linux]

• WinSCP: https://winscp.net/ [Microsoft Windows only]

• OpenSSH: https://www.openssh.com/ [Macintosh, and Linux]

Using Cyberduck

Use these instructions to transfer files using Cyberduck.

1. Open the Cyberduck client.

2. Choose Open Connection.

3. In the Open Connection dialog box, choose a protocol: SFTP (SSH File Transfer Protocol).

4. For Server, enter the SFTP server endpoint (i.e. sftp.trellahealth.com).

5. For Port number, enter the following:

   • 22 for SFTP

6. For Username, enter the username that was provided to you by Trella Health.

7. Do not enter a password. Instead, enter the SSH private key file that was provided to you by Trella Health in the SSH Private Key field.

8. Choose Connect.

9. Perform your file transfer.

Using FileZilla

Use these instructions to transfer files using FileZilla.

1. Open the FileZilla client.

2. Choose File, and then choose Site Manager.

3. In the Site Manager dialog box, choose New site.

4. On the General tab, for Protocol, choose SFTP.

5. For Host name, enter the SFTP server endpoint (i.e. sftp.trellahealth.com).

6. For Port number, enter the following:

   • 22 for SFTP

7. For Logon Type, choose Key file.

   For Key file, enter the SSH private key that was provided to you by Trella Health.

8. For User, enter the username that was provided to you by Trella Health.

9. Choose Connect.

10. Perform your file transfer.

Using WinSCP

Use these instructions to transfer files using WinSCP.

1. Open the WinSCP client.

2. In the Login dialog box, for File protocol, choose SFTP.

3. For Host name, enter the SFTP server endpoint (i.e. sftp.trellahealth.com).

4. For Port number, enter the following:

   • 22 for SFTP

5. For User name, enter the username that was provided to you by Trella Health.

6. Choose Advanced to open the Advanced Site Settings dialog box. In the SSH section, choose Authentication.

7. For Private key file, browse for and choose the SSH private key file provided to you by Trella Health.

   Note

   If WinSCP offers to convert your SSH private key to the PPK format, choose OK.

8. Choose OK to return to the Login dialog box, and then choose Save.

9. In the Save session as site dialog box, choose OK to complete your connection setup.

10. In the Login dialog box, choose Tools and then choose Preferences.

11. In the Preferences dialog box, for Transfer, choose Endurance.

    Choose Disable for the Enable transfer resume/transfer to temporary filename for option.

    Note

    If you leave this option enabled, it substantially decreases upload performance. It also can lead to failures of large file uploads.

12. For Transfer, choose Background, clear the Use multiple connections for single transfer check box.

    Note

    If you leave it selected, this approach can cause large file uploads to fail in unpredictable ways. An example includes creating orphaned multipart uploads and silent data corruption.

13. Perform your file transfer.

    You can use drag-and-drop methods to copy files between the target and source windows. You can use toolbar icons to upload, download, delete, edit, or modify the properties of files in WinSCP.

Note

Be sure to disable WinSCP timestamp settings before you perform file transfers. To do so, in the WinSCP Transfer settings dialog box, disable the Set permissions upload option and the Preserve timestamp common option.

Using OpenSSH

Use these instructions to transfer files using OpenSSH.

1. On Linux or Macintosh, open a command terminal.

2. At the prompt, enter the following command: % sftp -i transfer-key sftp_user@service_endpoint

   In the preceding command, sftp_user is the user name and transfer-key is the SSH private key, both of which are provided by Trella Health. Here, service_endpoint is the server's endpoint (i.e. sftp.trellahealth.com).

   An sftp prompt should appear.

Technical Support

Throughout this process, the Trella Health technology team is available to work with you and ensure success by emailing ftpsupport@trellahealth.com.