Acquia CDP

SFTP storage

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.

Did not find what you were looking for?

If this content did not answer your questions, try searching or contacting our support team for further assistance.

Acquia Help

Filter by product:

Acquia CDP common questions