Skip to main content

Trella Health SFTP

  • Updated

Overview

SFTP (Secure File Transfer Protocol) is a method for transferring files between two computers. It is secure and requires a username and private key to access the SFTP server.

Each customer who has access to Trella Health SFTP is contracted with Trella Health to receive Trella Health Marketscape data. New data will be made available quarterly to customer via SFTP, as a single zip file. This document outlines the process of receiving data via Secure File Transfer Protocol (SFTP).

Special Values


Some or all of these may be present in the data and require special interpretation when encountered.
-1 = <11 (privacy suppression)
-2 = -, or NULL
-3 = INS (insignificant/insufficient data; this commonly appears for rates when the denominator is too small, or sometimes quarterly counts with a nondistinct total, which would otherwise allow a user to derive the value of a related suppressed field)
-4 = -, or NULL (Identical to -2, used for formatting/internal reasons)
-5 = Blank (Cannot Total or N/A)

 

Note-width35.png A Data dictionary for this is not available. Many of the metrics in the FTP data already exist in Marketscape. If you have questions about a specific metric, please visit the corresponding Help Center:

Throughout this process, if you have questions, please forward them to ftpsupport@trellahealth.com

 

Download Process

SFTP is a method for obtaining files between two computers. SFTP is secure which requires a username and private key to access the SFTP server. Trella Health has an additional layer of security which includes IP filtering from requestors. Thus, we will need the IP addresses from which the Trella Health SFTP will be accessed. 

Trella Health will provide an SFTP location (URL) and make a test file available for download once the IP security is established. Once the test file is available, a notification email will be sent to the customer announcing the test file’s availability. Customer should then download the file and confirm success. 

Once the initial test file successfully transfers, all tables will be posted to the SFTP server and made available to the customer for download. A notification email will be sent to the customer announcing the full download availability. Every quarter the notification email will be sent announcing the full download availability. A brief description of specific changes/updates will be included with each quarterly release as a changelog text file. 

Customer action steps: 

  • Gather IP addresses (or range) from which customer will access SFTP and email IP addresses to Trella Health team 

  • Ensure enough disk space to store the data files. For 50 states, you’ll need approximately 5GB of storage.

  • Customer database administrator (DBA) to review requirements and ensure the customer environment can support the database. 

 

Establishing Connectivity

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

There are many free products available for download to establish an SFTP connection including;

Specific instructions for connecting to the SFTP server with these products are provided next.

 

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 Customer Success team is available to work with you and ensure success by emailing ftpsupport@trellahealth.com. 

Related articles