Criteo SFTP

A guide to upload product feed to Criteo SFTP via FileZilla or Command Line.

Overview

This tutorial will explain how to upload your feed to the Criteo SFTP via FileZilla or Command Live with/without SSH Key

Download

Please follow this link to download Filezilla client: link to download

Options

FileZilla Platform without SSH KEY
  1. Open FileZilla → File → Site Manager
  2. Protocol: "SFTP - SSH File Transfer Protocol"
  3. Host: "data-sftp.criteo.com"
  4. Port: You can leave it empty.
  5. Logon Type: Normal.
  6. Enter the User/Password generated for you.
    • {{ftpusername}}
    • {{ftppassword}}
  7. Press Enter to connect to the server.
  8. Click OK when you get a warning about an unknown host key.
FileZilla Platform with SSH KEY

We assume that you have already created an SSH key pair on your server. Please share this key with us so we can configure on our side as well. Please note that you will be able to access our server after 24 hours from the time that configuration is done on our side.

  1. Open FileZilla → File → Site Manager
  2. Protocol: "SFTP - SSH File Transfer Protocol"
  3. Host: "data-sftp.criteo.com"
  4. Port: You can leave it empty.
  5. Logon Type: Key File.
  6. User: Enter the User/Password generated for you.
    • {{ftpusername}}
    • {{ftppassword}}
  7. Key File: using the Browser button, you have to indicate the path of your private key.
  • FileZilla can ask you to convert they Private Key if the format of yours isn't supported:
  • Enter the password used for your SSH key
  • Press Enter to connect to the server.
Command Line without SSH KEY

You can establish an SSH connection and then open up an SFTP session using that connection by issuing the following command. Don't forget to replace your_username with your username.

sftp your_username@data-sftp.criteo.com

Example


$ sftp top_72b037da-9bee-4e23-b6a9-3e62984f3ab1@data-sftp.criteo.com
Password authentication

# Put the password generated on TOP to connect
Password:
Connected to top_72b037da-9bee-4e23-b6a9-3e62984f3ab1@data-sftp.criteo.com.

# Get Help in SFTP
sftp>help
Available commands:
bye                                Quit sftp
cd path                            Change remote directory to 'path'
chgrp grp path                     Change group of file 'path' to 'grp'
chmod mode path                    Change permissions of file 'path' to 'mode'
chown own path                     Change owner of file 'path' to 'own'
df [-hi] [path]                    Display statistics for current directory or filesystem containing 'path'
exit                               Quit sftp
get [-afPpRr] remote [local]       Download file
reget [-fPpRr] remote [local]      Resume download file
reput [-fPpRr] [local] remote      Resume upload file
help                               Display this help text
lcd path                           Change local directory to 'path'
lls [ls-options [path]]            Display local directory listing
lmkdir path                        Create local directory
ln [-s] oldpath newpath            Link remote file (-s for symlink)
lpwd                               Print local working directory
ls [-1afhlnrSt] [path]             Display remote directory listing
lumask umask                       Set local umask to 'umask'
mkdir path                         Create remote directory
progress                           Toggle display of progress meter
put [-afPpRr] local [remote]       Upload file
pwd                                Display remote working directory
quit                               Quit sftp
rename oldpath newpath             Rename remote file
rm path                            Delete remote file
rmdir path                         Remove remote directory
symlink oldpath newpath            Symlink remote file
version                            Show SFTP version
!command                           Execute 'command' in local shell
!                                  Escape to local shell
?                                  Synonym for help

# Display remote working directory
sftp> pwd
Remote working directory: /

# Transfer Local Files to the Remote System
sftp> put test.csv
Uploading test.csv to /test.csv
test.csv

# Delete remote file
sftp> rm test.csv
Removing /test.csv

# Change remote directory to vlookup directory
sftp> cd vlookup
sftp> pwd
Remote working directory: /vlookup

# Quit sftp
sftp> bye

Command Line with SSH KEY

We assume that you have already created an SSH key pair on your server. Please share this key with us so we can configure on our side as well. Please note that you will be able to access our server after 24 hours from the time that configuration is done on our side. Since you'll use the SSH key, you don't need the password generated, only the password used for your Private SSH key called key passphrase.

You have 2 options:

  1. Launch the following command from the he directory where the Private Key is saved. Don't forget to replace your_username with your username.

  2. sftp your_username@data-sftp.criteo.com

    Example

    
    #To get connected, you need to be on the directory where your Private key is saved:
    m.remki@L7H1XZF2 MINGW64 ~/.ssh$ sftp top_378d0b0a-3622-47c2-bcf5-e1d4ec155029@data-sftp.criteo.com
    
    # Enter the password used for your SSH key (not to be confused with the password generated on TOP)
    Enter passphrase for key '/c/Users/m.remki/.ssh/id_rsa':
    Connected to top_378d0b0a-3622-47c2-bcf5-e1d4ec155029@data-sftp.criteo.com.
    
    # You are connected
    sftp>bye
    
    
  3. Add the path containing the private key to the command line as follows. Don't forget to replace the fields below with your private key and your username.

  4. sftp -i file_path_containing_private_key your_username@data-sftp.criteo.com

    Example

    
    #Add the file path containing the private key to the command line:
    $ sftp -i "C:\Users\m.remki\.ssh\id_rsa" top_378d0b0a-3622-47c2-bcf5-e1d4ec155029@data-sftp.criteo.com
    Enter passphrase for key 'C:\Users\m.remki\.ssh\id_rsa':
    Connected to top_378d0b0a-3622-47c2-bcf5-e1d4ec155029@data-sftp.criteo.com.
    
    # You are connected
    sftp>bye