Getting Your Data Securely Into Clario

Four letters: SFTP

Connection Details

Connection Details

Host name: sftp.clar.io

Username: see the Integrations - Supplemental Details document provided by Customer Success

Password: Key based authentication only

Port: 22

Getting Connected

Upload large data files into Clario using any application that supports Secure File Transfer Protocol (SFTP). If your account was provisioned prior to April 2022, your login credentials will be the same as your Clario username and password. For accounts provisioned after After 2022, you will need to use the username provided by Customer Success in the Supplemental Credentials document. Non-interactive authentication is supported via public-key exchange. See Public Key Exchange for details on getting set up.

Upload all files to the /toClario folder for automated processing.

What Happens Next?

Once a file has been received an attempt is made to determine the file type. The process is represented below:

The process highlighted in green represents the preferred path for getting data into Clario.

• If the file is a single archive gzip file, the gz/gzip extension is removed and the file is uploaded as-is. This is the fastest way to get a file into Clario. Sending a file in gzip format obviates the need for us to decompress, verify, and compress the file, speeding up the overall transfer/upload time.

• If the file is a multi archive zip file, it is decompressed into its constituent files. An attempt is then made to identify the type of each file from the archive.

• If the file is a plain text file, the file is gzipped and uploaded.

• If the file is of an unknown type, it is rejected with an error message (sent via email if SFTP notifications are enabled) indicating what was determined about the suspect file. The file is then deleted.

Accepted File Formats

Clario accepts ASCII plain-text files with the following extension types: .txt, .csv, .dat. Files may be either space or character delimited; field separators are optional. Clario also accepts Excel files of type .xlsx. Clario supports SFTP file uploads for extremely large files, with a maximum size of 5 Terabytes (TB) each.

Be Aware

We are unable to accept UTF-8 BOM encoded, UTF-16 or UTF-16 BOM encoded text files at this time. If you send them, they will be automatically rejected.

Compression

While optional, Clario recommends compressing files to minimize transmission time and storage overhead.

We currently accept the following forms of compression:

• gzip compressed individual files

• zip compressed groups of files (nested zip archives are not supported)

Be Aware

Encrypted or password protected archives are not supported and automatically rejected. Please ensure all compressed files are free of encryption or password protection.

Best Practices

Clario recommends sending files that are gzip compressed. This format ensures the greatest level of compatibility and availability for uploaded data.