Criteo SFTP¶

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.
9. Drag and drop the feed file into the "remote site" side of Filezilla.

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.

You can establish an SSH connection and then open up an SFTP session using that connection by issuing the following command.

Example

$ sftp {{ftpusername}}@data-sftp.criteo.com
Password authentication

# Put your password to connect
Password: {{ftppassword}}
Connected to {{ftpusername}}@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

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.

sftp {{ftpusername}}@data-sftp.criteo.com


Example

#To get connected, you need to be on the directory where your Private key is saved:
n.user@deviceid MINGW64 ~/.ssh$ sftp {{ftpusername}}@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/n.user/.ssh/id_rsa':
Connected to {{ftpusername}}@data-sftp.criteo.com.

# You are connected
sftp>bye

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

sftp -i file_path_containing_private_key {{ftpusername}}@data-sftp.criteo.com


Example

#Add the file path containing the private key to the command line:
$ sftp -i "C:\Users\n.user\.ssh\id_rsa" {{ftpusername}}@data-sftp.criteo.com
Enter passphrase for key 'C:\Users\n.user\.ssh\id_rsa':
Connected to {{ftpusername}}@data-sftp.criteo.com.

# You are connected
sftp>bye