To use an SFTP location, you must select the SFTP Output option on the Select Channel screen:
Creating a new SFTP connector
To add a new SFTP connector, send a request to Support or your customer value manager (CVM), and provide the following information:
Connector name such as “SFTP - Monetate”
Host name such as “sftp1.agilone.com
Username
Password
IP address to allowlist if applicable
You can use a key-based authentication instead of a password-based authentication by providing Customer Data Platform (CDP) with a private .pem SSH key. The keys must not have passphrases.
Updating the parameters to an existing connector
You can change the following parameters by sending a request to Support. The changes apply to all files that are exported to that connector going forward.
Parameter | Values | Example | Description |
|---|---|---|---|
filename.date.format | Date format | YYYY-MM-DD | Date format that is appended to the end of the file name. |
date.column.date.format | Date format Default: epoch timestamp | YYYY-MM-DD | Datetime format that is used when the output columns are dates. For example, first transaction date. |
date.column.date.format.timezone | Time zones Default: UTC | – | Timezone that is used when the output columns are dates. For example, first transaction date. |
pgp.public.key | PGP public key Default: none | – | Public encryption key if the output file should be encrypted. |
exclude.execution.id | true or false Default: false | – | This determines whether the executionID column is included at the end of the output CSV file. |
output.file.extension | File extension Default: csv | csv, tsv, txt, or NO_EXTENSION | File extension |
sftp.delimiter | Comma, pipe, tab, etc. Default: comma | – | The delimiter to use to separate fields within a row. Use a single ASCII character to delimit data. |