Clario
  • Welcome
  • Platform Documentation
    • Release Notes
    • Audiences Beta
    • Clario Marketing Measurement Attribution Methods
  • Configuration
    • Ad Engine URL Tracking Parameters
  • Connecting Your Data
    • Adobe Analytics
    • Apple Search Ads
    • AppsFlyer
    • Attentive
    • AvantLink
    • Behavioral Data Collection
      • Google Tag Manager
      • Tealium
    • Braze
    • CJ Affiliate
    • Criteo
    • Facebook
    • First Party
      • Google Cloud Analytics Hub
      • Getting Your Data Securely Into Clario
        • Public Key Exchange
    • Google Ads
    • Google Analytics 360
    • Google Analytics 4
    • Impact.com
    • Klaviyo
    • Listrak
    • Microsoft Ads
    • NetSuite
    • Pinterest
    • Qualtrics
    • Rakuten
    • RTB House
    • Salesforce Marketing Cloud
      • Requirements
      • Set Up Destination for Data Feeds
      • Create Data Extract Activities
      • Create Data Transfer Activity
      • Create Tracking Export Automation
    • ShareASale
    • Shopify
    • Snapchat
    • Snowflake
    • TikTok
    • The Trade Desk
    • Yahoo Ad Tech
  • Getting Data out of Clario
    • Google Cloud Analytics Hub
    • In-Store Conversions
      • Google Ads
      • Meta
  • Collecting Business Logic
    • Web Analytics Tools
      • Adobe Analytics Channel Groupings
      • Google Analytics Channel Groupings
  • Reference
    • Videos
Powered by GitBook
On this page
  • Connection Details
  • Getting Connected
  • What Happens Next?
  • Accepted File Formats
  • Compression
  • Best Practices
  1. Connecting Your Data
  2. First Party

Getting Your Data Securely Into Clario

Four letters: SFTP

PreviousGoogle Cloud Analytics HubNextPublic Key Exchange

Last updated 2 years ago

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 (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 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

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.

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 each.

Terabytes (TB)
Secure File Transfer Protocol
Public Key Exchange