Information for: DEVELOPERS   PARTNERS

sFTP Storage

When you create a segment in Customer Data Platform (CDP) Actions, you can send the output to an sFTP location. You can add new sFTP locations and also change the parameters of the sFTP output connector.

sftp

sftp_1

Create a new sFTP

To add a new sFTP connector, send a request to Support or ask your CDP Customer Success Manager with the following information:

  • Connector name (e.g. “sFTP - Monetate”)
  • host (e.g. sftp1.agilone.com)
  • username
  • password
  • IP to allowlist if applicable

Alternatively, you can use a key-based authentication instead of a password based authentication. In such a case, you need to provide CDP with a private .pem SSH key. The keys should be created without any passphrase.

Update the parameters to an existing connector

There are some parameters that you can change by sending a request to support. Be aware that the changes will apply to all files exported to that connector going forward.

Parameter Values Description
filename.date.format Date format (e.g. yyyy-MM-dd) Date format that is appended to the end of the file name
date.column.date.format

Date format (e.g. yyyy-MM-dd)

Default: epoch timestamp

Datetime format that is used when the output columns are dates (e.g. First Transaction Date)
date.column.date.format.timezone

Time zones

Default: UTC

Timezone to be used for output columns are dates (e.g. 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 exectionID column is included at the end of the output CSV file
output.file.extension

csv, tsv, txt, or NO_EXTENSION

Default: csv

 File extension
sftp.delimiter

Comma, pipe, tab, etc.

Default: comma

The delimiter to use to separate fields within a row. Single ASCII character that you would like to delimit data with.